206k views
5 votes
What function text would you use to put today's date and time in a cell? =TODAY()

=NOW()
NOW()
TODAY()

2 Answers

4 votes

Answer:

B. =NOW()

Step-by-step explanation:

edg 2020

User Meetnick
by
4.8k points
4 votes

Answer:

The answer to this question is given below in the explanation section.

Step-by-step explanation:

The correct answer to this question is:

=NOW()

Now() is a function that you can use to put today's date and the current time in a cell. While Today() function is a function that can only be used to put today's date.

Other options are not correct because:

If you write NOW() and TODAY() as it is in a cell, then Excel will not consider them as a function. To write a function in a cell, you have to write the "=" symbol before the function name. If you will emit the "=" symbol before the function, then the function name will be consider as text in a cell.

User Godsent
by
4.1k points