Paper 1 · ICT
UGC NET June 2024 Re-Exam (22.08.2024) Shift-II
In MS-Excel, a formula =B$1+C$3+5 in cell D9, when copied to cell F12, will become:
A=D1+E3=5
B=B$2+C$4+5
C=C$1+D$3+5
D=D$1+E$3+5 ✓ Correct
Correct answer: (D) =D$1+E$3+5 — The formula becomes =D$1+E$3+5, so that is the answer.
Explanation
★The formula becomes =D$1+E$3+5, so that is the answer.
★Copying from D9 to F12 moves the formula two columns right and three rows down.
★The column letters, being relative, shift two columns right, so B becomes D and C becomes E.
★The row numbers have a dollar sign, so they are absolute and do not change.
★So B$1 becomes D$1 and C$3 becomes E$3.
★The result is =D$1+E$3+5.
Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.
Shared by Mcqkart · via Mcqkart.in