Excel to do math!
Friday, November 14, 2008 // 2:33 PM
Industry standard - What they use typically. (e.g. Microsoft word is the industy standard for word processing.)
Excel is similar to other Microsoft Office applications.
- go into tools and change toolbars
- tools deal mostly with numbers as it is mathematical based
- every little box is called a cell
- every cell has a name (e.g. D18)
- if you point at a cell, it's name will actually hightlight
- divided into colums and rows, all adjustable in size, can move things around, spread around
- can add text, different fonts
- inside a cell, three different kinds of information: text (string), value, formula
- example of text would be socks, value would be two, formula would be =2*.13 or =B5+D5
- never do math with microsoft excel, let excel do the math
- every formula starts with = sign
- if you use the cell name in a formula instead of a specific number, you can go back later and it will change automatically
- Other formulas: =sum(E7:D14) , =D16/8, =average(E13:F2)
- write sum by writing =sum(and then select all the cells and close bracket) and press enter and you can do the same for average
That's all for now!
- Serena
Labels: cell, Excel, formula, industry standard, Microsoft