Computer Applications
The formula in cell A2 is = B2 + C3. On copying this formula to cell C2, the formula in cell C2 will be …………….. .
- = B2 + C3
- = C3 + B2
- = D2 + E3
- = E3 + D2
OOo Calc
3 Likes
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.
Answered By
1 Like
Related Questions
If you enter 12 + 24 in a cell, Calc will display ……………
- 36
- A12 + A24
- A12 : A24
- 12 + 24
Address of the cell at 20th column and 30th row is …………… .
- T20
- T30
- 20, 30
- 30T
Cancel button (x on formula bar) can be used to undo a cell entry after it has been completed.
- True
- False
All formulas start with an = sign in Calc.
- True
- False