LO5 - Spreadsheets (2)

What are the individual boxes on a spreadsheet called?

• Squares

• Cells

• Entry boxes

What can be used to uniquely identify each cell in a spreadsheet?

• Cell reference

• Column heading

• Row number

What are the separate pages of a spreadsheet called?

• Spreadsheets

• Pages

• Worksheets

What do you write to perform calculations in a spreadsheet?

• Computer programs

• Instructions

• Formulas/Functions

Which of the following is the correct formula to calculate 8 divided by 2?

• =8/2

• 8/2

• =8*2

In what format should a cell with a money value entered into be in?

• Currency

• Text

• Numbers

Which of the following is capable of producing a spreadsheet?

• Microsoft Word

• Microsoft Excel

• Microsoft PowerPoint

In a cell reference, for example A1, what does the letter refer to?

• The row the cell is in

• The column the cell is in

• The worksheet the cell is in

Formulas and functions must always start with which symbol?

• Brackets

• Add

• Equals

Which of the following tasks would a spreadsheet be best used for?

• Present information about a new television channel

• Manage the details of members at a gym

• Keep track of money raised at a charity event