To calculate gross pay. hours are multiplied by the hourly rate. What MS.EXCELL 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 |
1
=B1*$B$4
2
=$B1*B4
3
=B1*B4
4
=$B$1*B4