UNIT 8 SPREADSHEET REVISION ALEVEL IT

What is the cost per litre for the car with the registration 'BX59MVN'?

• £1.25

• £5

• £5.69

• £3.87

Which of the following cars uses LPG?

• BX59WMV

• BX59MVN

• BX59WMO

• BX59KMW

How many Saab cars are listed in the spreadsheet?

• 1

• 2

• 3

• None

What is the cost per gallon for Diesel fuel?

• £5.69

• £5.32

• £1.25

• £3.87

Which formula could be used to calculate the cost per gallon if there are 4.55 litres in a gallon?

• Cost per litre 4.55

• Cost per litre / 4.55

• Gallon / Cost per litre

• Cost per gallon / 4.55

Which of the following is not a type of fuel listed in the spreadsheet?

• Petrol

• Diesel

• LPG

• Electric

What type of fuel does the car with the registration 'BX59MVS' use?

• Petrol

• Diesel

• LPG

• It is not listed

Which car model is associated with the registration 'BX59MVW'?

• Saab 9-3

• Ford Mondeo

• Discovery

• Smart Car

What is the cost per litre for Petrol, according to the spreadsheet?

• £1.25

• £5

• £5.69

• 5.32

If the spreadsheet is using relative cell referencing, what would be the formula in cell F3 if it is similar to that in F2?

• =E24.55

• =E34.55

• =D24.55

• =D34.55