What is the value of the following MS Excel formula?
=SUMSQ(1, 2, 3, 4)

Correct option is C

The SUMSQ function in MS Excel calculates the sum of the squares of the numbers provided. In this case, the numbers are 1, 2, 3, and 4. The formula works as follows:
Solution:
1. Square each number:
· 1² = 1
· 2² = 4
· 3² = 9
· 4² = 16
2. Add the squared values:
· 1 + 4 + 9 + 16 = 30
Thus, the value of the formula =SUMSQ(1, 2, 3, 4) is 30.
Important Key Points:
1. SUMSQ function: This function returns the sum of the squares of the arguments provided.
2. Calculation of Squares: Each number is squared individually before the sum is calculated.
3. Formula Application: In the given example, squaring 1, 2, 3, and 4 gives 1, 4, 9, and 16 respectively, and their sum is 30.
Knowledge Booster:
· SUMSQ is different from the SUM function, which simply adds the numbers without squaring them.