Question
A clerk copies a formula down a column in MS Excel but wants one cell reference to stay fixed on the same cell in every row. Which type of reference should she use for that cell?
Option 1 : Absolute reference
Detailed Solution
सही उत्तर Absolute reference है।
An absolute reference, written with dollar signs such as $A$1, does not change when a formula is copied to other cells.
- ->SSC CGL Admit Card 2026Download Tier — 1 Hall Ticket Region — wise, Exam Day Rules
- ->SSC CGL Exam Date 2026Tier — 1 Schedule (30 Sep–30 Oct), Shifts, City Slip & Admit Card Dates
- ->SSC CGL Exam Date 2026Tier — 1 Schedule (30 Sep–30 Oct), Shifts, City Slip & Admit Card Dates
- ->SSC CGL 2026 Notification Out10,731 Vacancies, Apply Online, Exam Dates, Eligibility
- ->SSC GD Physical Test 2026PET/PST Running, Height, Chest Standards, Dates
- ->SSC GD Constable Cut Off 2026 OutState — wise, Category — wise Cut Off Marks (Male/Female)
- ->SSC GD Constable Result 2026 Out1,97,408 Candidates Shortlisted for PET/PST — Check Merit List PDF
- ->RRB NTPC Cut Off 2026Expected CBT — 1 Cut Off, Previous Year Cut Offs (Zone — wise)
Recommended Test Series
Attempt full-length mock tests, sectional papers & All India Rank
AIIMS CRE Social Security Officer, Manager Grade-II & Superintendent Test Series 2026
AIIMS CRE Social Security Officer, Manager Grade-II & Superintendent Test Series 2026
20 Total Tests
- •20 Full Test (Prelims)
SSC GD Constable Test Series
SSC GD Constable Test Series
145 Total Tests
- •15 Full Test (Prelims)
- •50 Sectional Test
- •55 Chapter Test
- +25 more tests
DSSSB Junior Scientific Assistant (LieDetection) Test Series 2026 | 25+ Mock Tests
DSSSB Junior Scientific Assistant (LieDetection) Test Series 2026 | 25+ Mock Tests
120 Total Tests
- •20 Full Test (Prelims)
- •100 Sectional Test
AIIMS CRE Assistant Security Officer Test Series 2026
AIIMS CRE Assistant Security Officer Test Series 2026
70 Total Tests
- •20 Full Test (Prelims)
- •50 Sectional Test
More General Questions
A law student reads that Parliament used its power to change the Constitution to insert a new provision about local government. Under which ...
A news report says a state has been under President's Rule for two years after its Assembly was suspended. What is the maximum period for wh...
A district office receives forms for the nationwide population count that is conducted once every ten years. Which authority conducts the Ce...
A traveller plans a road trip through the largest Union Territory of India by area, a high-altitude desert region in the north. Which Union ...
A trader buys coffee beans from the state that grows the most coffee in India. Which state is it?
A geography teacher tells the class that the Tropic of Cancer passes through a certain number of Indian states, from Gujarat in the west to ...
A chemistry teacher asks which acid gives vinegar its sour taste and is used in pickles and food preservation. Which acid is it?
A safety officer explains that most fire extinguishers used in offices release a gas that cuts off the supply of oxygen to the fire. Which g...
prepsnap.in • GeneralQuestion:
A clerk copies a formula down a column in MS Excel but wants one cell reference to stay fixed on the same cell in every row. Which type of reference should she use for that cell?
Correct Answer: Absolute reference
An absolute reference, written with dollar signs such as $A$1, does not change when a formula is copied to other cells.