Question
An operator has a list of call durations in an Excel sheet and wants to find the longest call. Which function should be used?
Option 4 : MAX
Detailed Solution
सही उत्तर MAX है।
MAX returns the largest value in a range, so it gives the longest call duration; MIN gives the smallest, SUM adds the values and AVERAGE finds their mean.
- ->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
Consider the following statements about the National Human Rights Commission (NHRC) of India: 1. It was established in 1993 under the Protec...
Which of the following is NOT a function of NITI Aayog?
The Sundarbans, the largest Ramsar site in India, was designated as a Ramsar site in which year?
Which of the following pairs of GI-tagged products and their states is correctly matched?
Chandrayaan-3's rover Pragyan confirmed the presence of which element near the lunar south pole?
Manu Bhaker, who won two bronze medals at the Paris Olympics 2024, became the first Indian after independence to do which of the following?
The 42nd Constitutional Amendment Act of 1976 is often called the 'Mini Constitution' because it did which of the following?
The International Court of Justice, the only principal organ of the United Nations located outside New York, is situated in which city?
prepsnap.in • GeneralQuestion:
An operator has a list of call durations in an Excel sheet and wants to find the longest call. Which function should be used?
Correct Answer: MAX
MAX returns the largest value in a range, so it gives the longest call duration; MIN gives the smallest, SUM adds the values and AVERAGE finds their mean.