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

2 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. 3 Product 4 64GB Hard Drive 5 128 GB Hard Drive 6 7 2GB Flash Drive 8 4GB Flash Drive 9 8GB Flash Drive 10 11 15" Monitor 12 18" Monitor 13 14 Keyboard 15 Ergo Keyboard 16 17 8GB RAM 18 16GB RAM 19 20 21 22 23 24 Totals by Item 25 Hard Drives 26 Flash Drives 27 Monitors 28 Keyboard 29 RAM 20 Unit Price $ 150.00 $ 249.00 B 8.00 $ $ 10.00 $ 15.00 $ 75.00 $ 100.00 is s $ 20.00 35.00 $ $ 150.00 $ 200.00 Monthly Snapshot Goal January 50 75 52 55 12 Actual Monthly Sales 12 7 20 18 5 2 13 D 3 2 February March 11 6 12 20 4 6 11 5 3 E Outcome 12 8 13 19 5 5 12 4 5 F Total H Product of the Month 75 Goal Product

Step by Step Solution

★★★★★

3.49 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Answer FORMULA IFSUMC4D4E4B40SUMC4D4E4B4Discontinue IFc... View full answer

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 Electrical Engineering Questions!

20 21 22 23 24 11 14 15 7 8 9 10 13 4 6 2 3 5 ABC Co. manufactures widgets and has the following operating information for the past year: A A 12 B B Product Line Product Line Budgeted Unit Sales...

Flash Manufacturing manufactures 16 GB flash drives (jump drives). Price and cost data for a relevant range extending to 200,000 units per month are as follows: Sales price Per-unit (current monthly...

Write a formula that will convert the volume given in 1,000s into a volume given in 100s. Use the left side of the equation to indicate in which cell to store the formula. a. Intel Corp b. Yahoo! Inc...

Pressing Ctrl+A selects all cells in the current worksheet. Given this fact, create a macro that will ensure that each cell in a worksheet is formatted in boldfaced italics.

PROJECT STEPS 1. Lizzy is the manager of Cozy Movies, a small local movie theater that has been in business for a very long time. She would like to keep track of the theater's sales and expenses from...

Avery Company acquires the net assets of Iowa Company on July 1, 2011. The net assets acquired include plant assets that are provisionally estimated to have a fair value of $600,000 with a 10-year...

A plane figure S is to be translated by And then the resulting figure translated by (a) Determine the 3 x 3 matrix M in homogeneous form that will perform this composition of translations, (b) Can...

> Assignments > Test #2 Chapter 3 Test #2 Chapter 3 Due Sunday by 11:59pm Points 24 Submitting an external tool Available after Oct 31 at 12am its Test #2 Chapter 3 1hr32mi Score: 0/24 0/24 answered...

marks Profiles Tab Window Help 71% Mon 6:51 PM Hannah X A Week 4 MindTar X MindTap - Ceng X M 2 more weeks o x Course Hero X 3 docx (10).pd...

1. Stella Scott has a work-study position at the fitness center on campus. Her manager has asked her to create a worksheet to keep track of attendance and revenue for the fitness center's classes....

Timothy was always an active little boy, and was a great player for his Little League team at the age of 12. For the first year or so, Tim had no trouble catching balls and running bases. He was...

Given a wave with E = xE0cos (wt kz) Calculate: (a) The time-average electric energy density (b) The time-average magnetic energy density (wm)av = 1/T f wm dt = 1/2T f μH2 dt, and (c) Show that...

What is the applicable age for required minimum distributions from a traditional IRA for 2 0 2 5 under the Secure 2 . 0 Act?

An air conditioner cools 226m3/min of humid air at 36C and 98% relative humidity to 10C. (a) Do a degree-of-freedom analysis to prove that enough information is available to determine the required...

Derek Lee just received a signing bonus of $1,000,000. His plan is to invest this payment in a fund that will earn 6%, compounded annually. Instructions (a) If Lee plans to establish the DL...

A beam of mass M and length L is supported horizontally at its ends by two cables making angles θ and Φ with the horizontal ceiling (Fig. 11.41). (a) Show that if the beam is uniform. These...

Hoechst Celanese, a pharmaceutical manufacturer, has used a profit-sharing plan, the Hoechst Celanese Performance Sharing Plan, to motivate employees. To operationalize the plan, the Hoechst Celanese...

The financial statements of Eagle Sport Supply are shown in Table 29.15. For simplicity, ?Costs? include interest. Assume that Eagle?s assets are proportional to its sales. a. Find Eagle?s required...

mg The serum cholesterol levels (in di ) of 17 individuals are 211, 244, 252, 186, 206, 203, 232, 218, 213, 196, 257, 420, 215, 237, 259, 191, 242 Send data to calculator Find 40th and 75 th...

2 On the SalesData worksheet, in cell F4, create a formula that will perform a calculation that 8 multiplies the Unit Price by the sum of products sold for January, February, and March. If a product...

2 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...

all information is present, business analytics, all one question Total Unit Price $ 150.00 $ 249.00 Monthly Sales January February 12 11 7 6 March 12 Product of the Month Goal 75 Product 8 $ $ $ 8.00...

A table has been set up with inventory information, but new functions need to be developed to create a monthly snapshot table. First, the table must be cleaned up and some cells recalculated to check...

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...

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...