Question

The first argument in the SUBTOTAL function identifies the ________?

1) number of decimal places in the result
2) cell range
3) number of significant digits in the result
4) statistic to be calculated

Answer 1

In the SUBTOTAL function, the first argument specifies the type of statistic to be calculated, such as sum or average.

Step-by-step explanation:

The first argument in the SUBTOTAL function identifies the statistic to be calculated. In the SUBTOTAL function, the first argument specifies the type of statistic to be calculated, such as sum or average. Option 4 is the correct answer.

That means whether you're summing, averaging, counting, and so on, the first number you enter tells Excel what kind of calculation to perform on the data range you specify subsequently. In the SUBTOTAL function, the first argument specifies the type of statistic to be calculated, such as sum or average.

The cell range is specified after this first argument, and significant figures are not directly related to the use of the SUBTOTAL function.