How do you display current date only in MS Excel? A. Date () B. Today () C. Now () D. Time ()

The correct answer is: A. Date()

The Date function returns the current date in the system’s default date format.

The Today function returns the current date in the system’s default date format, but it is evaluated only once when the worksheet is opened.

The Now function returns the current date and time in the system’s default date and time format.

The Time function returns the current time in the system’s default time format.

Here is an example of how to use the Date function in a cell:

=Date()

This will return the current date in the system’s default date format.

Here is an example of how to use the Today function in a cell:

=Today()

This will return the current date in the system’s default date format, but it is evaluated only once when the worksheet is opened.

Here is an example of how to use the Now function in a cell:

=Now()

This will return the current date and time in the system’s default date and time format.

Here is an example of how to use the Time function in a cell:

=Time()

This will return the current time in the system’s default time format.