Monday, July 20, 2009

If you happen to make a mistake

If you happen to make a mistake simply retype the entries. Later on we'll see how to
edit mistakes. Any time you want to replace something in a cell you can simply retype and the new entry and it will replace the old one.

Cell Type-in

A3 Income

B4 Parents
B5 Job
B6 Investments
B7 Total

A10 Expenses

B11 Food
B12 Beverages
B13 Parties
B14 Miscellaneous
B15 Total
Your spreadsheet should now look similar to the image on the right.
At this point you probably noticed, the words "Investments" and "Miscellaneous" run over the spaces given in the cells. Do not be concerned at this point. We’ll soon fix this.

Now, type the numbers in the cells indicated:

C4 300
C5 50
C6 150

When you type-in the 150, tap Enter.
Your spreadsheet should look like the image on the right.

Notice, when you enter text that the words line up on the left side of the cells. When you enter numbers, they line up on the right side. This is because we are using the United States (English) version of Excel. Other international versions will line up logically for their text and monetary forms.

We would like to place an underline at the bottom of the three figures so that we can indicate a total below – in cell C7. Point to cell C7 (with the mouse). That's where we want the line ‑‑ always move the cursor to the place where you want to insert a line. With the Arrow on cell C7 tap the right mouse button.

No comments:

Post a Comment