Math & Trig =AGGREGATE(function_num, options, ref1, [ref2], …)

Quiz =AGGREGATE — 10 Questions

10 quiz questions about =AGGREGATE — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← AGGREGATE ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which category does =AGGREGATE belong to?

Question 2 of 10 2/10

In =AGGREGATE, which is argument #1?

Question 3 of 10 3/10

In =AGGREGATE, which is argument #3?

Question 4 of 10 4/10

How many required arguments does =AGGREGATE have?

Question 5 of 10 5/10

In =AGGREGATE, which is argument #2?

Question 6 of 10 6/10

How many arguments does =AGGREGATE have in total?

Question 7 of 10 7/10

Is =AGGREGATE volatile?

Question 8 of 10 8/10

What is the type of argument “ref1” in =AGGREGATE?

Question 9 of 10 9/10

What is the type of argument “options” in =AGGREGATE?

Question 10 of 10 10/10

Which statement about =AGGREGATE is correct?

Click a question to see the answer.

1. Which category does =AGGREGATE belong to?

A. Math & Trig ✓
B. Date & Time
C. Compatibility
D. Cube

Explanation: Category is “Math & Trig”.

2. In =AGGREGATE, which is argument #1?

A. function_num ✓
B. range
C. options
D. ref1

Explanation: Argument #1 is “function_num”.

3. In =AGGREGATE, which is argument #3?

A. lookup_value
B. ref1 ✓
C. criteria
D. ref2

Explanation: Argument #3 is “ref1”.

4. How many required arguments does =AGGREGATE have?

A. 6
B. 4 ✓
C. 5
D. 3

Explanation: =AGGREGATE has 4 required, 0 optional (4 total).

5. In =AGGREGATE, which is argument #2?

A. options ✓
B. ref1
C. function_num
D. criteria

Explanation: Argument #2 is “options”.

6. How many arguments does =AGGREGATE have in total?

A. 3
B. 5
C. 6
D. 4 ✓

Explanation: =AGGREGATE has 4 required, 0 optional (4 total).

7. Is =AGGREGATE volatile?

A. No ✓
B. Yes
C. —
D. No

Explanation: AGGREGATE is not volatile.

8. What is the type of argument “ref1” in =AGGREGATE?

A. Range
B. Logical
C. Any type
D. Number ✓

Explanation: Type of “ref1” is “Number”.

9. What is the type of argument “options” in =AGGREGATE?

A. Range ✓
B. Any type
C. Reference
D. Number

Explanation: Type of “options” is “Range”.

10. Which statement about =AGGREGATE is correct?

A. Errors:
B. Function_num⁠:⁠ ✓
C. Select entire column for best performance
D. The AGGREGATE function is designed for columns of data, or vertical ranges. It is not designed for rows of data, or horizontal ranges. For example, when you subtotal a horizontal range using option 1, such as AGGREGATE(1, 1, ref1), hiding a column does not affect the aggregate sum value. But, hiding a row in vertical range does affect the aggregate.

Explanation: Correct: Function_num⁠:⁠