Question
In MS Excel, a formula in cell C1 reads '=A1+B1'. If the formula is copied to cell C2, it will become:
Option 1 : =A2+B2
Detailed Solution
सही उत्तर =A2+B2 है।
Relative cell references adjust when a formula is copied, so copying '=A1+B1' from C1 to C2 changes it to '=A2+B2'.
- ->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 Domain-Specific Questions
A government servant is dismissed from service without an inquiry after being convicted by a criminal court. Which Article permits dispensin...
The Central Vigilance Commission was given statutory status by which of the following Acts?
In the Union Budget, the fiscal deficit is the difference between the total expenditure of the Government and:
The 'Roaring Forties' are strong westerly winds found between which latitudes in the Southern Hemisphere?
A patient is advised to avoid iodised salt and undergo a thyroid function test. Which gland's disorder is being investigated?
The Vernacular Press Act of 1878 was repealed during the viceroyalty of:
Which Article of the Constitution provides for the appointment of the Comptroller and Auditor General of India?
The Ramsar Convention, to which India is a party, is concerned with the conservation of:
prepsnap.in • Domain-SpecificQuestion:
In MS Excel, a formula in cell C1 reads '=A1+B1'. If the formula is copied to cell C2, it will become:
Correct Answer: =A2+B2
Relative cell references adjust when a formula is copied, so copying '=A1+B1' from C1 to C2 changes it to '=A2+B2'.