Paper 1 · ICT
UGC NET December 2021 June 2022 (08.10.2022) Shift-I
In a worksheet, cell D1 should contain a formula that multiplies the fixed values in B1 and C1, such that when it is copied into D2 and D3 it still gives the correct values from D1 to D3. Which formula should be entered into D1?
AB1 * $C#1
B$B$1 * C1
CB1 * C1
D$B$1 * $C$1 ✓ Correct
Correct answer: (D) $B$1 * $C$1 — The answer is $B$1 times $C$1.
Explanation
★The answer is $B$1 times $C$1.
★The dollar signs make both cell references absolute.
★So when the formula is copied down to D2 and D3, it still points to B1 and C1.
★This keeps the same fixed product in every cell.
★So the correct formula is $B$1 times $C$1.
★The other formulas would shift the references when copied.
★So the answer is $B$1 times $C$1.
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