Question

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

Answer 1

Answer:

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

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.

Answer 2

Answer:

B.  =NOW()

Explanation:

edg 2020