Summative Assessment 116937

Click

To

Ignore Once

Ignore All

Change

Change All

Add to Dictionary

AutoCorrect

Undo Last

1.        Highlight from Cell A1:G5  (2)

2.        Open an Excel workbook  (2)

3.        From A1 to D1, enter the following information:  A1: Car; B1: House; C1: School; D1: Groceries.  Once you have completed this task, enter an amount (only an estimate) from A2 to D2 for each of the payments that need to be made in an average budget each month.  (8)

4.        Once the above tasks have been completed, use Save As to save your spreadsheet to My Documents with the name, Budget July, followed by your name and close Excel  (3)

5.        Open Excel and use the Help feature to look up AutoSum.  Once you have the required results from Help, copy the result and paste it in a Word document.  Save the Word document in My Documents as Help feature followed by your name. (Help feature Raymond) (3)

6.        Open a new spreadsheet and complete the following instructions:  enter the following amounts in cells C1 to C5: C1: 28443; C2: 31296; C3: 8543; C4: 12; C5: 96. Set the number of decimal places to zero and the currency to R English.  (3)

7.        Type the following names in cells A1:A5:  Thabo, Lebohang, Jack, Raymond and Sally.  Select all the names and change the font to Bookman Old Style and the font size to 12.  Once you have completed these steps, select cell A2 (Lebohang) and use the Shrink to Fit feature to fit the name into the cell.  (5)

8.        In cells D1:D5 enter the following values:  150; 286; 94; 1268; 732.  Use the AutoSum function to add these values so that the answer displays in D6. Save the workbook in an HTML format with the name Outcome 3 116937 followed by your name and close it.  (2)

9.        Open the Motor Sales workbook.  Using the Except labels in formulas function, add D2:D7.  Save the workbook in My Documents as Motor Sales followed by your name and close the workbook.  (5) 

10.     Open the Sales Profit Workbook.  Repeat Jan-Mar in cells G2:I2 by using the AutoFill function.  Once you have completed this, select cells A1:E7.  Cut them and Paste them in cells A3:E9.  Once you have completed the instructions, save the workbook in My Documents as Sales Profit, followed by your name.  (5)

11.     Open the Commission Report workbook and use the find and replace function to find QUICK-Stop and replace it with FAST-stop.  (2)

12.     Open the workbook PRODUCT DATALIST and run a spell check and correct all the spelling mistakes. (3)

13.     Open the Car Sales Chart and set it up so that the headings of A1:F1 are repeated at the top of each page. Save the workbook in My Documents as Car Sales Chart, followed by your name.  (5)