DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
true
|
|
|
false
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -In Excel, dates are stored as sequential serial numbers. The imported dates are probably stored as a text value, instead of real numbers, and that is causing the formatting problem. Note: Only positive numbers can be formatted as valid dates.
Detailed explanation-2: -To apply the formatting, you simply go to the Home tab > Conditional Formatting > Highlight Cell Rules and select A Date Occurring. Select one of the date options from the drop-down list in the left-hand part of the window, ranging from last month to next month.
Detailed explanation-3: -Dates can be displayed in different ways using the following 2 options (available in the Number Format dropdown in the main menu): Short Date. Long Date.
Detailed explanation-4: -If the format is changed to d-mmm-yyyy, the date becomes 1-Jan-2021. We can change the date format in Excel either from the “Number Format” of the “Home” tab or the “Format Cells” option of the context menu. In Excel for Windows, 1900 is the default date system.