Question

choose the correct answer. which of the following commands will find the average of cells a1:a10 (including any hidden or filtered cells)? =subtotal(3,a1:a1 =subtotal(4,a1:a1 =subtotal(2,a1:a1 =subtotal(1,a1:a1

Explanation:

Step1: Understand the SUBTOTAL function

The SUBTOTAL function in Excel is used to calculate a subtotal in a list or database. The first argument is the function_num which specifies which function to use for the subtotal.

• Function_num 1: AVERAGE
• Function_num 2: COUNT
• Function_num 3: COUNTA
• Function_num 4: MAX

Step2: Match the function_num with the required operation

We need to find the average. So we should use the function_num corresponding to the AVERAGE function.

Answer:

=SUBTOTAL(1,A1:A10)