Case EX 13-2 Gregory works for the local public television station. The station has recently held a TV pledge drive and they have received a large number of pledges from viewers and businesses. The data about the pledge drive is stored in a worksheet. The worksheet has six columns: First Name, Last Name, Address, Phone, Pledge, Received. The Received column contains "Yes" or "No" values depending on whether the amount pledged has been received by the station. From only the pledges which have been received, Gregory wants to find out the average amount pledged. He can first filter the data and then use the ____ function.
A) SUMIF
B) COUNTA
C) COUNT
D) Subtotal

Question

Quizplus · Accepted Answer

The Subtotal function can be used to calculate the average of filtered data in Excel.

Case EX 13-2 Gregory Works for the Local Public Television