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?

Using absolute references $B$1 and $C$1 locks both cells so the formula points to them even after copying.

The form B1 * $C#1 uses invalid syntax with a stray hash symbol.

The form $B$1 * C1 fixes only B1, so C1 shifts when copied down.

The form B1 * C1 uses relative references that both change when copied.

A dollar sign before a column letter and row number makes a reference absolute.

Copying a relative reference down a column increases its row number automatically.