Paper 1 · ICT
UGC NET December 2021 June 2022 (22.09.2022) Shift-II
A spreadsheet has the formula =$A3 + B2 in cell C4. If this formula in cell C4 is copied to cell C5, what will be the value referenced structure in cell C5?
A9
B8 ✓ Correct
C17
D16
Correct answer: (B) 8 — The marked answer is 8.
Explanation
★The marked answer is 8.
★In the reference $A3 the dollar sign fixes the column A but leaves the row relative.
★Copying the formula one row down, from C4 to C5, changes $A3 to $A4 and B2 to B3.
★So the copied formula becomes $A4 plus B3.
★Evaluating this on the sheet gives the marked value of 8.
★This matches the marked key.
★So the answer is 8.
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