Question
A clerk maintains a monthly attendance sheet in MS Excel and wants one cell to always show the current date whenever the file is opened. Which formula should she enter in that cell?
Option 2 : =TODAY()
Detailed Solution
सही उत्तर =TODAY() है।
The TODAY() function returns the current date and updates it automatically each time the workbook is opened.
- ->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 state government wants to raise a loan from the market, but it still owes money to the Central Government on an earlier loan. The state is...
A Bill passed by a state legislature is sent by the Governor to the President for consideration instead of being given assent at the state l...
A newly formed company offers its shares to the general public for the first time to raise capital. In which market does this first-time pub...
A mountaineer climbing to a very high altitude begins to breathe faster and feels breathless even while resting. What is the main reason for...
A shipping company loads iron ore mined in Goa onto large vessels for export. Which major port on the west coast handles this iron ore traff...
In 1741, the forces of Travancore under Marthanda Varma defeated a European trading company in a battle fought near Colachel, ending that co...
Every five years the President sets up a body that recommends how the net proceeds of taxes should be shared between the Union and the state...
A district is selected for special attention because it lags behind on health, education, agriculture and infrastructure, and a central thin...
prepsnap.in • GeneralQuestion:
A clerk maintains a monthly attendance sheet in MS Excel and wants one cell to always show the current date whenever the file is opened. Which formula should she enter in that cell?
Correct Answer: =TODAY()
The TODAY() function returns the current date and updates it automatically each time the workbook is opened.