Question: Can someone help me please thank you TASK ONE - INSTRUCTIONS Complete the following tasks on the March worksheet (remember that you must submit this
Can someone help me please thank you
TASK ONE - INSTRUCTIONS
Complete the following tasks on the "March" worksheet (remember that you must submit this spreadsheet for grading):
Action #1:
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".
Action #2:
In Cell F13, calculate the Monthly Budget (2000) spent. Display as a Percentage (%).In Cell F14, using the appropriate function, find the Greatest Expense in 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 Expense in 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 (%).
Action #3:
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 Colour of the text in these cells to Red.
Please be aware that this following Action must be submitted in PDF file format. If it is not, you will not be awarded any marks:
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 Assessment March."
| Bakery Expenses | |||||
| March | |||||
| Expense | Code | Amount ex GST | Discount | Total Discount | Total |
| Equipment Rental | ER757 | 500 | 10% | ||
| Electricity | EL444 | 380 | 0% | ||
| Raw Material | RP364 | 680 | 5% | ||
| Packaging | PP4785 | 220 | 5% | ||
| Marketing | 70 | 5% | |||
| Insurance | 75 | 10% | |||
| Total | |||||
| % of 2K Monthly Budget Spent | |||||
| Greatest Expenses | |||||
| Smallest Expenses | |||||
| Average Expenses | |||||
| Number of Expenses | |||||
| % of Budget used on Elec & Insurance |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
