FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Nominal data is qualitative or categorical data, while Ordinal data is considered “in-between” qualitative and quantitative data. Nominal data do not provide any quantitative value, and you cannot perform numeric operations with them or compare them with one another.

Detailed explanation-2: -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-3: -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-4: -The Logical Data Type Unlike numerical and text data, logical data cannot be typed in Excel manually by the user and instead will show up as a result of an expression or function.

Detailed explanation-5: -The data that you enter can be numbers, text, dates, or times. You can format the data in a variety of ways. And, there are several settings that you can adjust to make data entry easier for you. This topic does not explain how to use a data form to enter data in worksheet.