Summative Assessment 116940

1. In a new worksheet, enter the information as found in image in course materials(10)
2. once you have entered the information, in A11, add a cell that reads: Average Expenses, then change the column width of this cell so that all the text shows in the cell. (1)

2. Change the formatting of cells B2:D5 and B8:D10 to number format (2)
3. Change the font type of cells B2:D2 to Book Antiqua 12 (1)
4. Change the horizontal alignment of cells B2:D2 centre aligned (1)
5. Change the format of cell A12 to Date and time and enter today’s date (2)
6. In cell A13, enter the current time (1)
7. Save your workbook named Income and Expenses followed by your name to the Desktop (3)
8. Open the Assessment Datafile(in course materials)   Copy rows A3:E11 to your Income and expenses workbook in a new sheet.  (2)
9. Rename the sheet to Debtors (1)
10. Keep both workbooks open (1)
11. In your Income and expenses workbook, add a button to your Quickstart toolbar. (3)
12. Adjust the column width of columns B,C and D to match that of column A. (3)
13. Change the view of the workbook to Page Break Preview (2)
14. Highlight column A and apply freeze panes (2)
15. Change the view of the Assessment Datafile workbook to 75%. (2)
16. In your Income and Expenses worksheet, insert three more worksheets to the workbook (3)
17. Delete the sheet named Debtors (3)
18. Open a new workbook
19. In cells C3 to C7, enter the following numbers and then convert to the accounting format, with two decimals: C3: 3130; C4: 4485; C5: 7250; C6:853; C7: 776. (1)
20. In row 1 type the following and then centre the text across cells columns A to H: Internal Sales, February 12. (1)
21. Go back to C5 and change the numbers to read 7350. (1)
22. In cell A3 type Exotic Nuts; cell A4: Caramel Nuts; cell A5 Flavoured peanuts; cell A6 Raw peanuts; cell A7 Dried Fruit and then centre the text in each cell. (7)
23. In cell B3, type Dept 1 B4 Dept2, B5 Dept3, B6 Dept4 B7 Dept5 and then use Autofill to drag down to B7, ending with Dept 5. (6)
24. Add the totals in column C, so that the answer shows in C8. (2)
25. In cell D3 enter 18, in cell D4 enter 353. Now multiply these two amounts, requesting the answer in cell D5 (2)
26. In cell D6 enter 3573 and in cell D7 enter 185. Now divide 185 into 3573, requesting the answer in cell D8. (2)
27. In column E enter the following amounts: E3: 373; E4: 568; E5: 676; E6 881. Add the column using the SUM function (2)
28. In column F enter the following amounts: F3: 17; F4: 45; F5: 235; F6: 485. Add the column using the AutoSum button on the ribbon. (2)
29. Go to sheet 2 of your workbook and in cell A2 enter Monday, then using Autofill drag down to cell A6, ending with Friday (2)
30. Enter the following amounts: C2: 5440; C3: 6330; C4 4845; C5: 4231; C6: 7835; C7: 8915. Now clear the contents of cell C7 and then add the column (3)
31. In cell B2 enter 4315; cell B3: 7433; cell B4: 6793, then add the column using any of the features that Excel provides. (2)
32. In cell D2 enter 33154,78 and in cell D3 enter 24938,95 and then subtract to ascertain the difference. (2)
33. Enter the following amounts: cell E2: 28394; cell E3: 7630; cell E4: 5321 and now centre the text across the cells. Add the column, using any feature of your choice. (2)
34. Save the worksheet in My Documents as your name Function Assignment. (1)
35. You want to buy a car for R80000 which has to be repaid over five years (60 months) at an interest rate of 12%. On sheet 2 calculate the interest payment for month 24 on this loan. Then calculate your monthly payments. (10)
36. Copy and paste your calculations to one of the worksheets in your Income and Expenses workbook (2)
37. Rename the worksheet Interest repayments (1)
38. Go to your Income and Expenses workbook and do the following calculations: In E3 calculate Average income for PC Sales (2)
39. In E4 calculate Maximum income for PC Repairs (2)
40. In E5 calculate Minimum income for PC Support (2)
41. In your Income and Expenses workbook, merge and centre row1 (1)
42. Change the font to Tahoma (1)
43. Put borders around cells A1 to D2 (2)
44. Select all the cells from B3: D5 and centre all the information in these cells. (2)
45. Select cells A2:A5 and A8: A10 and add light grey shading (fill) to them. (3)
46. Explain the purpose of using multiple worksheets (2)

Save the document and upload it here