Math & Trig =SUMSQ(number1, [number2], ...)

Quiz =SUMSQ — 10 Questions

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

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

← SUMSQ ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

In =SUMSQ, which is argument #1?

Question 2 of 10 2/10

How many required arguments does =SUMSQ have?

Question 3 of 10 3/10

Which function is NOT related to =SUMSQ?

Question 4 of 10 4/10

In =SUMSQ, which is argument #2?

Question 5 of 10 5/10

Which statement about =SUMSQ is correct?

Question 6 of 10 6/10

Since which Excel version is =SUMSQ available?

Question 7 of 10 7/10

What is the output type of =SUMSQ?

Question 8 of 10 8/10

Which formula is a valid example of =SUMSQ?

Question 9 of 10 9/10

How many optional arguments does =SUMSQ have?

Question 10 of 10 10/10

Which function is related to =SUMSQ?

Click a question to see the answer.

1. In =SUMSQ, which is argument #1?

A. number1 ✓
B. value
C. lookup_value
D. criteria

Explanation: Argument #1 is “number1”.

2. How many required arguments does =SUMSQ have?

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

Explanation: =SUMSQ has 1 required, 1 optional (2 total).

3. Which function is NOT related to =SUMSQ?

A. SUMX2MY2
B. DEVSQ
C. PV ✓
D. SQRT

Explanation: “PV” is not related to SUMSQ.

4. In =SUMSQ, which is argument #2?

A. range
B. instead ✓
C. number1
D. lookup_value

Explanation: Argument #2 is “instead”.

5. Which statement about =SUMSQ is correct?

A. If an argument is an array or reference, only numbers in that array or reference are counted. This function will ignore empty cells, logical values, text, or error values in the array or reference.
B. Arguments can be > numbers > names, arrays, or references containing numbers. ✓
C. Volatile and recalculates every time
D. Requires add-in

Explanation: Correct: Arguments can be > numbers > names, arrays, or references containing numbers.

6. Since which Excel version is =SUMSQ available?

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

Explanation: Version: “All versions”.

7. What is the output type of =SUMSQ?

A. Array
B. Number ✓
C. Text
D. Value

Explanation: Output is “Number”.

8. Which formula is a valid example of =SUMSQ?

A. SUMSQ(3, 4)
B. =SUMSQ(3, 4, 0)
C. =SQRT(3, 4)
D. =SUMSQ(3, 4) ✓

Explanation: Correct example: =SUMSQ(3, 4)

9. How many optional arguments does =SUMSQ have?

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

Explanation: =SUMSQ has 1 required, 1 optional (2 total).

10. Which function is related to =SUMSQ?

A. IMTAN
B. SQRT ✓
C. HIDDEN
D. DISC

Explanation: “SQRT” is related to SUMSQ.