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
	Hourly Rate (in Rs.)		12.75
1	Name	Hours	Gross pay
2	Arjun	26
3	Rishi	37
4	Ishan	36
5	Ajay	28	Gross pay
6	Arun	30
7	Nitin	30

In the light of the above statements, choose the correct answer from the options given below.

The correct option is =$B$1 *B4.

Step-by-Step Explanation:

1. Analyze the Spreadsheet Structure:
Let us identify the position of the data points from the provided table:
- Column A contains the Name (starting from row 1 with headers). Specifically, cell A1 has "Hourly Rate (in Rs.)", and cell C1 contains the value 12.75 (which is the hourly rate).
- Column B contains the Hours worked. Row 1 is the header ("Hours"), row 2 is Arjun's hours (26 in B2), row 3 is Rishi's hours (37 in B3), row 4 is Ishan's hours (36 in B4), and so on.
- Column C is designated for Gross pay. Row 1 is the header ("Gross pay"). Row 4 corresponds to Ishan's gross pay in cell C4.

2. Determine the Gross Pay Formula for Cell C4:
Gross pay is calculated as: Gross Pay = Hourly Rate × Hours.
- For Ishan (row 4), the hours worked are located in cell B4.
- The hourly rate is a single fixed value located in cell C1. However, looking at the spreadsheet layout provided in the table, the hourly rate "12.75" is in cell C1, but the options use $B$1 to represent the Hourly Rate cell (which corresponds to row 1, column B being referenced or representing the hourly rate field placement in the formula options). Based strictly on the correct option provided (=$B$1 *B4), the hourly rate is referenced by cell $B$1, and Ishan's hours are in B4.

3. Understand Absolute vs. Relative Cell Referencing:
When copying a formula down a column, we must ensure that:
- The reference to the hourly rate remains fixed to cell B1. To lock a cell reference so it does not change when copied, we use absolute referencing with dollar signs ($B$1).
- The reference to the hours worked must change relatively as we move down the column (from B2 to B3, B4, B5, etc.). Therefore, we use a relative reference B4 (or B4) for the hours, which will automatically update to B5, B6, etc., when copied down.
- Therefore, the formula in cell C4 is =$B$1 *B4. When this cell is copied down to the rest of column C, the formula automatically updates the relative part (B4 becomes B5, B6, etc.) while keeping the absolute part (B1) constant.