The ________ function will run calculations on data that is in a subset when a filter is applied.
A)SUM
B)TOTAL
C)SUBTOTAL
D)SUMMARY

Question

Quizplus · Accepted Answer

The SUBTOTAL function is specifically designed to run calculations on data that is in a filtered subset. It can also include or exclude hidden rows and error values. The SUM and TOTAL functions do not have this capability and the SUMMARY function does not exist.

The ________ Function Will Run Calculations on Data That Is