Spreadsheets Year 7

What is a spreadsheet?

• A sheet of paper.

• A Computer Game.

• An electronic document where data is organized in rows and columns.

• A PowerPoint.

Which is the correct arithmetic operator for multiplication?

• +

• *

• /

• -

Which is the correct arithmetic operator for Division?

• -

• *

• +

• /

Which is the correct arithmetic operator for subtraction?

• +

• -

• *

• &

Which is the correct formula to work out a grand total?

• =sum(D3:D8)

• D3:D8

• =AverageD3:D8)

• total = add up

Which is the correct cell reference for the Ruler?

• A1

• A2

• A3

• A4

Which item would be selected if we used cell reference A3?

• Pen

• Ruler

• Items

• Pencil

Which symbol do we use to make an cell an absolute cell (Stays the same)?

• %

• £

• $

• !

SUM, AVERAGE, MAX and IF are examples of what?

• Functions

• Tools

• Options

• Statistical Tools

When you key a formula in a spreadsheet what do you key in first?

• +

• *

• =

• %