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: 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: 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: 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? 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: 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? 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: 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: 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