Saturday, November 15, 2008

Life made easy with Excel!

Wonder why they call it exCEL? It’s because excel is a spreadsheet (basically a piece of paper filled with cells that have their own names) you use to do your entire math, and save time. Excel is a great way to calculate your marks, do long tiring calculations in just a blink of an eye. And here's the great part, if you have used excel in the right way, and you make a mistake, you have no worries. The only work you need to do is not worry and just try finding where you made the mistake, fix it and everything else gets fixed, like MAGIC! Impossible right? No way, nothings impossible! All you need to do is follow simple steps. You can do many things like add text, color, different fonts and make the columns and rows as small or as big as you want.
Say you want to find the sum of your entire tests so far. You need to write three pieces of information to help you. You need text string, value and formula. Under text you would write all your subjects. Under value you would write how much each test is out of, and under formula you would write a formula. Let’s say you wrote your one of your subjects in cell B2. (the text string) *If you are unsure where to find the names of the cells, you click on it and at the top of the page on the left hand side, it will say the name. For example: D18.* And you have your test results in columns B3, B4, B5, B6, B7 and B8. (the value) And you want to figure out the total of all your marks. All you need to do is click on the cell you want your total to appear in, write =sum, then open brackets and hold 'CTRL' and click on the numbers you want to add up. It would look something like this: =SUM(B3,B4,B5,B6,B7,B8) This is how you should get your answer. Because if you make a mistake on the way, and you have done your calculations with this formula, you can simply change one number and your answer will automatically change! But if you have written =SUM(B3,B4,B5,B6,B7,B8) on your own without selecting the cells, you are going to have to do that all over again. Especially if there are a lot of cells to find the sum's of.
It’s very easy; you just need to know what you want to figure out. So if it’s an average of something, you click on the cell you want your answer to appear in, write =average, open brackets, select the cells you want, close the brackets and you have your answer! And you didn't need to think at all!

See you soon.

Peggy

No comments: