Answered step by step
Verified Expert Solution
Link Copied!

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? image text in transcribed image text in transcribed

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 90

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Expert Systems Applications 19th International Conference Dexa 2008 Turin Italy September 2008 Proceedings Lncs 5181

Authors: Sourav S. Bhowmick ,Josef Kung ,Roland Wagner

2008th Edition

3540856536, 978-3540856535

More Books

Students also viewed these Databases questions