Logical =REDUCE([initial_value], array, lambda(accumulator, value, body))

Quiz =REDUCE — 10 Questions

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

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

← REDUCE ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

How many required arguments does =REDUCE have?

Question 2 of 10 2/10

Does =REDUCE return a dynamic array?

Question 3 of 10 3/10

Which formula is a valid example of =REDUCE?

Question 4 of 10 4/10

Which use case fits =REDUCE?

Question 5 of 10 5/10

Is argument “initial_value” required in =REDUCE?

Question 6 of 10 6/10

Which statement about =REDUCE is correct?

Question 7 of 10 7/10

What is the type of argument “array” in =REDUCE?

Question 8 of 10 8/10

In =REDUCE, which is argument #3?

Question 9 of 10 9/10

Which category does =REDUCE belong to?

Question 10 of 10 10/10

What is the output type of =REDUCE?

Click a question to see the answer.

1. How many required arguments does =REDUCE have?

A. 2
B. 0 ✓
C. 3
D. 1

Explanation: =REDUCE has 0 required, 3 optional (3 total).

2. Does =REDUCE return a dynamic array?

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

Explanation: REDUCE does not spill.

3. Which formula is a valid example of =REDUCE?

A. =LAMBDA(, A1:C2, LAMBDA(a,b,a+b^2))
B. =REDUCE(, A1:C2, LAMBDA(a,b,a+b^2)) ✓
C. =REDUCE(, A1:C2, LAMBDA(a,b,a+b^2), 0)
D. REDUCE(, A1:C2, LAMBDA(a,b,a+b^2))

Explanation: Correct example: =REDUCE(, A1:C2, LAMBDA(a,b,a+b^2))

4. Which use case fits =REDUCE?

A. Numbering & Sample Data
B. Forecasting & Trends
C. Advanced Formulas ✓
D. Workdays & Due Dates

Explanation: Use case “Advanced Formulas” fits REDUCE.

5. Is argument “initial_value” required in =REDUCE?

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

Explanation: “initial_value” is optional.

6. Which statement about =REDUCE is correct?

A. Use the initial_value argument to set the starting value for the accumulator parameter. In Example 2, where you multiply the accumulator, set the value to 1 to avoid multiplying by 0. ✓
B. NOTE: If no value is supplied for the initial_value, the first value in the array will be used as the starting value.
C. Requires add-in
D. Only works in old versions

Explanation: Correct: Use the initial_value argument to set the starting value for the accumulator parameter. In Example 2, where you multiply the accumulator, set the value to 1 to avoid multiplying by 0.

7. What is the type of argument “array” in =REDUCE?

A. Reference
B. Array ✓
C. Value
D. Date

Explanation: Type of “array” is “Array”.

8. In =REDUCE, which is argument #3?

A. lambda ✓
B. criteria
C. array
D. lookup_value

Explanation: Argument #3 is “lambda”.

9. Which category does =REDUCE belong to?

A. Logical ✓
B. Cube
C. Text
D. Compatibility

Explanation: Category is “Logical”.

10. What is the output type of =REDUCE?

A. Value
B. Array
C. Mixed ✓
D. Date

Explanation: Output is “Mixed”.