hamburger menu
All Coursesall course arrow
adda247
reward-icon
adda247
    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
    354k+ students have already unlocked exclusive benefits with Test Prime!
    Our Plans
    Monthsup-arrow