Y7 Spreadsheets (Baseline Test)

What are spreadsheets used for?

• To store, search and sort information.

• To calculate data and create charts

Which is the correct formula to multiply?

• =B6*C6

• B6*C6

• B6C6*

• *B6C6

Which is the correct formula to divide?

• B6/C6

• =B6/C6

• /B6C6

• B6C6/

What can you NOT do with spreadsheets?

• Increase the column width

• Increase the row height

• Make text within a cell bold, underlined or Italic

• Animate text within a cell

What function do you use to add cells together?

• SUM

• MIN

• MAX

• AVERAGE

What function do you use to find the lowest number?

• SUM

• MAX

• MIN

• AVERAGE

Name this

• Cell

• Row

• Column

What formula is used in cell D8?

• =D3*D4*D5*D6
• SUM(D3:D6)
• =69.10
• =SUM(D3:D6)

What is displayed in cell A6?

• Monday
• Tuesday
• Wednesday
• Thursday

What is displayed in cell B1?

• 100
• Tickets Sold
• Day
• B1