AFL-SPREADSHEET

Which of the following is an example of a spreadsheet software?

• Microsoft Word

• Adobe Photoshop

• Microsoft Excel

• Mozilla Firefox

In a spreadsheet, a cell is identified by its:

• Row number only

• Column letter only

• File name

• Combination of row number and column letter

Which symbol is used to start a formula in a spreadsheet?

• #

• @

• =

• $

Which feature allows you to copy the same formula to multiple cells automatically?

• Autofill

• Filter

• Sort

• Merge

Which of the following is the cell reference for the cell in the third column and fifth row?

• A5

• C5

• B3

• E3

In a spreadsheet, what is the purpose of the ‘SUM’ function?

• To subtract numbers

• To divide numbers

• To count the number of cells

• To calculate the total of a range of numbers

What this icon represent in spreadsheet?

What this icon represent in spreadsheet?

Identify the type of chart..

• Pie

• Line

• Area

• Bar

In a spreadsheet, the function used to count the number of cells containing numerical values in a range is called.....

• MAX( )

• SUM( )

• COUNT( )

• RANGE( )