Answered step by step
Verified Expert Solution
Link Copied!

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

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

Principles Of Managerial Accounting

Authors: James M. Reeve

1st Edition

0324640625, 978-0324640625

More Books

Students also viewed these Accounting questions

Question

What is the difference between a class boundary and a class limit?

Answered: 1 week ago

Question

What is the principle of thermodynamics? Explain with examples

Answered: 1 week ago