Spreadsheets Test 1

Which piece of software do we use for spreadsheets?
1. Microsoft Excel
2. Microsoft Paint
3. Microsoft Access
4. Microsoft Spreadsheets
What is the correct way to refer to the cell in the top left corner of a spreadsheet?
1. A1
2. 1A
3. TL
4. HOME
In this spreadsheet, which cell holds the average lap time for Coulthard?
1. G6
2. G2
3. B6
4. 4:28
If we wanted to insert a new column called "Lap 4 time" between columns E and F, we should...
1. Right-Click on "F" at the top of column F, then select "Insert".
2. Right-Click on "E" at the top of column E, then select "Insert".
3. Click on "F" at the top of column F, then click "Insert".
4. Click on "E" at the top of column E, then click "Insert".
To completely remove all information about Brundle, leaving no gap in the table, we should...
1. Right-Click on the "4" at the start of Brundle's row, then select "Delete".
2. Hightlight row 4, then press "Del" on the keyboard.
3. Put the cursor in cell D4 and press "Delete".
4. Highlight row 4 then click "Data" then "Hide".
How would you enter "£1.55" into a cell?
1. Click on the cell, click on , then type "1.55".
2. Click on the cell, type "1.55", then click on .
3. Click on the cell, type "1.55", then click on .
4. Click on , then click on the cell and type "155".
How can you change the width of column C in a spreadsheet?
1. Put the mouse-pointer at the top of the column, between columns C and D. Click and drag to the desired width.
2. You can't. Column widths cannot be changed.
3. Highlight all of column C, and drag to the desired width.
4. Click on column C, then click on "Data" then "Resize Column".
In this spreadsheet something is wrong with cell D4. How can we correct it?
1. Right-Click on cell D4, then select "Format Cells". On the "Number" tab, click "Number".
2. Highlight column D, then click "Format" then "Column" then "Autofit Selection".
3. Highlight column D then click .
4. Click on cell D4, then click "Format" then "Auto Format". In the dialog box, choose "Simple".
In this spreadsheet, how would we work out the total cost of all items we are buying?
1. Click in cell E7, then click on
2. Click in cell E7, then click on
3. Highlight column E, then click "Data" then "AutoSum".
4. Click in column E, then click "Data" then "Subtotals".
Formulas have been used in column E of this spreadsheet to calculate the costs of buying a certain quantity of each item. If the quantity in cell C4 changes to 5, which cells in this spreadsheet will also change?
1. E4 only.
2. D4 and E4.
3. E3, E4, E5 and E6.
4. None of them.