Question: ( 5 points ) Set the Author property to your first and last name. ( 7 points ) Go to the Budget Summary worksheet. Cut

(5 points) Set the Author property to your first and last name.
(7 points) Go to the Budget Summary worksheet. Cut the worksheet title from cell II and paste it in cell A1 to display the title in its expected location.
(8 points) In cell E2, add the text Number of so that the complete text appears as "Number of salespeople:" and more clearly identifies the value in cell G2.
(8 points) Enter Quarter 2 in cell C4 and Quarter 3 in cell D4.
(8 points) In cell G5, enter a formula without alfunction that subtracts the target revenue (cell F5) from the year to date revenue (cell E5) to determine how much revenue the field office needs to earn in Quarter 4 to reach its target for the year.
(8 points) Calculate the gross margin for Quarters 1-3 and the year to date as follows:
a. In cell B7, enter a formula without a function that divides the gross profit for Quarter 1(cell B6) by the revenue in Quarter 1(cell B5).
 (5 points) Set the Author property to your first and last

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 Databases Questions!