SECTION B: MS EXCEL Personal Budget Using Microsoft Excel, create a six-month personal budget with a minimum of six categories per month to reflect how you spent your monthly income. Your monthly income shall be Kes. 50,000 One of your categories must be Savings. Instructions 1. Open Microsoft Excel, from sheet tab in Page Setup, turn on Gridlines 2. In cell Al, type the title: Your Name Monthly Budget 3. Select cells Al H1 and click the Merge & Centre icon, make your title to be font 16. 4. In cells A3 A8, list your six expense categories starting with Savings. 5. In cells B2 G2, list the current month and the five months following. 6. Click on the A column header and make the selected text bold. 7. Click on the row 2 header and make the selected text bold. 8. In cells H2 and A9, type: Total: 9. Create formulas to total the rows and columns. 10. Click on cell H3 and use the Sum formula to total the row. 11. Click on cell B9 and use the Sum formula to total the column. 12. Now fill in the middle cells representing your expense in each category for each month. Make sure that your total monthly expenditure and Income equal exactly to Kes. 50,000 13. Use text and cell formatting options to make your Monthly budget look presentable. 14. Use the above information to come up with a chart of your own choice, take Categories against Total of categories. 15. In your chart show the percentage for each budget item. 16. Use your space creatively and present all your display in a single worksheet (page).