FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

BASICS OF BIG DATA

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To insert only the current date in cell B1, use the NOW function in cell B1.
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -To insert the current date in cell B1, type CURRENT DATE in cell A1 and NOW() in cell B1 and press ENTER.

Detailed explanation-2: -The TODAY() function returns today’s date, exactly as its name suggests. Note. The date returned by the TODAY function in Excel updates automatically when your worksheet is recalculated to reflect the current date.

Detailed explanation-3: -Sometimes when we want to display the current date and time in a worksheet, we can use the NOW function. The date and time will update whenever the worksheet is recalculated or opened. To do that, we need to just insert the formula =NOW() in the cell where the current date and time should appear.

Detailed explanation-4: -Shift + Alt + D shortcut key is used to insert the current date.

There is 1 question to complete.
Previous
Next