Dev is working on an Excel Sheet. He enters a formula as shown in the figure…
2023
Dev is working on an Excel Sheet. He enters a formula as shown in the figure given below. He copies the same formula in rest of 9 (Nine) rows. What will be the output?
- A.
Excel will display the same output for each formula in each row.
- B.
Excel will display different output for each formula.
- C.
Formula is wrong.
- D.
Error will be displayed.
- E.
Question not attempted
Attempted by 77 students.
Show answer & explanation
Correct answer: B
The formula uses relative row references (1 and 124) while the column is fixed. When copied down, Excel increments these row numbers (e.g., to $A2:$A125). This shifts the range of cells summed for each row, resulting in different calculated values.