Using Microsoft Excel In this Practice Exercise, you need to complete two tasks. The first task requires formulas, format a worksheet, calculate percentages, select a print area and prin The second task instructions require you to calculate values, and use the sort an
Required Read through the instructions provided for each task and then complete the Prac Please ensure that you complete every required task and when you have finishe work.
The instructions for each task are presented below:
Task One-Instructions Open the March worksheet and complete the following tasks:
Action #1
In cell E4, calculate the Total discount in March using a formula. Copy this fo = Amount ex GST multiplied by the discount percentage). In cell F4, calculate the Total in March using a formula. Copy this formula into Discount = Total). Using the AutoSum function, complete Row 11 (C11, E11 and F11) using the d *Format all of the data in columns C, E and F as “Currency”. Action #2:
In Cell F13, calculate the Monthly Budget (2000) spent. Display as a Percen -In Cell F1 4, using the appropriate function, find the Greatest Expense in the *In Cell F1 5, using the appropriate function, find the Smallest Expense in the To -In Cell F1 6, using the appropriate function, find the Average Expense in the T *In cell F1 7, using the appropriate function, find the Number of Expenses pre F9). In Cell F1 8, using brackets in your formula, calculate the percentage of the Mo and Insurance. Display as a Percentage (%). Action #3:
A3-F3 Centre the headings. A1 – Change the Cell Style colour to Accent 6, Change Font size to 16, Make that the text is visible. AZ – Change the Cell Style colour to Accent 6, Change Font size to 14, Make *A3-F11Add Borders to all cells within this cell range. A3-F3 Change the Cell Style colour of the headings to 40% – Accent 6. *C13-E1 8 Change the Cell Style colour of these cells to 40% – Accent 6. *F13-F18 Change the Font Colour of the text in these cells to Red. Action # 4:
Select the table and calculation area (cells A1-F18) as the print area. *Set to print in landscape. Centre the table and calculation area in the middle of the page. Print to PDF, save and name the file as “Excel Practice Exercise March.” Task Two – Instructions Open the “Sales” worksheet and complete the following tasks:
Action # 5:
Calculate the Total Expenses (B1 5-M1 5) for each month using the SUM funct Calculate the Totals(N6-N1 4) for each expense using the SUM function. Calculate the Average Expenses (O6-O1 4) using the AVERAGE function. Sort your budget so that the expenses are listed alphabetically (A-Z). Apply a filter to Row 5 of the budget and filter the data so that only the Rent, Food expensesare visible.