Which are the basic data types in Excel? (Excel-2007)

Q. Which are the basic data types in Excel?

Ans. In a spreadsheet there are three basic types of data that can be entered:-

·   Labels (text) are descriptive pieces of information such as names, months, or   other identifying statistics, and they usually include alphabetic characters.

·   Values (numbers) are generally raw numbers or dates.

·   Formulas are instructions for Excel to perform calculations.

Data types	Examples	Descriptions
LABELS	Name or Wage or Days	anything that is just text
VALUES	5 or 3.75 or -7.4	any number
FORMULAS	=5+3 or = 8*5+3	math equation

NOTE: ALL formulas MUST begin with an equal sign (=).

Labels are text entries. They do not have a value associated with them. We typically use labels to identify what we are talking about.

In our first example: the labels were

• computer ledger
• car loan
• interest
• # of payments
• Monthly Pmt.

Values are entries that have a specific fixed value. If someone asks you how old you are, you would answer with a specific answer. Sure, other people will have different answers, but it is a fixed value for each person.

Examples: the constants are

• 12,000
• 9.6%
• 60

Formulas are entries that follow = sign in a cell. It performs calculations of some type and returns a result, which is displayed in the cell.  Formulas use a variety of operators and worksheet functions to work with values and text.

Examples:

·         =A1+A2+A3

·         =SUM(A1:A3)

·         =25*30

Related Posts by Categories