Question: QUESTION 5 Use the data given below to answer the following question ( s ) . Below is a spreadsheet of purchase orders for a
QUESTION
Use the data given below to answer the following questions
Below is a spreadsheet of purchase orders for a computer hardware retailer.
tableABCDEFGHtablePurchaseOrdersSupplier,tableItemDescriptiontableItemCostQuantity,tableCostperOrdertableAP TermsMonthstableOrderNotableOrderSizetableRexTechnologiesGraphics Card,$$ALLargetableRexTechnologiesMonitor,$$ALSmalltableRexTechnologiesKeyboard,$$ALLargetableRexTechnologiesSpeakers,$$ALSmalltableMaxsWavetechHD Cables,$$KOSmalltableMaxsWavetechProcessor,$$KOLargetableMaxsWavetechHard disk,$$KOSmall
If purchase quantities of units or higher are found to be large orders, and orders less than are considered to be small, what IF function should be entered in to be copied to : to calculate each order's size?
Large
Large,SmallANDLarge,Small SmallLarge
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
