Question: Below is a spreadsheet of purchase orders for a computer hardware retailer. table [ [ , A , B , C , D ,

Below is a spreadsheet of purchase orders for a computer hardware retailer.
\table[[,A,B,C,D,E,F,G,H],[,\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]]],[,\table[[Rex],[Technologies]],\table[[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],[\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,,,,,,,,]]
To find the largest quantity of items ordered from Rex Technologies, what Excel formula should be used in A12?
?S=UM(D4:D7)
= COUNT(D4:D7)
=MAx(D4:D7)
= COUNTIF(D4:D10)
 Below is a spreadsheet of purchase orders for a computer hardware

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!