DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The following does not include data types in Ms. Excel is
|
|
General
|
|
|
Currency
|
|
|
Percentage
|
|
|
Time
|
|
|
Average date
|
Explanation:
Detailed explanation-1: -CHARACTER TYPE IS NOT A VALID DATA TYPE IN EXCEL.
Detailed explanation-2: -In a Data Model, each column has an associated data type that specifies the type of data the column can hold: whole numbers, decimal numbers, text, monetary data, dates and times, and so on.
Detailed explanation-3: -The four types of data are Text, Number, Logical and Error.
Detailed explanation-4: -Dates in Excel All dates are stored as integers representing the number of days since January 1, 1900, which is stored as number 1, to December 31, 9999 stored as 2958465. In this system: 2 is 2-Jan-1900. 3 is 3-Jan-1900.
There is 1 question to complete.