FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which type of data can NEVER be used in calculations?
A
Labels
B
Dates
C
Times
D
Values
Explanation: 

Detailed explanation-1: -Expert-Verified Answer Absolute References, Print Optimisation, Extend formula across/down and Flash Fill are some features of MS Excel. But currency is not a data type.

Detailed explanation-2: -Entering data into a spreadsheet is just like typing in a word processing program, but you have to first click the cell in which you want the data to be placed before typing the data. All words describing the values (numbers) are called labels. The numbers, which can later be used in formulas, are called values.

Detailed explanation-3: -The four types of data are Text, Number, Logical and Error.

Detailed explanation-4: -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.