USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
The current date and time
|
|
The current time
|
|
The current date
|
|
The current hour
|
Detailed explanation-1: -A static value in a worksheet is one that doesn’t change when the worksheet is recalculated or opened. When you press a key combination such as Ctrl+; to insert the current date in a cell, Excel “takes a snapshot” of the current date and then inserts the date in the cell.
Detailed explanation-2: -Here’s the key step: instead of hitting ENTER the way you normally do, hit CTRL + ENTER and Excel will replicate the formula in all of the selected cells.
Detailed explanation-3: -4. Want to copy, paste, or cut, or undo? Press Ctrl + C to copy the contents of selected cells, Ctrl + X to cut the contents of selected cells, Ctrl + V to paste content into a selected cell, and Ctrl + Z to undo the last action.
Detailed explanation-4: -When we are entering data or a formula in a cell, and have multiple cells selected, Ctrl+Enter will copy the data/formula to all of the selected cells.
Detailed explanation-5: -To insert today’s date in Excel you simply type “=today” in the cell and then open and close brackets “()” with nothing in between them.