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

Which use case fits =SUMSQ?

Question 2 of 10 2/10

How many required arguments does =SUMSQ have?

Question 3 of 10 3/10

Since which Excel version is =SUMSQ available?

Question 4 of 10 4/10

What is the type of argument “instead” in =SUMSQ?

Question 5 of 10 5/10

Which formula is a valid example of =SUMSQ?

Question 6 of 10 6/10

What is the type of argument “number1” in =SUMSQ?

Question 7 of 10 7/10

Which is the correct syntax of =SUMSQ?

Question 8 of 10 8/10

Which statement about =SUMSQ is correct?

Question 9 of 10 9/10

In =SUMSQ, which is argument #2?

Question 10 of 10 10/10

Which category does =SUMSQ belong to?

Click a question to see the answer.

1. Which use case fits =SUMSQ?

A. Daily Tasks
B. Ranking & Top N
C. Scientific & Unit Conversion ✓
D. Date & Time Calculations

Explanation: Use case “Scientific & Unit Conversion” fits SUMSQ.

2. How many required arguments does =SUMSQ have?

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

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

3. Since which Excel version is =SUMSQ available?

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

Explanation: Version: “All versions”.

4. What is the type of argument “instead” in =SUMSQ?

A. Reference
B. Text
C. Array
D. Range ✓

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

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

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

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

6. What is the type of argument “number1” in =SUMSQ?

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

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

7. Which is the correct syntax of =SUMSQ?

A. =SUMSQ(number1, [number2], ...) ✓
B. =SUMSQ(number1, [number2], ..., 0)
C. SUMSQ(number1, [number2], ...)
D. =SQRT(number1, [number2], ...)

Explanation: Correct syntax: =SUMSQ(number1, [number2], ...)

8. Which statement about =SUMSQ is correct?

A. Arguments can be > numbers > names, arrays, or references containing numbers. ✓
B. Errors will occur from > arguments that are error values > text that cannot be translated into numbers
C. Output is always a dynamic array
D. Text is always ignored

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

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

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

Explanation: Argument #2 is “instead”.

10. Which category does =SUMSQ belong to?

A. Math & Trig ✓
B. Compatibility
C. Information
D. Statistical

Explanation: Category is “Math & Trig”.