Question

Select the correct answer.

Jeff has created a table to calculate the cost of raw materials that he purchases monthly. Cell A2 shows the fixed cost of the raw material (3). Column D
lists the quantity (number of units) that Jeff purchased each month. What formula can Jeff use in E2 to calculate the monthly cost of the raw material
that he can copy to all the rows below?
A
1 Monthly rate
2
3
3
4
5
6
7
OA.
B.
=$A2 D2
C. =$A$2"$D$2
=$A$2"D$2
= A$2 D2
O D.
=A2 D2
OE
B
C
Month
Jan
Feb
Mar
Apr
May
Jun
D
Number of units Cost
10
8
62305
12
13
10
15
E

Answer 1

The correct formula for Jeff to calculate the monthly cost of raw materials in cell E2 and copy to all rows below is option B:

\[ \text{B.} \quad =\$A2 \times D2 \]

This formula multiplies the fixed cost of raw materials in cell A2 by the quantity (number of units) in each corresponding row in column D. The dollar signs (\$) before A and D indicate that these references should remain fixed when copied to other cells, ensuring that Jeff is always multiplying by the fixed cost in A2 and the quantity in the respective row in column D.