A) =today()
B) =now()
C) =time()
D) =currentTime()
Check Answer
The correct function to use to enter the current date and time that varies in a worksheet cell is: B) =now()
This function returns the current date and time, and will update the cell’s value whenever the worksheet is opened or recalculated.
To enter the current date only, you can use the function =today().
To enter the current time only, you can use the function =time().
There is no built-in function called =currentTime().
This function returns the current date and time, and will update the cell’s value whenever the worksheet is opened or recalculated.
To enter the current date only, you can use the function =today().
To enter the current time only, you can use the function =time().
There is no built-in function called =currentTime().
Related:
- Which function will you use to enter the current date in a…
- Which function will you use to enter the current time in a…
- Which of the following is not a basic step in creating a…
- Which of the following is not a way to complete a cell…
- Which of the following methods can not be used to enter the…
- In a worksheet you can select
- The name box in MS Excel
- Which tool you will use to join some cells and place the…
- New Comment options can be found under which tab
- Which of the following is not an option of spelling dialog…
- To create a formula you can use
- When creating a vertical page break
- What is entered by the function =today()
- Which of the following syntax is correct regarding SUM…
- You can use the horizontal and vertical scroll bars to