A Spreadsheet Modeler Is Creating a Spreadsheet to Calculate Each

Multiple Choice

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. After entering the data below, the modeler would like to enter a formula in cell C5 that can then be copied to cells C6 through C9 without further modification. What formula should be entered in cell C5 to make this possible?

A) =B2*B5
B) =B2*$B$5
C) =$B$2*B5
D) =$B$2*$B$5
E) =B2+B5