How do you set a page up to do math on excel spreadsheet?

Question

I am trying to make a spreadsheet in excel, and was hoping i could show math functions (such as adding and subtracting out of a collum), i am new to excel and have had no training.

Answer 1

Let's discuss a simple example like Column A + Column B = Column C

Open a new Excel worksheet
You can give the columns a name in line 1
In Col. A and B, enter the values
In Col. C, you will type an = sign
this indicates that you are about to enter a formula
look to the top of the window - you will see the formula bar
you should see SUM
click SUM
you will now see =SUM(A2:B2)
this means C = A through B

you could click inside the parens and change this to
=A2+B2

when you hit "enter" the value will be entered
Get the idea?

Here is a good source for books:
http://www.amazon.com/s/ref=nb_ss_b/002-3084014-9311250?url=search-alias%3Dstripbooks-used&field-keywords=Excel

Answer 2

all funtions start with = and my example cells (boxes) will be a1 and b1

subtract =a1-b1
multiply =a1*b1
divide =a1/b1
add =a1+b1

Answer 3

hit ctrl+ ~ and that should do it

to take it out do it again

it prints like shown!

Answer 4

Add: =sum(A1+B1)
Subtract =sum(A1-B1)
Multiply =sum(A1*B1)
Divide =sum(A1/B1)
Average =AVERAGE(A1+B1)