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

Question

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

Quizplus · Accepted Answer

The Answer of 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

A Spreadsheet Modeler Is Creating a Spreadsheet to Calculate Each