Math & Trig =SUMXMY2(array_x, array_y)

Quiz =SUMXMY2 — 10 Questions

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

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

← SUMXMY2 ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Does =SUMXMY2 return a dynamic array?

Question 2 of 10 2/10

Which formula is a valid example of =SUMXMY2?

Question 3 of 10 3/10

In =SUMXMY2, which is argument #1?

Question 4 of 10 4/10

What is the fix for #N/A in =SUMXMY2?

Question 5 of 10 5/10

Which statement about =SUMXMY2 is correct?

Question 6 of 10 6/10

Is =SUMXMY2 volatile?

Question 7 of 10 7/10

Which function is NOT related to =SUMXMY2?

Question 8 of 10 8/10

What usually causes #N/A in =SUMXMY2?

Question 9 of 10 9/10

Which category does =SUMXMY2 belong to?

Question 10 of 10 10/10

Which use case fits =SUMXMY2?

Click a question to see the answer.

1. Does =SUMXMY2 return a dynamic array?

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

Explanation: SUMXMY2 does not spill.

2. Which formula is a valid example of =SUMXMY2?

A. =ABS(A3:A9,B3:B9)
B. =SUMXMY2(A3:A9,B3:B9) ✓
C. SUMXMY2(A3:A9,B3:B9)
D. =SUMXMY2(A3:A9,B3:B9, 0)

Explanation: Correct example: =SUMXMY2(A3:A9,B3:B9)

3. In =SUMXMY2, which is argument #1?

A. array_y
B. value
C. range
D. array_x ✓

Explanation: Argument #1 is “array_x”.

4. What is the fix for #N/A in =SUMXMY2?

A. Volatile and recalculates every time
B. Use equal sizes ✓
C. Text is always ignored
D. Requires add-in

Explanation: If array_x and array_y do not have the same number of values, SUMXMY2 returns the #N/A error value. — Fix: Use equal sizes

5. Which statement about =SUMXMY2 is correct?

A. If an array or reference argument contains text, logical values, or empty cells, those values are ignored. However, cells with the value zero are included.
B. Text is always ignored
C. Volatile and recalculates every time
D. The arguments should be either > numbers or > names, arrays, or references that contain numbers ✓

Explanation: Correct: The arguments should be either > numbers or > names, arrays, or references that contain numbers

6. Is =SUMXMY2 volatile?

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

Explanation: SUMXMY2 is not volatile.

7. Which function is NOT related to =SUMXMY2?

A. ARABIC
B. ABS
C. AGGREGATE
D. UNICHAR ✓

Explanation: “UNICHAR” is not related to SUMXMY2.

8. What usually causes #N/A in =SUMXMY2?

A. Requires add-in
B. Output is always a dynamic array
C. If array_x and array_y do not have the same number of values, SUMXMY2 returns the #N/A error value. ✓
D. Select entire column for best performance

Explanation: If array_x and array_y do not have the same number of values, SUMXMY2 returns the #N/A error value. — Fix: Use equal sizes

9. Which category does =SUMXMY2 belong to?

A. Database
B. Compatibility
C. Math & Trig ✓
D. Logical

Explanation: Category is “Math & Trig”.

10. Which use case fits =SUMXMY2?

A. Comparation
B. Lookup & Retrieval
C. Rounding & Numeric ✓
D. Investment Appraisal

Explanation: Use case “Rounding & Numeric” fits SUMXMY2.