DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
text
|
|
|
mathematical
|
|
|
date and time
|
|
|
financial
|
Detailed explanation-1: -Date and Time Functions. Date and time functions operate on a date and time input value and return a string, numeric, or date and time value. Operand type: datetime can be an ANSIDATE, TIMESTAMP, CHAR, VARCHAR, NCHAR, or NVARCHAR; n is an integer. Adds the number, which represents months, to the date.
Detailed explanation-2: -The DATE function returns the sequential serial number that represents a particular date. The DATE function syntax has the following arguments: Year Required. The value of the year argument can include one to four digits.
Detailed explanation-3: -If you need to display the current date and time in a worksheet, you can use the NOW function. The date and time will update whenever the worksheet is recalculated or opened.
Detailed explanation-4: -Excel stores dates and times as serial numbers. It is the number of days since January 1, 1900 plus a fraction for the time of day. For example, January 1, 1900 is 1, February 1, 1900 is 32, and so on. Times are stored as fractions of a day.