which of the following commands will find the maximum of cells a1:a10 (excluding any hidden or filtered…

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

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

Answer

Brief Explanations:

In Excel, the SUBTOTAL function with function_num 104 is used to find the maximum value while ignoring hidden rows. Function_num 106 is for counting non - empty cells ignoring hidden rows, and 102 is for counting unique values ignoring hidden rows.

Answer:

=SUBTOTAL(104,A1:A10)