If you would like to have logical names for your Excel 2003 spreadsheet tabs – rather than     Sheet 1 and Chart 1, we’ll now show you how to do this.

This will be a lot of fun.  We are now going to turn your spreadsheet numbers into graphics    bar charts, pie charts, etc.  This will greatly assist you when you display and explain your work.

First, move to cell A1.

sometimes they're wrong. So........

There are times, when we are working with a spreadsheet, that we do not want a cell to "roll" to the next column when we use the copy feature of the spreadsheet – like it did in our last copying exercise.  To stop the cells from “rolling” we utilize something called absoluting.  The following is an illustration of absoluting.

We could repeat what we did to this point and fill in the Income and Expenses for each of the remaining columns.  There is a simpler way to do this.  Assuming our income and expense amounts are about the same, throughout the months, we want to copy the amounts in Column C to Columns D, E and F.  This will require two “steps.”

We want our numbers to look better.  To do this we'll include dollar signs and decimal points in our numbers. This is done by using the mouse.  Point to cell C6, hold down the left mouse button and drag down slowly to highlight cells C6 through C19.  Your screen should look like the one at the top of the next page.

Since we add numbers more than any other operation in spreadsheets, Excel spreadsheet has an additional feature - Auto Sum.  Move to cell C9 again and tap the delete key to erase your last formula.

There are a number of formulas built into Excel, like Sum. These formulas are called Functions.  Below the Menu Bar (see right) you will see a “sigma” ∑  with a small down triangle to the right of the sigma (see arrow on diagram to the right). Click on the down triangle.

Move again to cell C9.  Delete the formula by tapping the Delete key again.

Move to cell C9 again and click-on it.  We'll now add the numbers a second way.  Tap the Delete key on the keyboard to delete the current formula.