Question

5.
To enter date and time together, separate them with

​

Answer 1

Answer:

To separate date and time follow below given steps:-

1.Select the cell B1 and write the formula to extract date from cell A1.

=INT(A1), press enter.

2. Format this cell as “mm/dd/yyyy”

3. To format the cell, press the key “CTRL+1”

4.Format Cells dialog box will appear.

Explanation:

To separate date and time follow below given steps:-

Select the cell B1 and write the formula to extract date from cell A1.

=INT(A1), press enter.

Format this cell as “mm/dd/yyyy”

To format the cell, press the key “CTRL+1”

Format Cells dialog box will appear.

i help u help me by subscribing my channel

total gaming coc

Answer 2

Answer:

Cancel Button is the answer.