Sec 4 CPA - Spreadsheet Revision

A spreadsheet is made up of

• titles

• table

• rows and columns

• templates

You always start a spreadsheet formula with?

• =

• +

• -

• *

The count formula counts

• the number of cells in the range as long as it contains text

• the number of cells in the range

• the number of cells outside the range

• the number of cells in the range as long as it contains numbers

what does the formula COUNTA do?

• Count the number of cells in a range that is empty

• Count the number of cells in a range that is not empty

• Count the number of cells in a range that contains numbers

• Count the number of cells in a range that contains alphabets

Which formula can help you find the largest value from a range of data?

• Average

• Highest

• Maximum

• Minimum

Which formula do you use to key in the date for today?

• =day()

• =time()

• =today

• =today()

#### is seen in spreadsheet sometimes because

• the formula is wrong

• the cell has an error

• the cell contains a longer message than the cell width

• the formula is ####

The function RANDBETWEEN has a range of

• 0 to 1

• 0 to 10

• 0 to 1000

• 0 to any number range