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

Is argument “instead” required in =SUMSQ?

Question 2 of 10 2/10

Since which Excel version is =SUMSQ available?

Question 3 of 10 3/10

Which function is NOT related to =SUMSQ?

Question 4 of 10 4/10

How many arguments does =SUMSQ have in total?

Question 5 of 10 5/10

Which is the correct syntax of =SUMSQ?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

What is the output type of =SUMSQ?

Question 8 of 10 8/10

How many required arguments does =SUMSQ have?

Question 9 of 10 9/10

Which statement about =SUMSQ is correct?

Question 10 of 10 10/10

Which function is related to =SUMSQ?

Click a question to see the answer.

1. Is argument “instead” required in =SUMSQ?

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

Explanation: “instead” is optional.

2. Since which Excel version is =SUMSQ available?

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

Explanation: Version: “All versions”.

3. Which function is NOT related to =SUMSQ?

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

Explanation: “IMLOG2” is not related to SUMSQ.

4. How many arguments does =SUMSQ have in total?

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

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

5. Which is the correct syntax of =SUMSQ?

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

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

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

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

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

7. What is the output type of =SUMSQ?

A. Text
B. Logical
C. Date
D. Number ✓

Explanation: Output is “Number”.

8. How many required arguments does =SUMSQ have?

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

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

9. Which statement about =SUMSQ is correct?

A. Text is always ignored
B. 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.
C. Select entire column for best performance
D. Arguments can be > numbers > names, arrays, or references containing numbers. ✓

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

10. Which function is related to =SUMSQ?

A. SQRT ✓
B. HSTACK
C. DAY
D. NORMDIST

Explanation: “SQRT” is related to SUMSQ.