Question: Use the data given below to answer the following question(s). Below is a spreadsheet of purchase orders for a computer hardware retailer. To find the
Use the data given below to answer the following question(s). Below is a spreadsheet of purchase orders for a computer hardware retailer. To find the average of the total cost of orders from Rex Technologies, what Excel formula should be used in A12?
Question 1 options:
|
|
|
| 1) | =AVERAGE(C4:C10) |
|
|
|
| 2) | =AVERAGE(C4:C7) |
|
|
|
| 3) | =AVERAGE(E4:E7) |
|
|
|
| 4) | =AVERAGE(E4:E10) |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
