AutoSave Off Problem 2 Logical (Empty) Search (Alt+Q) File Home Insert Page Layout Formulas Data Review View Help fx Insert Function AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used TimeReference Tng Functions [@]]]] Manager Create from Selection cole smith Comments Share Define Name - Use in Formula By Trace Precedents Name Trace Dependents Remove Arrows Defined Names Show Formulas Error Checking Evaluate Formula Window Formula Auditing Calculate Now Watch Calculation Options Calculate Sheet Calculation Function Library D22 fx A C D E G H M N 1 2 Excel Logical Questions 3 4 5 Inventory Worksheet U Y 61) Fill in the "Profit" Column by subtracting the Cost from the Price. Then, fill in the" Total Revenue" column by multiplying the Price and Quantity. Finally, ensure that all the values in the "Cost", "Price", "Profit", and "Total Revenue" columns are set to Accou 72) You will need to reorder any product that has less than 150 units in inventory. Fill in Column K "Order Product?" with Yes/No to determine which products need to be reordered. 83) Best Sellers are defined by Quantity Sold greater than 300 and Profit greater than $10.00. Fill in the "Best Seller?" column with Yes/No to identify these items. 94) Stale items are defined by Quanity Sold as 65 or fewer items OR profit less than $2.00. Fill in the "Stale Item?" column with Yes/No to identify these items. 105) You'd like to fill in the "Full Price?" column by identifying if the Promotion column is blank or not. Use the IsBlank function to check the value in the Promotion column; if it is blank, fill with the value "Full Price" and fill with the value "On Sale" if not 11 6) What is the average total revenue received for the products provided in the table? 12 7) What was the highest revenue of any product provided in the table? 13 8) How many products are provided in the given table? 149) A customer wants to buy 1 of item 1234 #RT in row 2 and 1 of item 1235#RT in row 3. They have a coupon for $10 off item 1234#RT, and the entire store is having a sale so that the entire purchase is 25% off. Using parentheses appropriately, deten 15 10) You'd like to see what your average revenue would be if you increased average prices by 10%. You forecast that your average Quantity Sold would decrease by 10% as a result of the price increase. What would be the new forecasted average revenue pe 16 11) Filter the table so that the only data showing is where Order Product is "Yes" and Best Seller is "No" 17 18 19 20 21 22 23 24 Questions Inventory | (+) Select destination and press ENTER or choose Paste Search 90% EPIC 11:40 PM 80F 99+ 9/26/2022 22