To use the SUBTOTAL function to calculate the sum of filtered table records, set the Function_Num argument to _____.
A) 1 for AVERAGE
B) 9 for SUM
C) 2 for COUNT
D) 10 for TOTAL

Question

Quizplus · Accepted Answer

The Function_Num argument for the SUBTOTAL function should be set to 9 to calculate the sum of filtered table records. This is because 9 corresponds to the SUM function within the SUBTOTAL function. The other function numbers listed in the options correspond to different functions like AVERAGE, COUNT, and TOTAL, which would not give the desired result of calculating the sum of filtered table records.

To Use the SUBTOTAL Function to Calculate the Sum of Filtered