Question Details

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.

Options

A

=B1*$B$4

B

=$B1 *B4

C

=B1*B4

D

=$B$1 *B4

Show Answer
Correct Answer
D =$B$1 *B4

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.

Transparent Access on Mindyard

Built for Learners & Educators Alike

Completely free for students. Educators & coaching institutes get 2 months free Pro trial to create tests.

FREE FOR STUDENTS

Practice & Learn Free for Students

Access unlimited practice questions, detailed step-by-step solutions, and exam study materials — completely free for students.

  • Unlimited mock tests & question bank practice
  • Full access to curated study library & formula notes
  • 100% free for students • No credit card required
2 MONTHS FREE TRIAL

Educators & Coaching Institutes

Create and conduct professional online assessments with AI question generation, tab proctoring, and comprehensive batch management.

  • AI question uploader & rapid test generator
  • Anti-cheating tab proctoring & performance reports
  • Full Pro access free for 60 days • No upfront commitment
Discover more resources

You may also like

Mock Tests

View All
  • UGC NET
  • intermediate
  • 1 hour

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.

  • UGC NET
  • intermediate
  • 2 hours
  • english

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.

Ask AI Tutor
5 left
Q1 View Question & Options
AI Tutor is solving this question...
Reading question context & options...
Ask your own doubt or choose a quick prompt: