Question

To calculate gross pay, hours are multipled by the hourly rate. what formula would you put in cell c4 to then be able to copy that cell down to the rest of the column? a. B1*$B$4

b. $B1*B4
c. B1*B4
d. $B$1*B4

Answer 1

The formula to calculate gross pay in cell C4, and then copy it down to the rest of the column, would be: B1*B4

The answer is option ⇒C

Step-by-step explanation:

Let's break down the formula:

• - B1 represents the cell that contains the number of hours worked.
• - B4 represents the cell that contains the hourly rate.

By multiplying the number of hours (B1) by the hourly rate (B4), we get the gross pay.

To copy this formula down to the rest of the column, we need to ensure that the cell references adjust correctly. In this case, we don't need to use absolute references (with dollar signs) because we want the formula to adjust relative to the row.

So, by copying the formula in cell C4 and pasting it down to the rest of the column, each cell will calculate the gross pay based on the corresponding number of hours and hourly rate.

The answer is option ⇒C