Spreadsheets 1

What is a vertical section of a spreadsheet called?

• row

• cell

• rank

• column

What is a horizontal section of a spreadsheet called?

(a)  

What is an individual box where a row and column meet within a spreadsheet called?

• square

• range

• reference

• cell

• rectangle

Which of the following is the correct way to type the location of a cell?

• 8B

• B8

• 8-B

• BB-8

The location of a cell on a spreadsheet is a column letter followed by a row number. What is this called?

• Cell Range

• Active Cell

• Cell Reference

• Row

What is the cell range in this diagram?

• A1:F1

• A1:A8

• A1:F8

• A1:1A

Which of the following is an absolute cell reference?

• A2

• $A$2

• #A#2

• A:2

What will clicking on the icon in the image do?

• Make the text size bigger

• Make the text colour red

• Make the cell background colour red

• Underline the text

Which format is best suited to display a whole number including the thousands (comma) separator?

• Percentage

• Number

• General

• Currency

All formulas in spreadsheets begin with which of the following symbol?

• +

• -

• =

• %

• !