Thursday, December 12, 2013

Google Assignment # 3 Budget Spreadsheet

Today we are doing one of the required parts (the 3rd 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.  The directions are as follows;

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

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:

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 add the dollar sign and 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