DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If you use the Ctrl+; keyboard shortcut to enter data into a cell, what would Excel actually enter into the cell?
|
|
The current date and time
|
|
|
The current time
|
|
|
The current date
|
|
|
The current hour
|
Explanation:
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: -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.
There is 1 question to complete.