Which of the following is NOT a valid MS Excel 2007 formula?

Question 1

Which of the following is NOT a valid MS Excel 2007 formula?
1. SUMPRODUCT
2. SUMIF
3. SUM
4. SUMADD

Question 2

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.

Karanrawat · Answer 1 · 2022-03-01T15:33:46+0000

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.

Please log in or register to add a comment.