Year 10 - Spreadsheets 1

Each cell has a unique cell ......... ?

Which of the following is the relative cell reference for A3 ?

• £A£3

• A3

• $A$3

• !A!3

$B$2 is what type of cell referencing ?

What do you apply to cells to ensure the input to them is sensible or reasonable ?

What is it called when a cell changes format based on it's value ?

Which is the correct function to count all occurrences of 5 in cells A1 to A10 ?

What graph is best for showing the proportion of the total for all categories ?

What is a visual representation of data on a spreadsheet called ?

What is the absolute cell reference for cell A3 ?

Which is the correct function to lookup and display the price based on the item selected ?

• VALIDATION

• COUNTIF

• SUMIF

• VLOOKUP

• RANK