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?
1 Monthly rate
2
3
4
5
6
7
Month
Jan
Feb
Mar
Apr
May
Jun
D
Number of units Cost
10
8
12
13
10
15
ОА.
=A2*D2
B.
=$A2 D2
ОС.
=$A$2*$D$2
D. =$A$2*D$2
E.
=A$2*D2