Question: 2 3 On the SalesData worksheet, in cell F4, create a formula that will perform a calculation that multiplies the Unit Price by the

2 3 On the SalesData worksheet, in cell F4, create a formula

that will perform a calculation that multiplies the Unit Price by the 

2 3 On the SalesData worksheet, in cell F4, create a formula that will perform a calculation that multiplies the Unit Price by the sum of products sold for January, February, and March. If a product has not sold any units over the past three months, display Discontinue. If the project has sold units, display the results of the Unit Price multiplied by the sum of the products sold for January, February, and March. Copy the formula and then paste it in cells F5, F7:F9, F11:F12, F14:F15, and F17:F18. Resize the column as needed. In cells C6:E6, C10:E10, C13:E13, C16:E16, and C19:E19, use a function to total the product sales for January through March. 8

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 Business Communication Questions!