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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!