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

  1. A.

    =B1*BB4

  2. B.

    =$B1*B4

  3. C.

    =B1*B4

  4. D.

    =BB1*B4

Attempted by 4 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…