Below is a spreadsheet of purchase orders for a computer hardware retailer. Orders 3Supplier Cent Qutity...

Transcribed Image Text:

Below is a spreadsheet of purchase orders for a computer hardware retailer. Orders 3Supplier Cent Qutity Order Menths) Cast per AP Terms Order Oriler Ste Rex Technolo Rex Technolo Rex TechnologiesKeyboard S15 Rex TechnologieSpeakersS15 Max's Wavetech HD Cle 35 D Max's Wavetech Processor S89 35 3150 1S 40 20 53115 20 ALI23 Large AL234 Small AL345 Large AL456 Small KOS76 Sanll KO765 Noer $2250 25 5600 LS 5300 550 25 6. 10 Max's Wvetech Hard disk 11 S273 27 S120 18 56950 30 $2160 Large Sasall KO654 12 Supplier 13 Rex Technoliogies Large 14 Max's Wavctech Ihem Order Size Cant P15 Which of the following Database functions calculates the total quantity ordered i large size? O 1) =DSUM(A3:H10 Quantity"B12:B13) O 2) =DSUM(A3:H10,D3.B12:B13) O3) =DSUMIA3:H10.D3.A12:B13) 4=DSUM(A4:H10.D3.B12:B13) Below is a spreadsheet of purchase orders for a computer hardware retailer. Orders 3Supplier Cent Qutity Order Menths) Cast per AP Terms Order Oriler Ste Rex Technolo Rex Technolo Rex TechnologiesKeyboard S15 Rex TechnologieSpeakersS15 Max's Wavetech HD Cle 35 D Max's Wavetech Processor S89 35 3150 1S 40 20 53115 20 ALI23 Large AL234 Small AL345 Large AL456 Small KOS76 Sanll KO765 Noer $2250 25 5600 LS 5300 550 25 6. 10 Max's Wvetech Hard disk 11 S273 27 S120 18 56950 30 $2160 Large Sasall KO654 12 Supplier 13 Rex Technoliogies Large 14 Max's Wavctech Ihem Order Size Cant P15 Which of the following Database functions calculates the total quantity ordered i large size? O 1) =DSUM(A3:H10 Quantity"B12:B13) O 2) =DSUM(A3:H10,D3.B12:B13) O3) =DSUMIA3:H10.D3.A12:B13) 4=DSUM(A4:H10.D3.B12:B13)

Answer rating: 100% (QA)

The DSUM function has the following arguments DSUM database ... View the full answer