YEAR 5 BOOSTER QUESTIONS

Draw out the parts of Excel labeled in the picture below

A spreadsheet is a ………………………  made up of  ………………………… and ………………………….

• grid,rows and columns

• book,horizontals and lines

What cell is the word “Twix” in (use the cell reference)  …………………………………………….

• A4

• A3

• A5

• A6

What kind of data is in cell B3?   

• Letters

• Currency

• Boolean

• Text

What kind of data is in the Quantity column?

• Letters

• Currency

• Numbers

• Boolean

What has been used to calculate the cost of sweets?   

• Maths

• Formula

• Excel

• Data

Can you think of three advantages of using a spreadsheet versus using pen and paper? Write in full sentences.

Other than in school or class, can you think of where you might use a spreadsheet? Write any four.

All formulas begin with ……………………………………………

• +

• -

• =

• /

Correct this Excel formula

E2*b5=  

• e2*b5

• 5b*2e=

• =E2*B5

• E2*B5