Year5Unit 6

Here is part of a spreadsheet.

• Cell

• Column

• Row

• Sheet

What type of data can be found in cell B3?

• text

• number

• currency

• date

Explain what the formula in cell B7 does.

Which of the following statements about spreadsheets is true?

• rows are vertical, and columns are horizontal

• rows and columns are horizontal

• rows and columns can be either vertical or horizontal

• rows are horizontal , and columns are vertical

The position of text within a cell can be changed by which tool?

• borders

• alignment

• height

• sort

Which formula should be added to cell B6 to calculate the total?

• SUM(A2:A5)

• SUM(B2:B5)

• SUM(B6)

• SUM(B2:A6)

What is the group of cells that the formula operators in called?

• selection

• focus

• range

• reference

To create a chart, first select a range of cells and look on the toolbar for the button called

What do you call the groups of cells highlighted?

• table

• columns

• rows

• sheet

Which formula can you use to work out an average?

• SUM=Average

• =SUM(C2,D2,E2)

• =Average(C2+D2+E2)

• =Average(C2,D2,E2)