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.
Solution :
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.
Completely free for students. Educators & coaching institutes get 2 months free Pro trial to create tests.
Access unlimited practice questions, detailed step-by-step solutions, and exam study materials — completely free for students.
Create and conduct professional online assessments with AI question generation, tab proctoring, and comprehensive batch management.
The UGC NET Paper–1 General Aptitude Sample Paper is a well-structured practice resource designed to help aspirants prepare effectively for the Paper–1 section of the UGC NET. This sample paper covers all key areas including Teaching Aptitude, Research Aptitude, Logical Reasoning, Data Interpretation, Communication, ICT, Higher Education System, and People & Environment. Prepared according to the latest exam pattern, it features a balanced mix of conceptual, analytical, and application-based multiple-choice questions. The paper is designed to simulate real exam conditions, helping candidates improve accuracy, speed, and time management. Ideal for both beginners and advanced learners, this sample paper enables aspirants to evaluate their preparation level, identify weak areas, and strengthen core concepts for better performance in the actual UGC NET examination.
Master your preparation with a focused and exam-oriented program designed specifically for UGC NET English Paper 2. This course helps you build deep conceptual clarity and strong analytical skills required to excel in literature and language-based questions.
Copyright © 2026 Combe Labs Private Limited. All Rights Reserved.