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.

All of the Windows spreadsheets try to figure out what you want to print.  Sometimes they're right,  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.

Move to cell G6 under the title Monthly Totals. Choose one of the formulas you learned earlier to add each of the amounts in Parents for the four months.  Use any of the four methods you desire. Your spreadsheet should look like the one to right, just before you copy the formulas.

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.”

Now move to cell A21 and type in the word Percent. We're going to calculate a fun percentage to show you how division works and give you some more practice with numbers.

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.

3 Method (Windows):  The last three methods work in all spreadsheets. 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.  Now look at the upper area of the screen, just below the menu bar, for a 3  (summation) symbol button.

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 the diagram to the right).

Again move to cell C9 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.