Question
A clerk maintains a list of 200 ESI beneficiaries in Excel. She wants to count how many beneficiaries are from Delhi. Which function should she use?
Option 1 : COUNTIF
Detailed Solution
सही उत्तर COUNTIF है।
COUNTIF counts the cells in a range that meet a given condition, such as the city being Delhi.
- ->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 state government announces an employment guarantee scheme citing a Directive Principle that directs the State to secure the right to work....
The Royal Commission on Labour, the first commission to examine labour conditions in India, was appointed in which year?
Which country was the first in the world to introduce a modern social insurance system for workers, under Chancellor Otto von Bismarck?
The International Labour Organization, the UN agency that sets international labour standards, was founded in which year?
Which Article of the Indian Constitution prohibits human trafficking and forced labour?
A worker in a factory in Gujarat is injured while operating a machine and the employer fails to report the accident. Under Indian labour law...
Which of the following is a specialised agency of the United Nations that deals with health, and works closely with the ILO on occupational ...
Which ministry administers the Employees Provident Fund Organisation?
prepsnap.in • Domain-SpecificQuestion:
A clerk maintains a list of 200 ESI beneficiaries in Excel. She wants to count how many beneficiaries are from Delhi. Which function should she use?
Correct Answer: COUNTIF
COUNTIF counts the cells in a range that meet a given condition, such as the city being Delhi.