Question

and aggregate functions
2 - ignore error values, nested subtotal
and aggregate functions
3 - ignore hidden rows, error values, nested
subtotal and aggregate functions
4 - ignore nothing
5 - ignore hidden rows
6 - ignore error values
7 - ignore hidden rows and error values
choose the correct answer.
which of the following commands will
find the sum of cells a1:a10 (ignoring
nothing)?
=aggregate(6,2,a1:a10)
=aggregate(12,7,a1:a10)
=aggregate(9,4,a1:a10)

Explanation:

Step1: Understand AGGREGATE function syntax

The AGGREGATE function has the syntax =AGGREGATE(function_num, options, ref1, [ref2,...]). The function_num for sum is 9.

Step2: Analyze the options

The problem states "ignoring nothing". From the given options list, option 4 means "ignore nothing".

Answer:

=AGGREGATE(9,4,A1:A10)