In this spreadsheet, what formula could be used to calculate the total race time for Brundle?

1.   ?    =C4+D4+E4
2.   ?    SUM(C4:E4)
3.   ?    =TOTAL(C4:D4:E4)
4.   ?    =C4:E4

Which icon can be used to change the background colour of cells in a spreadsheet?

1.   ?    
2.   ?    
3.   ?    
4.   ?    

In this spreadsheet, what formula is being used in cell E6?

1.   ?    =D6*C6
2.   ?    =C6+D6
3.   ?    =D6/C6
4.   ?    =C6-D6

Which symbol is used in spreadsheet formulas to mean "divide"?

1.   ?    /
2.   ?    +
3.   ?    %
4.   ?    #

How many cells in this spreadsheet use an italic font?

1.   ?    None of them.
2.   ?    4
3.   ?    16
4.   ?    20

Which of these icons would you click on to create a pie chart?

1.   ?    
2.   ?    
3.   ?    
4.   ?    

What does a spreadsheet formula ALWAYS start with?

1.   ?    An equals sign ( = )
2.   ?    The letter F.
3.   ?    The word "SUM".
4.   ?    A capital letter.

Which of the following is NOT a suitable formula to use in cell G3?

1.   ?    =C3+D3+E3/F3
2.   ?    =AVERAGE(C3:F3)
3.   ?    =(C3+D3+E3+F3)/4
4.   ?    =SUM(C3:F3)/4

Which one of the following statements is true?

1.   ?    Cell B4 is left-aligned.
2.   ?    Cell C4 is left-aligned.
3.   ?    Cell B5 is centred.
4.   ?    Cell C6 uses a bold font.

To put this information in order so that the fastest driver is first and the slowest last, we should...

1.   ?    Highlight all the information, click on "Data" then "Sort", and select "Sort by Total Time".
2.   ?    Highlight column F, click on "Data" then "Sort", and select "Sort by Total Time".
3.   ?    Highlight column F, click on "Data" then "Sort", and select "Sort Ascending"
4.   ?    Highlight column F, then click the " A --> Z " button.