To calculate gross pay, hours are multiplied by the hourly rate. What MS.EXCEL…
PYQ UGC NET 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 |
- A.
=B1*4
- B.
=$B1*B4
- C.
=B1*B4
- D.
=1*B4
Attempted by 4 students.
Sign up free to check your answer
Sign up freeLoading lesson…

