Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
F H A B D E G 1 Logic Functions 2 1. Create formulas to use TRUE or FALSE to indicate whether each item is
F H A B D E G 1 Logic Functions 2 1. Create formulas to use TRUE or FALSE to indicate whether each item is at low inventory level (below inventory threshold). 3 2. Create formulas to use TRUE or FALSE to indicate whether the "Unit Price" is between $5 and $10. 4 3. Use logic functions to finish Calculations in Cells D23 to D25. 5 6 Inventory Threshold 30 7 8 Item ID Item Category Unit Price Units in Stock Low Inventory Level Unit Price between $5 and $10 9 1001 CHOCOLATE $15.17 68 10 1002 CHOCOLATE $8.16 20 11 1003 JUICE $5.33 91 12 1004 CANDY $17.92 26 13 1005 CANDY $15.37 27 14 1006 JUICE $3.87 77 15 1007 JUICE $2.15 77 16 1008 JUICE $1.80 38 17 1009 CANDY $14.40 19 18 1010 CANDY $15.23 30 19 1011 CANDY $12.48 59 20 1012 CHOCOLATE $5.64 42 21 22 Item Category CANDY 23 # of items in category 24 Average unit price in category 25 Totol units in stock in category 26 27 28 29 Exercise 1 Exercise 2 Exercise 3
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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