In the formula = SUBTOTAL(1, Customers_Table(ID]), what does the 1 refer to?
A) the first field to analyze
B) the number of the column to analyze
C) the number of values to analyze
D) the number of the function to use

Question

Quizplus · Accepted Answer

In the SUBTOTAL formula, the first argument refers to the function being used to analyze the data. The number 1 specifically refers to the function AVERAGE, so this formula will calculate the average of the values in the ID column of the Customers_Table.

In the Formula = SUBTOTAL(1, Customers_Table(ID]), What Does the 1