Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The accompanying spreadsheet is a spreadsheet of purchase orders for a computer hardware retailer If purchase quantities of 25 units or higher are found to
The accompanying spreadsheet is a spreadsheet of purchase orders for a computer hardware retailer If purchase quantities of 25 units or higher are found to be large orders, and orders less than 25 are considered to be small, what IF function should be entered in H4 to be copied to H5 H10 to calculate each order's size? Click the icon to view the purchase orders spreadsheet OA IF(D4> 25,"Large", "Small")) B. =IF(D4 25,"Large") OR("Small") OC. D. IF(D4-25,"Small") AND(D4 25,"Large") IF(D4 AND OR 25, "Large", "Small") A B C Purchase 1 Orders 2 0. D E F G H Cost Item per A/P Terms Order Order 3 Supplier Item Description Cost Quantity Order (Months) No Size Rex 4 Technologies Graphics Card $89 35 $3115 20 AL123 Large Rex 5 Technologies Monitor $150 15 15 $2250 25 AL234 Small Rex 6 Technologies Keyboard $ 15 40 40 $600 15 15 AL345 Large Rex 7 Technologies Speakers $ 15 8 Max's Wavetech HD Cables $ 5 9 Max's Wavetech Processor $278 10 Max's Wavetech Hard disk $120 22200 $300 10 $50 25 27 $6950 30 18 $2160 20 2232 25 AL456 Small KO876 Small KO765 Large KO654 Small 11 12
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