FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which of the following is a type of data that can NOT be used in calculations?

A	Labels
B	Values
C	Times
D	None of the above can be used

Explanation:

Detailed explanation-1: -Most equations can’t use text data since it’s alphanumeric. Numbers are the only way to represent values.

Detailed explanation-2: -Excel has three types of data types : values, labels and formulas but does not have any data type named as character.

Detailed explanation-3: -CHARACTER TYPE IS NOT A VALID DATA TYPE IN EXCEL.

Detailed explanation-4: -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-5: -You can enter three types of data in a cell: text, numbers, and formulas. Text is any entry that is not a number or formula. Numbers are values used when making calculations. Formulas are mathematical calculations.

There is 1 question to complete.