EXCEL HELP Please !?

Question

Ok i do grades ( teacher) i like to put them grades in excel. I use the point system. ex: 10/50! So of course i put 10. Normally i would just do the math myself. I was wonderning if there was some way the computer do that for you? I want to have the computer add up some numbers then divide by so many numbers! Can u help?

Answer 1

Yeah it's real easy.

Just type:

=SUM(

Then select the cells where you entered the numbers you want to add. Then put an ending parenthesis. Then type / and then select the cell that has the number you want to divide by or just type in the number you wan to divid by.

So if the cells you wan to add up are in cells A1 through A4 and the number you want to divide by is in B1 it would look like this when you are done:

=SUM(A1:A4)/B1

Then just hit the enter key.

If you are just wanting to find the average. Then just type;

=average(

Then select the cells you want to average. Then end it with a parenthesis and hit enter. To average cells A1 through A4 it would look like this when you are done:

=AVERAGE(A1:A4)

For adding stuff, the summation button can make it even easier. The summation button has the sigma symbol on it. After you hit the summation button, all you have to do is select the cells you want to add and hit enter.

If you have trouble understanding formulas and stuff, click on the little F of x or F sub x button just the left of the formula bar where you normally enter in the formulas. That will bring up the insert function dialog box. You can select a category based on the type of function you want to use. Then you can select a function from the list. Excel provides help at the bottom of the dialog box to show you what info you put into the function. Each type of data that you enter is separated by a comma.

I figured I'd tell you about the dialog box so you can figure out and use new formulas in the future. Excel can be very helpful if a person knows how to use it.

Answer 2

Enter a formula in the block you want the answer to appear. There are a few ways to enter formulas. Write a formula that says sum which looks like a funky E, cells ---(name the cells you want added up), and put all of that over the number of cells you add up.

Another way is to highlight all the cells you want added, hit the funky E, and then divide the result by the number in the next square.

Hope this helps.

Answer 3

Yeah, that is why excel is all about, formula's.
You have to hi-lite the numbers you want and divide by either a number is another cell or a static number.
Ex:
IF in Column A (rows 1-4) you have:
1-10
2-15
3-25
4-35

and in Column B (row 1) you have 15
To get the answer in A5, you would write in A5
=(A1:A4)/B1 or just /15
Go to the summation button at the top and click on the down arrow for built in formula's.
If you need more help ask the help wizard, he shows you how.
Hope this helps

Answer 4

If I'm reading the question correctly "I want to have the computer add up some numbers then divide by so many numbers." you seem to be looking for the average. I suggest the following formula.

Assuming your values are in cells A1 to A9.

In cell A10 type "=AVERAGE(A1:A9)"

Answer 5

There are several ways you can do this.

First you can do the formula in the cell in excel
=(grade/total) * 100, i assume you want it in percentages

Second
you can do this in in 3 columns
first column (A) imput the grade the student gets
second column (B) input the total it is out of
third column do the formula =(A/B)*100