Open the Excel template file provided for this assessment and then in the March worksheet complete the following actions:

Action #1	Completed
In cell E4, calculate the Total discount in March using a formula. Copy this formula into cells E5 to E9 (Total discount = Amount ex GST multiplied by the discount percentage).
In cell F4, calculate the Total in March using a formula. Copy this formula into cells F5-F9 (Amount ex GST less Total Discount = Total).
Using the AutoSum function, complete Row 11(C11, E11 and F11) using the data from columns C, E and F
Format all of the data in columns C, E and F as "Currency".
Save your workbook.

Action #2	Completed
In Cell F13, calculate the Monthly Budget(2000) spent. Display as a Percentage (%).
In Cell F14, using the appropriate function, find the Greatest Expensein the Total column (F4-F9).
In Cell F15, using the appropriate function, find the Smallest Expense in the Total column (F4-F9).
In Cell F16, using the appropriate function, find the Average Expensein the Total column (F4-F9).
In cell F17, using the appropriate function, find the Number ofExpensespresent in the data in the Total column (F4-F9).
In Cell F18, using brackets in your formula, calculate the percentage of the Monthly Budget (2000) used on Electricity and Insurance. Display as a Percentage (%).
Save your workbook.

Action #3	Completed
A3 - F3 Centre the headings.
A1 - Change the Cell Style colour to Accent 6,Change Font size to 16, Make Bold, and alter the size of the cell so that the text is visible.
A2 - Change the Cell Style colour to Accent 6, Change Font size to 14, Make Bold.
A3 - F11 Add Borders to all cells within this cell range.
A3 - F3 Change the Cell Style colour of the headings to 40% - Accent 6.
C13-E18 Change the Cell Style colour of these cells to 40% - Accent 6.
F13-F18 Change the Font Colourof the text in these cells to Red.
Save your workbook.