Consider the following worksheet:

	A	B	C	D
1		5	10	50
2			15	50
3			20	50
4

Which of the following formulas should be entered into the cell D1 so that when it is copied into the cells D2 and D3, it gives the correct values as shown in the range D1:D3?

Correct option is D

When copying the formula down a column, we need to fix some references while allowing others to change. The $ symbol locks the row or column reference.
· In this case, $B$1 locks both column B and row 1, ensuring the formula always refers to cell B1.
· $C$1 locks both column C and row 1, ensuring that cell C1 is always referenced when the formula is copied.
Information Booster:
1. In Excel, absolute references (e.g., $B$1) ensure that the referenced cell does not change when the formula is copied to other cells.
2. Relative references (e.g., B1) change depending on where the formula is copied.
Additional Knowledge:
Formulas without $ symbols will change both row and column references when copied, leading to incorrect results in this case.