Question

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

Answer 1

Insert a static date or time into an Excel cell

Because that cell's value doesn't change, it's considered static. On a worksheet, select the cell into which you want to insert the current date or time. Do one of the following: To insert the current date, press Ctrl+; (semi-colon).

pls mark Brainliest

Answer 2

Answer:

The correct answer to the question -How do you display current date and time in MS Excel ?" is-

D) Today ()

Explanation:

INSERTING DATE AND TIME TO EXCEL SHEET-

Steps to insert a date or time into an Excel cell are as under-

1. Press Ctrl+; (semi-colon) inorder to  insert the current date,
2. Press Ctrl+Shift+; (semi-colon)inorder to insert the current time,

That  is, first we have to press Ctrl+; (semi-colon)to insert the current date and then we have to, press Space, and then press Ctrl+Shift+; (semi-colon).

Another technique in refrence to the options of the questions-

To display the current date

1. We use the generic formula. =TODAY()
2. That is, inorder to display the current date in MS excel, we use the TODAY function. The date gets update when the worksheet is  opened or recalculated.
3. This function is entered with empty parentheses.

Therefore, the correct option to the question is-

D) Today ()

A, time() function -

It returns the current time in the number of seconds

B) Now ()  function -

It returns the serial number of the current date and time.

C) Date () function -

It is needed to take three separate values and combining them to form a date.

To know more about ms-excel click on the link below-

https://brainly.in/question/41302020

To know more about internet explorer click on the link below-

https://brainly.in/question/8140316