Yr7 Spreadsheet REVISION

Select the software we use in school to produce a spreadsheet ....

• 
• 
• 
• 

What do formulas/functions always start with?

(a)  

Columns are ...

• The letters

• The numbers

If I want to multiply the two numbers, what operator (symbol) will I use?

• +
• -
• *
• /

What is the cell reference for the yellow cell?

(a)  

What formula would you use to add both of these numbers together? WRITE THE FORMULA.

(a)  

If you want to add borders to a range of cells, which icon would you choose?

• 
• 
• 
• 
• 

If you want to merge together a range of cells, which icon would you choose?

• 
• 
• 
• 
• 

Look at the spreadsheet shown. E7 has $ - what is this an example of?

• Absolute Cell Referencing
• Relative Cell Referencing

A group of highlighted cells e.g. A1:C8 is called...

• A Cell Reference
• A Cell Range
• A Formula
• A Function