Spreadsheets

What are the small rectangles in a spreadsheet called?

• cells

• fields

• boxes

• rows

What is the reference of the cell with a blue outline?

• 5C

• A7

• C5

• D10

What will the formula in cell D2 do?

• multiply the numbers in cells a2, b2 and c2

• subtract the numbers in cells a2, b2 and c2

• divide the numbers in cells a2, b2 and c2

• add the numbers in cells a2, b2 and c2

What would happen if you typed cat in cell A7?

• it would display correct in cell A8

• It would display incorrect in cell A8

• It wouldn't do anything

• It would display correct in cell A7

What skill would you use to set the colour of A8 to red if the answer is incorrect?

• colour fill

• conditional formatting

• data validation

• create a chart

How do you create a drop down menu of possible answers

• conditional formatting

• formula

• data validation

• pivot table

cells that run horizontally on a spreadsheet

• row

• column

• range

• workbook

rows that run vertically on a spreadsheet

• rows

• columns

• range

• workbook

all formula's begin with which symbol

• =

• -

• #

• @

Format cells as __________ when working with money

• percent

• number

• scientific

• currency