Question

What is the value of the following MS Excel formula?

=SUMSQ(1, 2, 3, 4) 

1. 10 
2. 34
3. 30 
4. 24 

Answer 1

Correct Answer - Option 3 : 30 

The correct answer is 30.

• 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

• 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.