Multiple Choice Questions

In MS Excel to insert a sum formula in a cell we must ........

Computer GK (IBPS RRB PO) MS Office

In MS Excel, to insert a sum formula in a cell, we must _______ _______.

This questions was previously asked in

RRB Officer Scale-I Mains (1st Oct 2022)

=sum(A1:A2)

=Add(a1:a2)

=sum(1A:2A)

=Add(1A:2A)

None of the above

- Option 1: `=sum(A1:A2)`

- This is the correct way to insert a sum formula. It calculates the total of values in cells A1 and A2.

- Option 2: `=Add(a1:a2)`

- Incorrect. Excel does not have a function called `Add`. Use `SUM` for addition instead.

- Option 3: `=sum(1A:2A)`

- Incorrect. The cell references are written incorrectly. They should be A1:A2.

- Option 4: `=Add(1A:2A)`

- Incorrect for two reasons: wrong function and incorrect cell references.

- Option 5: None of the above

- Incorrect because Option 1 is right.

Submit Error