How would you add the contents of the cells from A1 to A10.

=SUM(A1:A10)
or
=A1+A2+A3+A4+A5+A6+A7+A8+A9+A10


How do you format a cell to have dollar signs next to the
numbers?

Click the currency button on the formatting tool bar or use a
custom number format of $#,##0.00

How do you add the contents of cells A1 through A10 on sheet 1
and make
the answer show up on sheet 2?

=SUM('Sheet1'!A1:A10)

How do you rename a sheet?

Right click the sheet tab and choose Rename


How do I freeze rows or columns of the sheet so that they
don't'
move when you scroll up or down? Example: My name is in Column
A, when
I scroll right my mane stays on the screen and column B moves
behind A

Select cell B1 and choose Freeze Panes from the Window menu.

How do you add up all the contents of column D and make the
answer show
up in column C?

=SUM(D:D)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"abi" wrote in message
oups.com...
Please can anyone help me answer any of these questions:

How would you add the contents of the cells from A1 to A10.
Give 2 ways
to do this. (hint: Look up "Examples of common formulas" in
Excel
help



How do you format a cell to have dollar signs next to the
numbers?



How do you add the contents of cells A1 through A10 on sheet 1
and make
the answer show up on sheet 2?



How do you rename a sheet?



Can I delete the sheets that I don't need? If so how?



How do I freeze rows or columns of the sheet so that they
don't'
move when you scroll up or down? Example: My name is in Column
A, when
I scroll right my mane stays on the screen and column B moves
behind A



How do you add up all the contents of column D and make the
answer show
up in column C?


Thanks in advance!
abi