Question

In Excel 2007, Date and Time display is independent of ________. (Choose any three correct options)
(a) Text present in cell
(b) Data corrector of call
(c) Symbol used in cell
(d) Format of a cell

Answer 1

b) data corrector of call

Answer 2

In Excel 2007, Data and Time display is independent of Text present in cell, Data corrector of the cell, Symbol used in the cell.

Explanation:

• The time function has three kinds of arguments namely hour, minute and second.  

• The time and date values can be used ‘independently’ of the text, data, symbols used in the cell.  

• Cell formatting may affect the data and time display. For example, we cannot see 30 seconds in cell (example cell B2) due to the default cells formatting for the time in the provided spreadsheet.  

• The general formatting might shows up as an ‘integer fraction’. The date and time are automatically formatted.