Use the data given below to answer the following question.

Below is a spreadsheet of purchase orders for a computer hardware retailer.

A B C D E F G H

$1$ Purchase Orders

$2$

$3$ Supplier Item Description Item Cost Quantity Cost per Order A$/$P Terms $($Months$)$ Order No$.$ Order Size

$4$ Rex Technologies Graphics Card $$8935$ $$311520$ AL$123$ Large

$5$ Rex Technologies Monitor $$15015$ $$225025$ AL$234$ Small

$6$ Rex Technologies Keyboard $$1540$ $$60015$ AL$345$ Large

$7$ Rex Technologies Speakers $$1520$ $$30025$ AL$456$ Small

$8$ Max's Wavetech HD Cables $$510$ $$5025$ KO$876$ Small

$9$ Max's Wavetech Processor $$27827$ $$695030$ KO$765$ Large

$10$ Max's Wavetech Hard disk $$12018$ $$216020$ KO$654$ Small

$11$

$12$

To find the average of the total cost of orders from Rex Technologies, what Excel formula should be used in A$12?$

Group of answer choices

$=$AVERAGE$($C$4$:C$7)$

$=$AVERAGE$($E$4$:E$7)$

$=$AVERAGE$($E$4$:E$10)$

$=$AVERAGE$($C$4$:C$10)$