Thursday, March 21, 2013

Assignment #4- Monthly Budget

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.

Sign in to Google and go to Drive (or Documents).
Click on Create.
Then click on Spreadsheet.
Change the Untitled Spreadsheet to "Budget Yourlastname."
Click share and type in

You are going to create a monthly budget.

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

Cell Phone
Car Payment

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 "Backwards E looking tool"

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

Finally select all of the cells (words and dollar amounts) except the total cell 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.

No comments:

Post a Comment