What is the value of the following MS Excel formula?

=SUMSQ(1, 2, 3, 4)

This question was previously asked in

Dehli Police Constable Previous Paper 20 (Held on: 9 Dec 2020 Shift 3)

Option 3 : 30

Delhi Police Constable 2020: Full Mock Test

94967

100 Questions
100 Marks
90 Mins

The correct answer is ** 30**.

__Key Points__

- The '
**SUMSQ**' is the formula to**sum the squares**of the given numbers. - Here, sum of squares of
**(1, 2, 3, 4) is 1+4+9+16 = 30**

__Additional Information__

- CONCATENATE is one of the easiest to learn but most powerful formulas when conducting data analysis.
- COUNTA identifies whether a cell is empty or not.
- DAYS is exactly what it implies. This function determines the number of calendar days between two dates.
- SUMIFS is one of the “must-know” formulas for a data analyst.