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 the accuracy of the formulas used. 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.

e03_grader a2 4KellyCo AutoSave Off File Help OSea Formulas Review View Home Insert Page Layout Data X ab Wrap Text A A Accounting Calibri 11 Paste I U - Merge & Center 6%$ Clipboard Font Alignment Number -B4*SUM(C4+D4+E4) F4. C D E F G H J K 1 Monthly Sales 2 Product Unit Price January February March Total Product of the Month 3 $150.00 12 $5,250.00 64GB Hard Drive 12 11 Goal 75 4 Product Drive 249.00 7 5 6 2GB Flash Drive 8.00 4GB Flash Drive 10.00 20 12 13 8GB Flash Drive 15.00 18 20 19 10 15 Monitor 75.00 4 5 11 18 Monitor 100.00 12 13 14 Keyboard Ergo Keyboard 20.00 2 5 35.00 13 11 12 15 16 8GB RAM 16GB RAM 150.00 3 4 17 200.00 18 19 20 21 22 Monthly Snapshot 23 Actual Outcome Totals by Item Goal 24 25 Hard Drives 50 75 26 Flash Drives Monitors 52 27 28 Keyboard 55 12 29 RAM 30 31 32 33