DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Ctrl+D
|
|
Ctrl+; (semicolon)
|
|
Ctrl+Shift+; (semicolon)
|
|
Ctrl+Shift+D
|
Detailed explanation-1: -To insert the current date, press Ctrl+; (semi-colon). To insert the current time, press Ctrl+Shift+; (semi-colon). To insert the current date and time, press Ctrl+; (semi-colon), then press Space, and then press Ctrl+Shift+; (semi-colon).
Detailed explanation-2: -To use this shortcut, simply hold down the Ctrl key and then press the semicolon key, and it will instantly add the current date.
Detailed explanation-3: -Shift + Alt + D shortcut key is used to insert the current date.
Detailed explanation-4: -You can also select cells in a row or column by selecting the first cell and then pressing CTRL+SHIFT+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns). Note: If the row or column contains data, CTRL+SHIFT+ARROW key selects the row or column to the last used cell.