Google #4 Budget Spreadsheet

Today we are doing one of the required parts of the applied skills portion of this class.  We will be creating a budget spreadsheet using Google.

To begin, you must log in to Google and go to drive (documents).

Follow the directions that I give in class.  

You are going to create a monthly budget.

Starting with cell A1, then A2, then A3, etc. through A10, you will type in these 10 expenses:

Rent

Utilities

Cable

Cell Phone

Car Payment

Insurance

Gas

Food

Entertainment

Savings

In cell A11 you will type Total.

Then you will select cells B1 through B10 and then click the dollar sign button.  Then with the cells still selected click on the sum button found in the "Crazy E looking tool" at the end of the row of tools.

Now enter in dollar amounts in each of the cells.  The program will automatically add the dollar sign and total these dollar amounts.

Finally, select all of the cells (words and dollar amounts) except for the total cells at the bottom.

Then click on insert chart (There is a button for this or you can find it under the insert tab).

Select the pie chart.

Position the chart so that it is to the right of the cells.