Question: QUESTION 5 Use the data given below to answer the following question ( s ) . Below is a spreadsheet of purchase orders for a

QUESTION 5
Use the data given below to answer the following question(s).
Below is a spreadsheet of purchase orders for a computer hardware retailer.
\table[[,A,B,C,D,E,F,G,H],[1,\table[[Purchase],[Orders]],,,,,,,],[2,,,,,,,,],[3,Supplier,\table[[Item],[Description]],\table[[Item],[Cost]],Quantity,\table[[Cost],[per],[Order]],\table[[A/P Terms],[(Months)]],\table[[Order],[No.]],\table[[Order],[Size]]],[4,\table[[Rex],[Technologies]],Graphics Card,$89,35,$3115,20,AL123,Large],[5,\table[[Rex],[Technologies]],Monitor,$150,15,$2250,25,AL234,Small],[6,\table[[Rex],[Technologies]],Keyboard,$15,40,$600,15,AL345,Large],[7,\table[[Rex],[Technologies]],Speakers,$15,20,$300,25,AL456,Small],[8,\table[[Max's],[Wavetech]],HD Cables,$5,10,$50,25,KO876,Small],[9,\table[[Max's],[Wavetech]],Processor,$278,27,$6950,30,KO765,Large],[10,\table[[Max's],[Wavetech]],Hard disk,$120,18,$2160,20,KO654,Small],[11,,,,,,,,],[12,,,,,,,,]]
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?
)=(25, Large
)(25, Large,Small)=AND=OR=(25,Large,Small)>(25, Small)=(25,Large
 QUESTION 5 Use the data given below to answer the following

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!