Question
Download Solution PDFWhat key combination is used to enter the current date in a cell of an MS Excel sheet?
Answer (Detailed Solution Below)
Detailed Solution
Download Solution PDFThe correct answer is CTRL + ;.
Key Points
- In Microsoft Excel, the key combination CTRL + ; is used to enter the current date into a selected cell.
- This shortcut is specifically designed to streamline data entry tasks, ensuring quick and accurate input of the current date.
- The CTRL + ; shortcut does not include the time, only the date, which is useful for date-specific records.
- Using this shortcut helps maintain consistency and reduces the risk of errors that might occur with manual date entry.
Additional Information
- CTRL + SHIFT + ;: This key combination enters the current time into the selected cell.
- CTRL + : (semicolon): This shortcut does not exist in Excel for date or time entry.
- CTRL + F10: This key combination maximizes or restores the window size of the Excel application.
- CTRL + F11: This key combination inserts a new macro sheet in older versions of Excel.
- Excel Shortcuts: Utilizing keyboard shortcuts in Excel increases efficiency and productivity by allowing quick access to various functions without the need for mouse clicks.
Last updated on Apr 2, 2025
->BHU Junior Clerk Application Deadline is now 30th April 2025.
->Candidates can send the Hard Copy of the downloaded application form to Office of the Registrar, Recruitment & Assessment Cell, Holkar House, BHU, Varanasi -221005 (U.P.) on or before 5th May 2025 upto 5:00 P.M..
-> Banaras Hindu University has issued a detailed notification for the Junior Clerk post, with 191 vacancies available.
-> The selection process includes a Written Examination and a Computer Typing Test
-> The BHU Junior Clerk role involves administrative and office tasks within the university. To participate in the selection process, candidates must meet the required eligibility criteria.