Bright Tutorials Bright Tutorials
CBSE Class 9 Computer Applications Question 20 of 53

Spreadsheet Tool : OO Calc I — Question 16

Back to all questions
16
Question

Question 16

The formula in cell A2 is = B2 + C3. On copying this formula to cell C2, the formula in cell C2 will be ................. .

  1. = B2 + C3
  2. = C3 + B2
  3. = D2 + E3
  4. = E3 + D2
Answer

= D2 + E3

Reason — When we copy the formula from cell A2 to cell C2, Calc adjusts the relative cell references in the formula based on the new location. When we copy the original formula "= B2 + C3" to cell C2, Calc will adjust the formula to "= D2 + E3", where it shifts the column references by 2 columns to the right and keeps the row references the same.