DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The following is an example of writing a short date format ____
|
|
Sunday, 28 September 2021
|
|
|
28 September 2021
|
|
|
28/09/2021
|
|
|
28/09
|
Explanation:
Detailed explanation-1: -The international standard recommends writing the date as year, then month, then the day: YYYY-MM-DD.
Detailed explanation-2: -dd. MM. yyyy-Example: 23.06. 2013.
Detailed explanation-3: -The United States is one of the few countries that use “mm-dd-yyyy” as their date format–which is very very unique! The day is written first and the year last in most countries (dd-mm-yyyy) and some nations, such as Iran, Korea, and China, write the year first and the day last (yyyy-mm-dd).
Detailed explanation-4: -Solution, Know that the correct format to write the date in a formal letter in India is Month Date, Year in full with no abbreviations. Hence, the correct option is (C) i.e. September 22nd, 2021.
There is 1 question to complete.