Question: F H A B D E G 1 Logic Functions 2 1 . Create formulas to use TRUE or FALSE to indicate whether each item

F H A B D E G 1 Logic Functions 21. Create formulas to use TRUE or FALSE to indicate whether each item is at low inventory level (below inventory threshold).32. Create formulas to use TRUE or FALSE to indicate whether the "Unit Price" is between $5 and $10.43. Use logic functions to finish Calculations in Cells D23 to D25.56 Inventory Threshold 3078 Item ID Item Category Unit Price Units in Stock Low Inventory Level Unit Price between $5 and $1091001 CHOCOLATE $15.1768101002 CHOCOLATE $8.1620111003 JUICE $5.3391121004 CANDY $17.9226131005 CANDY $15.3727141006 JUICE $3.8777151007 JUICE $2.1577161008 JUICE $1.8038171009 CANDY $14.4019181010 CANDY $15.2330191011 CANDY $12.4859201012 CHOCOLATE $5.64422122 Item Category CANDY 23 # of items in category 24 Average unit price in category 25 Totol units in stock in category 26272829

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!