IT Support Service Level-3 p-3

What is the primary function of spreadsheet software?

• Creating and editing text documents

• Creating and editing images and graphics

• Creating and managing numerical data and calculations

• Designing presentations

An excel workbook is a collection of?

• Workbooks

• Worksheets

• Charts

• Worksheets and charts

Which effect we see as the slides of a PowerPoint changes over

• Animation

• Timing 

• Effect

• Transition

In Excel, what does the term "data validation" refer to?

• Checking for errors in formulas

• Ensuring data accuracy through validation rules

• Protecting data from unauthorized access

•  Sorting data in ascending order

In Excel, what does the function COUNTA() do? 

• Counts the number of cells in a range that are not blank

• Counts the number of cells in a range that are greater than zero

• Counts the number of cells in a range that contain text

• Counts the total number of cells in a range

What happens when you click on CTRL + X after selecting some cells in Excel?

• The cell content of selected cells disappears from cell and stored in clipboard

• Value in the cells selected are marked for cutting 

• The selected cells are deleted and the cells are shifted left

• The selected cells are deleted and cells are shifted up

The Greater Than sign (>) exemplifies a/an____________operator.

• Arithmetic

• Conditional

• Logical

• Greater

A saved document is referred to as a?

• file

•  word

• folder

•  project

Which of the following is considered an output peripheral in a computer system?

•  Mouse

• Monitor

• Hard Drive

• Keyboard

The place where accessories are connected in computer is known as

• Port

• Ring

• Bus

• Zip