Types of Data in Microsoft Excel 2003, 2007, 2010.
In the Microsoft Excel spreadsheet you can find 3 basic types of data that can be entered into cells.
- Labels: - Text with no numerical value, help you to identify what you are talking about. (e.g. “Name” Name of any thing.)
- Constants: - Just a number, constant value of Number.[e.g. 1,+2,100]
- Formulas: - A mathematical equation used to calculate.[e.g.=sum(1,2)or =2+2]
Labels in Excel
Labels: - Are the text that entries into cell and help you to identify what you are talking about. [e.g. “Name” Name of any thing] They do not have a value.In the example the labels were: - Product, Price, Sold Price, Microsoft office,
Windows Xp, Windows7
The labels are NOT for the computer but rather for you so you can clarify what you are doing.
The labels are NOT for the computer but rather for you so you can clarify what you are doing.
Constants in Excel
Constants: - Are the Number entries into excel cells that have a specific or fixed value. This is a fixed value for each one
In the above example you can see there may be different types of numbers. Sometimes constants are referring to Percentages (%) Dollars ($), sometimes referring, and sometimes referring to a number of items (in this case 60 months)these are typed into the computer with just the numbers and are changed to display their type of number by formatting [e.g.” Rs.120.00 ” ,” 6 Months ” and many more] You use Constants to enter FIXED number data into cells.
In the above example you can see there may be different types of numbers. Sometimes constants are referring to Percentages (%) Dollars ($), sometimes referring, and sometimes referring to a number of items (in this case 60 months)these are typed into the computer with just the numbers and are changed to display their type of number by formatting [e.g.” Rs.120.00 ” ,” 6 Months ” and many more] You use Constants to enter FIXED number data into cells.
Formulas in Excel
Formulas: - Are the Formulas those entries in to Excel Cells which have an equation that calculates the value to display.
You DO NOT type in the numbers you are looking for; you type in the equation. This equation will be updated automatic you type the formulas like [e.g. =Sum(12,10) or =12+10 ] and the result come out as a number 22.
In Excel Formulas are mathematical equations. There is a list of the functions available within Excel under the menu INSERT down to Function.
Formulas Or Functions MUST BEGIN with an equal sign (=).
You use formulas to CALCULATE a value to be displayed as Number.
You DO NOT type in the numbers you are looking for; you type in the equation. This equation will be updated automatic you type the formulas like [e.g. =Sum(12,10) or =12+10 ] and the result come out as a number 22.
In Excel Formulas are mathematical equations. There is a list of the functions available within Excel under the menu INSERT down to Function.
Formulas Or Functions MUST BEGIN with an equal sign (=).
You use formulas to CALCULATE a value to be displayed as Number.
What is Formula in Excel?
Formula is a Mathematics equation which is entering to excel spreadsheet to CALCULATE a value to be displayed a result. Formulas OR Functions MUST BEGIN with an equal sign (=) or (+)
Basic Formulas in Excel
n Microsoft Excel when you are entering formulas into a spreadsheet you want to make calculation using many references of existing data. If you use reference of data information or Cell Address you don't have to type it in again. And importantly if that OTHER information changes, you DO-NOT have to change the equations.
If one worker work for 1 days and earn $25.00
Question-1: - If that worker works for 10 days, then how much he/she will earn?
Question-2: - If that worker works for 20 days, then how much he/she will earn?
Question-3: - If that worker works for 30 days, then how much he/she will earn?
If you start calculating on paper you have to calculate many time, But in a spreadsheet.
You have to enter the mathematical equations of formula once, if you change the working day the values (Result) will calculate automatic and you don’t have to put the formulas once more.
If one worker work for 1 days and earn $25.00
Question-1: - If that worker works for 10 days, then how much he/she will earn?
Question-2: - If that worker works for 20 days, then how much he/she will earn?
Question-3: - If that worker works for 30 days, then how much he/she will earn?
If you start calculating on paper you have to calculate many time, But in a spreadsheet.
You have to enter the mathematical equations of formula once, if you change the working day the values (Result) will calculate automatic and you don’t have to put the formulas once more.
Change the Formulas in Cell
If you want to change the formulas, you have to double click on the Cell in which you have entered the formula, then the cell will be on Edit mode also you can hit F2 the function key to edit cells and you can change the formulas.
Basic Math Functions
Microsoft Excel Spreadsheets have many Math functions built into them. Of the most basic operations are the standard multiply, divide, add and subtract. These operations follow the order of operations (just like algebra). Let's look at some : -
Selecting cells
In Microsoft Excel Selecting cells in an equation or in a formula is a very important concept of a spreadsheet. You need to know how to reference the data in other parts of the spreadsheet. When entering your selection you may use the keyboard or the mouse.
You can select several cells together if you can specify a starting cell and a ending cell. You can use Ctrl+A to select all Cells.
If the cells that You want to work with and they are not together (non-contiguous cells) You can use the comma “,” to separate the cells or by holding down the Shift Key+ Arrow Keys (←↓↑→)
You can select several cells together if you can specify a starting cell and a ending cell. You can use Ctrl+A to select all Cells.
If the cells that You want to work with and they are not together (non-contiguous cells) You can use the comma “,” to separate the cells or by holding down the Shift Key+ Arrow Keys (←↓↑→)
|
|