DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The EDATE function requires two arguments: the start date and the number of months that you want to add or subtract. To subtract months, enter a negative number as the second argument. For example, =EDATE("9/15/19", -5) returns 4/15/19. For this example, you can enter your starting dates in column A.
Detailed explanation-2: -=DATEVALUE(date text) The DATEVALUE function includes the following arguments: Date text – This is a required argument. It is the text that represents a date in an Excel date format, or a reference to a cell that contains text that represents a date in an Excel date format.
Detailed explanation-3: -The method to use this formula is as follows =YEAR (serial number). The serial number is the date argument given to the function. For example, suppose we insert 19-Sep-87 in cell A1. Then, the YEAR function =YEAR(A1) will return 1987.