The accompanying spreadsheet is a spreadsheet of purchase orders for a computer hardware retailer. Which of the following Database functions calculates the average item cost ordered by Rex Technologies? Click the icon to view the purchase orders spreadsheet. Purchase Orders K
OA.=DAVERAGE(A3:H10,C3,A12:B13) OB.=DAVERAGE(A3:H10,C3,A12:A13) OC.=DSUM(A3:H10,C3,A12:A13/COUNTA(A4:A10) OD.=DAVERAGE(A3:H10,'Item Cost',A12:A14)
A Purchase 1 Orders 2
B
C
D
E
F
G
H
Cost per A/P Order Order Order Terms (Months) No. Size
Item Item Description Cost
3
Supplier Quantity Rex Technologies Graphics Card $89 35 Rex Technologies Monitor $150 15 Rex Technologies Keyboard $15 40 Rex Technologies Speakers $15 20 8 Max's Wavetech HD Cables $5 10 Max's Wavetech Processor $278 27 10 Max's Wavetech Hard disk $120 18 11 12 Supplier Order Size ==Rex 13 Technologies ==Large
$3115 20
AL123 Large
$2250 25
AL234 Small
$600
15
AL345 Large
$300 25 $50 25 $6950 30 $2160 20
AL456 Small KO876 Small KO765 Large KO654 Small
Print
Done