Use the data given below to answer the following questions) .
Below 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?
A) =DAVERAGEA3:H10,C3,A12:A13)
B) =DAVERAGEA3:H10,C3,A12:B13)
C) =DAVERAGEA3:H10,"Item Cost",A12:A14)
D) =DSUMA3:H10,C3,A12:A13) /COUNTAA4:A10)
Correct Answer:
Verified
Q14: In a database, information is stored and
Q15: Use the data given below to
Q16: Use the data given below to
Q17: Use the data given below to
Q18: Use the data given below to
Q20: Which of the following functions is a
Q21: Using the spreadsheet below, provide the
Q22: Which of the following Lookup functions returns
Q23: ANDcondition 1, condition 2…) is a logical
Q24: Explain the different Lookup functions in Excel.
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents