DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Choose one that is not a data type from Microsoft Excel!
|
|
Time
|
|
|
Percent
|
|
|
Scientific
|
|
|
Number
|
|
|
Count
|
Explanation:
Detailed explanation-1: -CHARACTER TYPE IS NOT A VALID DATA TYPE IN EXCEL.
Detailed explanation-2: -The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.
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.
There is 1 question to complete.