Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write an IF statement in column H that says Yes if the number of calories is greater than 150 and No if the number of
Write an IF statement in column H that says "Yes" if the number of calories is greater than 150 and "No" if the number of calories is less than 150.
Type | Drink | Calories | Fat (g) | Carb. (g) | Fiber (g) | Protein (g) | Calories greater than 150? | ||
Brewed Coffee | Bold Pick of the Day | 5 | 0 | 0 | 0 | 1 | |||
Brewed Coffee | Clover Brewed Coffee | 5 | 0 | 0 | 0 | 1 | |||
Brewed Coffee | Decaf Pike Place Roast | 5 | 0 | 0 | 0 | 1 | |||
Brewed Coffee | Iced Coffee | 5 | 0 | 0 | 0 | 0 | |||
Brewed Coffee | Pike Place Roast | 5 | 0 | 0 | 0 | 1 | |||
Chocolate Beverages | Hot Chocolate | 290 | 9 | 47 | 2 | 14 | |||
Chocolate Beverages | Peppermint Hot Chocolate | 360 | 9 | 65 | 2 | 13 | |||
Chocolate Beverages | White Hot Chocolate | 410 | 12 | 61 | 0 | 15 | |||
Espresso Beverages | Caff Latte | 190 | 7 | 18 | 0 | 12 | |||
Espresso Beverages | Caff Mocha | 260 | 8 | 42 | 2 | 13 | |||
Espresso Beverages | Cappuccino | 120 | 4 | 12 | 0 | 8 | |||
Espresso Beverages | Caramel Flan Latte | 250 | 6 | 37 | 0 | 11 | |||
Espresso Beverages | Caramel Macchiato | 240 | 7 | 34 | 0 | 10 | |||
Espresso Beverages | Cinnamon Dolce Latte | 260 | 6 | 40 | 0 | 11 | |||
Espresso Beverages | Flavored Latte | 250 | 6 | 37 | 0 | 12 | |||
Espresso Beverages | Hazelnut Macchiato | 240 | 6 | 35 | 0 | 11 | |||
Espresso Beverages | Iced Caff Latte | 130 | 4.5 | 13 | 0 | 8 | |||
Espresso Beverages | Iced Caff Mocha | 200 | 6 | 36 | 2 | 9 | |||
Espresso Beverages | Iced Caramel Macchiato | 230 | 6 | 34 | 0 | 10 | |||
Espresso Beverages | Iced Cinnamon Dolce Latte | 200 | 4 | 34 | 0 | 7 | |||
Espresso Beverages | Iced Flavored Latte | 190 | 4 | 30 | 0 | 7 | |||
Espresso Beverages | Iced Hazelnut Macchiato | 230 | 5 | 34 | 0 | 10 | |||
Espresso Beverages | Iced Skinny Flavored Latte | 110 | 4 | 12 | 0 | 7 | |||
Espresso Beverages | Iced Vanilla Latte | 190 | 4 | 30 | 0 | 7 | |||
Espresso Beverages | Iced Vanilla Spice Latte | 190 | 4 | 31 | 0 | 7 | |||
Espresso Beverages | Iced White Chocolate Mocha | 340 | 9 | 55 | 0 | 11 | |||
Espresso Beverages | Pumpkin Spice Latte | 310 | 6 | 49 | 0 | 14 | |||
Espresso Beverages | Salted Caramel Mocha | 330 | 8 | 61 | 2 | 12 | |||
Espresso Beverages | Skinny Cinnamon Dolce Latte | 180 | 6 | 18 | 0 | 12 | |||
Espresso Beverages | Skinny Flavored Latte | 180 | 6 | 18 | 0 | 12 | |||
Espresso Beverages | Vanilla Latte | 250 | 6 | 37 | 0 | 12 | |||
Espresso Beverages | White Chocolate Mocha | 400 | 11 | 61 | 0 | 15 | |||
Frappuccino Blended Beverages | Cinnamon Dolce Frappuccino Blended Beverage | 350 | 4.5 | 64 | 0 | 15 | |||
Frappuccino Blended Beverages | Double Chocolaty Chip Frappuccino Blended Crme | 500 | 9 | 98 | 3 | 14 | |||
Kids Drinks & Others | Flavored Steamed Milk | 200 | 6 | 28 | 0 | 10 | |||
Kids Drinks & Others | Milk | 200 | 8 | 19 | 0 | 13 | |||
Smoothies | Chocolate Smoothie | 300 | 5 | 53 | 7 | 20 | |||
Smoothies | Orange Mango Smoothie | 270 | 1.5 | 53 | 6 | 16 | |||
Smoothies | Strawberry Smoothie | 300 | 2 | 60 | 7 | 16 | |||
Teas | Awake"! Brewed Tea | 0 | 0 | 0 | 0 | 0 | |||
Teas | Black Shaken Iced Tea | 0 | 0 | 0 | 0 | 0 | |||
Teas | Black Shaken Iced Tea Lemonade | 45 | 0 | 12 | 0 | 0 | |||
Teas | Calm"! Brewed Tea | 0 | 0 | 0 | 0 | 0 | |||
Teas | China Green Tips Brewed Tea | 0 | 0 | 0 | 0 | 0 | |||
Teas | Earl Grey Brewed Tea | 0 | 0 | 0 | 0 | 0 | |||
Teas | Passion"! Brewed Tea | 0 | 0 | 0 | 0 | 0 | |||
Teas | Refresh"! Brewed Tea | 0 | 0 | 0 | 0 | 0 | |||
Teas | Shaken Iced Green Tea | 0 | 0 | 0 | 0 | 0 | |||
Teas | Shaken Iced Green Tea Lemonade | 45 | 0 | 12 | 0 | 0 | |||
Teas | Shaken Iced Passion Tea | 0 | 0 | 0 | 0 | 0 | |||
Teas | Shaken Iced Passion Tea Lemonade | 45 | 0 | 12 | 0 | 0 | |||
Teas | Shaken Sweet Tea | 100 | 0 | 26 | 0 | 0 | |||
Teas | Shaken Sweet Tea Lemonade | 150 | 0 | 38 | 0 | 0 | |||
Teas | Zen"! Brewed Tea | 0 | 0 | 0 | 0 | 0 | |||
Teas | Full Leaf Chai Tea | 0 | 0 | 0 | 0 | 0 |
Step 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