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

Which function is NOT related to =SUMXMY2?

Question 2 of 10 2/10

Since which Excel version is =SUMXMY2 available?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

What usually causes #N/A in =SUMXMY2?

Question 5 of 10 5/10

How many required arguments does =SUMXMY2 have?

Question 6 of 10 6/10

Which statement about =SUMXMY2 is correct?

Question 7 of 10 7/10

Which function is related to =SUMXMY2?

Question 8 of 10 8/10

Is argument “array_x” required in =SUMXMY2?

Question 9 of 10 9/10

What is the output type of =SUMXMY2?

Question 10 of 10 10/10

Which is the correct syntax of =SUMXMY2?

Click a question to see the answer.

1. Which function is NOT related to =SUMXMY2?

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

Explanation: “IMCSCH” is not related to SUMXMY2.

2. Since which Excel version is =SUMXMY2 available?

A. All versions ✓
B. Excel 2007 (Compatibility)
C. Excel 2019
D. Excel 365

Explanation: Version: “All versions”.

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

A. Select entire column for best performance
B. Output is always a dynamic array
C. Use equal sizes ✓
D. Volatile and recalculates every time

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

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

A. Output is always a dynamic array
B. Requires add-in
C. If array_x and array_y do not have the same number of values, SUMXMY2 returns the #N/A error value. ✓
D. Volatile and recalculates every time

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. How many required arguments does =SUMXMY2 have?

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

Explanation: =SUMXMY2 has 2 required, 0 optional (2 total).

6. Which statement about =SUMXMY2 is correct?

A. Requires add-in
B. Volatile and recalculates every time
C. The arguments should be either > numbers or > names, arrays, or references that contain numbers ✓
D. 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.

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

7. Which function is related to =SUMXMY2?

A. COLUMN
B. ABS ✓
C. TAN
D. STDEV.S

Explanation: “ABS” is related to SUMXMY2.

8. Is argument “array_x” required in =SUMXMY2?

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

Explanation: “array_x” is required.

9. What is the output type of =SUMXMY2?

A. Mixed
B. Reference
C. Number ✓
D. Array

Explanation: Output is “Number”.

10. Which is the correct syntax of =SUMXMY2?

A. =SUMXMY2(array_x, array_y) ✓
B. =ABS(array_x, array_y)
C. SUMXMY2(array_x, array_y)
D. =SUMXMY2(array_x, array_y, 0)

Explanation: Correct syntax: =SUMXMY2(array_x, array_y)