Monday, May 2, 2016

Assignment #6- Google Drive #3 Budget

This is a Google Drive assignment.
Today you are doing one of the required parts of the applied skills portion of this class.  You will be creating a budget spreadsheet using Google Drive.


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.

Next, 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, and choose one of the three different types of pie charts.
Position the chart so that it is not covering your values (to the right of the cells).

No comments:

Post a Comment