McqkartGet appPractise

Which of the following MS-EXCEL formulas are equivalent to each other? Choose the correct answer from the options given below:

1.= A3 + A4 + A5 + A6
2.= SUM(A3:A6)
3.= SUM(A3, A6)
4.= SUM(A3, A4, A5, A6)
A1, 2 and 3
B1, 2 and 4 ✓ Correct
C2 and 4
D3 and 4
Correct answer: (B) 1, 2 and 4
Explanation

The formulas that add all four cells A3, A4, A5 and A6 are equivalent, namely the plus expression, the range sum and the listed-cells sum.

Statement 1 adds A3 plus A4 plus A5 plus A6 directly, giving the total of the four cells.

Statement 2 uses the colon range A3 to A6, which means every cell from A3 down to A6, the same four cells.

Statement 4 lists the four cells separated by commas, again totalling exactly A3, A4, A5 and A6.

Statement 3 with SUM of A3 and A6 adds only the two named cells A3 and A6, skipping A4 and A5, so it differs.

A colon means a continuous range while a comma means only the specific cells named.

Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.

Practise on Mcqkart →🎓 Book an expert →