Thursday, April 3, 2014

Google #4 Budget Spreadsheet


Today we are doing one of the required parts (the 4th of 8) 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.
Click on Create.
Then click on Spreadsheet.
Change the Untitled Spreadsheet to "#4 Yourlastname."
Click share and type in misterwalske@gmail.com

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.

No comments:

Post a Comment