7.5 Spreadsheets End of Unit

What is a spreadsheet?

• An application used to store, organise and analyse data

• An application used to create presentations

• An application used to write text documents

• An application used to create computer games

  

What is the cell reference for this cell?

• A4

• 4B

• B2

• B4

What is the cell reference for this cell?

• B5

• A5

• A1:A5

• 5A

What is the cell reference for this cell?

• 2C

• D2

• C2

• B2

What is the cell reference for these cells?

• 3A:3D

• A3+B3+C3+D3

• A3

• A3:D3

What will you find in cell C6?

• 17

• 37

• 46

• 38

What will you find in cell A4?

• China

• Great Britain

• Russia

• 26

What cell reference has the number of gold medals that Great Britain won?

• B3

• A3

• C3

• D4

Pick 3 options for formatting a spreadsheet:

• Cell colour

• Borders

• Cell size

• Formulas and Functions

Which is the correct formula to add these 2 cells together?

• =B2+C2

• 58

• =25+33

• B2+C2