LIVE Course for free

Rated by 1 million+ students
Get app now
JEE MAIN 2023
JEE MAIN 2023 TEST SERIES
NEET 2023 TEST SERIES
NEET 2023
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
75 views
in General by (54.0k points)
closed by

What is the value of the following MS Excel formula?

=SUMSQ(1, 2, 3, 4) 


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

1 Answer

0 votes
by (30.0k points)
selected by
 
Best answer
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. 

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...