DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Number
|
|
|
Character
|
|
|
Label
|
|
|
Date/Time
|
Detailed explanation-1: -Explanation: Excel has three types of data types : values, labels and formulas but does not have any data type named as character.
Detailed explanation-2: -CHARACTER TYPE IS NOT A VALID DATA TYPE IN EXCEL.
Detailed explanation-3: -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-4: -Arrays are a data structure not a data type.
Detailed explanation-5: -Explanation: Following are the valid data types in excel: 1)Labels:-Labels (text) are descriptive pieces of information, such as names, months, or other identifying statistics, and they usually include alphabetic characters. 2)Values:-Values (numbers) are generally raw numbers or dates.