arrow
arrow
arrow
Which combination of keys do you press to enter the current date in a cell in MS-Excel?
Question


Which combination of keys do you press to enter the current date in a cell in MS-Excel?

A.

Ctrl + Shift + :

B.

Ctrl + ;

C.

Ctrl + F10

D.

None of these

Correct option is B

Pressing Ctrl + ; in MS-Excel inserts the current date into the selected cell. This shortcut allows users to quickly add today’s date without manually typing it.
Important Key Points:
1. Date Insertion: Ctrl + ; is specifically designed to add the current date in Excel.
2. Efficiency: Speeds up data entry, especially in logs or tables that require date records.
3. Fixed Value: The inserted date remains static and does not update automatically.
Knowledge Booster:
· Ctrl + Shift + : Inserts the current time in a cell.
· Ctrl + F10: Maximizes or restores the window, not related to date insertion.

Free Tests

Free
Must Attempt

SSC GD PYP (Held on 4 Feb 2025 S1)

languageIcon English
  • pdpQsnIcon80 Questions
  • pdpsheetsIcon160 Marks
  • timerIcon60 Mins
languageIcon English
Free
Must Attempt

Hindi Section Test 1

languageIcon English
  • pdpQsnIcon20 Questions
  • pdpsheetsIcon40 Marks
  • timerIcon12 Mins
languageIcon English
Free
Must Attempt

SSC GD Constable Full Mock Test 1

languageIcon English
  • pdpQsnIcon80 Questions
  • pdpsheetsIcon160 Marks
  • timerIcon60 Mins
languageIcon English
test-prime-package

Access ‘Supreme Court of india’ Mock Tests with

  • 60000+ Mocks and Previous Year Papers
  • Unlimited Re-Attempts
  • Personalised Report Card
  • 500% Refund on Final Selection
  • Largest Community
students-icon
368k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow