To calculate gross pay, hours are multiplied by the hourly rate. What MS.EXCEL…
2023
To calculate gross pay, hours are multiplied by the hourly rate. What MS.EXCEL formula would you put in cell C4 and then you are able to copy that cell down to the rest of the column C?
A | B | C | |
|---|---|---|---|
1 | Hourly Rate (in Rs) | 12.75 | |
2 | |||
3 | Name | Hours | Gross pay |
4 | Arjun | 26 | |
5 | Rishi | 37 | |
6 | Ishan | 36 | |
7 | Ajay | 28 | |
8 | Arun | 30 | |
9 | Nitin | 30 |
Answer: D. =$B$1*B4 — ConceptA relative cell reference changes when a formula is copied, while an absolute reference with dollar signs keeps both its column and row fixed. For a…
- A.
=B1*$B$4
- B.
=$B1*B4
- C.
=B1*B4
- D.
=$B$1*B4
Attempted by 1 students.
Show answer & explanation
Correct answer: D
Concept
A relative cell reference changes when a formula is copied, while an absolute reference with dollar signs keeps both its column and row fixed.
For a repeated calculation, the shared constant must stay absolute and the row-specific input must stay relative.
Application
The hourly rate is stored in B1, so every copied formula must use the fully absolute reference $B$1 for that cell.
The hours for Arjun are in B4, and that row should change to B5, B6, and so on when the formula is copied down.
Therefore the formula entered in C4 is =$B$1*B4; the absolute reference protects the rate, while the relative row in B4 follows each employee.
Contrast
In =B1*$B$4, the copied formula moves the rate reference but keeps the hours row fixed.
In =$B1*B4, both row references move; the dollar sign fixes only the column, which is irrelevant for a downward copy.
In =B1*B4, both column and row parts are relative, so both references shift down.
In =$B$1*B4, the rate reference is fully absolute and the hours reference remains relative.
Cross-check
At C4, the formula gives 12.75 × 26 = 331.50. After copying it to C5, it becomes =$B$1*B5 and gives 12.75 × 37 = 471.75, confirming both reference behaviors.
Thus, =$B$1*B4 is the required formula.