Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can anyone help with these formulas? 7. Using an absolute cell reference where needed, create a formula in cell J5 to determine what percentage of
Can anyone help with these formulas?
7. Using an absolute cell reference where needed, create a formula in cell J5 to determine what percentage of total sales revenue is made up by sales revenue from the first item. 8. Copy the formula from J5 into all cells in the range J6:J18, without copying over the current formatting. 9. Format the % of Total column with Percent Style, no decimal places. Analyze the Data: You decide that any item with a sales revenue of $150 or less should receive a promotional discount. 10. In the Promotion column, create an IF() function that returns the word Discount for any item with a sales revenue less than or equal to $150, and the word None for all other items. A B C D E F G H I Motivacin Caf % of Total Promotion 3 Menu Item# 5 C8 6 C12 7 016 8 E8 9 A8 10 P8 11 LB 12 L12 13 L16 14 M8 15 M12 16 M16 17 T8 Revenue Item# AB P8 C12 C16 Price $ $ $ $ $ $ Description Coffee, Boz Coffee, 12oz Coffee, 16oz Espresso, Boz Americano, Boz Cappucino, Boz Latte, Boz Latte, 12oz Latte, 16oz Mocha, Boz Mocha, 12oz Mocha, 16oz Mocha. 16oz Tea, Boz 2.00 2.50 3.00 3.00 3.00 3.75 3.75 4.00 4.25 4.00 4.25 4.50 3.00 C8 EB L12 L16 L8 M12 Description Price Americano, Boz $ 3.00 Cappucino, Boz $ 3.75 Coffee, 12oz $ 2.50 Coffee, 16oz $ 3.00 Coffee, Boz $ 2.00 Espresso, Boz $ 3.00 Latte, 12oz $ 4.00 Latte, 16oz $ 4.25 Latte, Boz $ 3.75 Mocha, 12oz $ 4.25 Mocha, 16oz $ 4.50 Mocha, 8oz $ 4.00 Tea, Boz $ 3.00 Quantity Sales Revenue 90 $ 270.00 50 $ 187.50 80 $ 200.00 250 $ 750.00 120 $ 240.00 80 $ 240.00 30 $ 120.00 80 $ 340.00 40 $ 150.00 80 $ 340.00 90 $ 405.00 70 $ 280.00 25 $ 75.00 $ 3,597.50 $ $ $ M16 M8 TB Total 18 Quantity 90 80 250 120 19 Sales 20 Item# 21 AB 22 C12 23 C16 24 C8 25 E8 26 L12 27 L16 28 LB 29 M12 30 M16 31 MB 32 P8 33 T8 80 90Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started