The ________ function runs calculations only on the data that is in the subset when a filter is applied.
A) MAX
B) AVERAGE
C) SUBTOTAL
D) SUM

Question

Quizplus · Accepted Answer

The SUBTOTAL function is designed specifically to calculate values on filtered data. It can perform a variety of calculations, including SUM, AVERAGE, and MAX, but it will only calculate those values for the filtered subset of data.

The ________ Function Runs Calculations Only on the Data That