Year 10 - Spreadsheets 2

What checks that data input to a cell is sensible ?

$B$2 is what type of cell referencing?

Double entry of input and then comparing is a form of what ?

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

Which is the correct function to total the prices in column E of all occurrences of "Aerobic" in cells A1 to A10?

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

What is the relative cell referencing for A3 ?

In a sample, if a large percentage of the total is used then what is the sample called ?

What is one advantage of using VLOOKUP ?

Which of the following is a correct VLOOKUP function ?

• =VLOOKUP(H2,$T$2:$U$3,2,FALSE)

• =VLOOKUP(H2,T2:U3,2)

• VLOOKUP(H2,$T$2:$U$3,1,VALIDATE)

• =VLOOKUP(H2,T2:U3,2,FALSE)