Question

104 - max
105 - min
106 - product
107 - stdev.s
108 - stdev.p
109 - sum
110 - var.s
111 - var.p
choose the correct answer.
which of the following commands will find the minimum of cells a1:a10 (including any hidden or filtered cells)?
=subtotal(7,a1:a10)
=subtotal(9,a1:a10)
=subtotal(5,a1:a10)

Explanation:

Step1: Recall the function of SUBTOTAL

The SUBTOTAL function in Excel is used to calculate a subtotal in a list or database. The first argument is a number (1 - 11 or 101 - 111) that specifies which function to use for the subtotal.

Step2: Know the meaning of each number in SUBTOTAL

• 1 or 101 - AVERAGE
• 2 or 102 - COUNT
• 3 or 103 - COUNTA
• 4 or 104 - MAX
• 5 or 105 - MIN
• 6 or 106 - PRODUCT
• 7 or 107 - STDEV.S
• 8 or 108 - STDEV.P
• 9 or 109 - SUM
• 10 or 110 - VAR.S
• 11 or 111 - VAR.P

Step3: Determine the correct formula

Since we want to find the minimum value (including any hidden or filtered cells), and the number corresponding to MIN in SUBTOTAL is 5 (when considering all cells including hidden/filtered, as opposed to 105 which is for a subset in some cases in more complex scenarios, but in the basic sense here), the formula =SUBTOTAL(5,A1:A10) is correct.

Answer:

=SUBTOTAL(5,A1:A10)