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
153 views
in General by (54.0k points)
closed by
Which of the following is NOT a valid MS Excel 2007 formula? 
1. SUMPRODUCT 
2. SUMIF 
3. SUM
4. SUMADD 

1 Answer

0 votes
by (30.0k points)
selected by
 
Best answer
Correct Answer - Option 4 : SUMADD 

The correct answer is SUMADD.

  • The SUMPRODUCT function returns the sum of the products of corresponding ranges or arrays.
  • The SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criterion.
  •  As a worksheet function, the SUMIF function can be entered as part of a formula in a cell of a worksheet.
  • The SUM function adds values. You can add individual values, cell references or ranges, or a mix of all three.
  • For example: =SUM(A2:A10) Adds the values in cells A2:10.

Related questions

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

...