Question

choose the correct answer. which of the following commands will find the maximum of cells a1:a10 (excluding any hidden or filtered cells)? =subtotal(106,a1:a10) =subtotal(102,a1:a10) =subtotal(104,a1:a10)

Explanation:

To determine the correct SUBTOTAL function for finding the maximum of cells A1:A10 (excluding hidden/filtered cells), we recall the SUBTOTAL function's syntax: SUBTOTAL(function_num, ref1, [ref2,...]). The function_num for MAX (excluding hidden) is 104. Let's analyze the options:

• Option 1: =SUBTOTAL(106,A1:A10) uses function_num 106, which is for PRODUCT, not MAX.
• Option 2: =SUBTOTAL(102,A1:A10) uses function_num 102, which is for AVERAGE, not MAX.
• Option 3: =SUBTOTAL(104,A1:A10) uses function_num 104, which corresponds to MAX (ignoring hidden/filtered cells).

Answer:

C. =SUBTOTAL(104,A1:A10) (assuming the options are labeled A, B, C as per the three buttons, with the third button being the correct one)