Consider the following worksheet:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||
|
|
|
|
||
|
|
Which of the following formula should be entered into cell D1 so that when it is copied into cells D2 and D3, it gives the correct values as shown in the range D1 ∶ D3?
1
\(B1\ast$C$1\)
2
\($B$1 \ast C1\)
3
\(B1 \ast C1\)
4
\($B$1 \ast $C$1\)