Key Skills ICT Level 2 - Spreadsheets Mini Test Two

The questions are about the spreadsheet illustrated. For each question below, click on the circle next to the correct answer.

When you have finished the test, Click the 'Score my test' button at the bottom of the page and follow the instructions on the Results page. Good luck!

 
Question number 1
The User has positioned the text in row 12 by:
Spreadsheets Mini Test Two

A. merging cell range A12:G12
B. merging cell range A12:F12
C. inserting column G
D. splitting cell A12

 
Question number 2
Profit is Selling Price less Cost, with the result being multiplied by the total of October and November Sales. The formula in cell G3 is therefore:
Spreadsheets Mini Test Two

A. =D3-C3*E3+F3
B. =C3-D3*E3+F3
C. =(D3-C3)*(E3+F3)
D. =(C3-D3)*(E3+F3)

 
Question number 3
Average Profit per Bike Sold is Total Profit divided by Total Sales for October and November. The formula in cell G12 is therefore:
Spreadsheets Mini Test Two

A. =G11/E11+F11
B. =E11+F11/G11
C. =(E11+F11)/G11
D. =G11/(E11+F11)

 
Question number 4
How are the column headings (Bike Type, Model etc.) horizontally aligned?
Spreadsheets Mini Test Two

A. top
B. right
C. centre
D. bottom

 
Question number 5
The formula in cell E11 is =SUM(E3:E10). This has been replicated to cell F11. This means the formula in cell F11 is therefore:
Spreadsheets Mini Test Two

A. =SUM (E3:E10)
B. =SUM (E3:F10)
C. =SUM(F3:F10)
D. incorrect

 
Question number 6
If the value in cell C5 is changed, the other values on the spreadsheet that will change automatically are in which cells?
Spreadsheets Mini Test Two

A. E11, F11 and G11
B. E5, G11 and G12
C. G5, G11 and G12
D. G5, E5, F5 and G12

 
Question number 7
To enter the details of another bike, the User should insert a new:

A. cell
B. row
C. field
D. column

 

Question number 8
To check that all information has been entered correctly, the user should:

A. use a spell checker
B. enter the data slowly
C. proof-read the entries
D. check the formulas are correct

 
Question number 9
To produce a bar chart that compares the sales figures for each Model for the two months, the cell ranges to select are:
Spreadsheets Mini Test Two

A. A3:A10 and E3:F10
B. A3:A10 and C3:C10
C. B3:B10 and E3:F10
D. B3:B10 and E11:F11

 
Question number 10
The presentation of the spreadsheet could be improved by:
Spreadsheets Mini Test Two

A. decreasing the height of row 2
B. making all the columns equal in width
C. decreasing the width of column A
D. making rows 3 to 10 equal in height