Wednesday, February 15, 2017

Monthly Bills Chart using Excel

In this exercise you will create the Monthly Bills chart that is on the back of the first page.  You will make it look like the one on the page.  All of your formatting instructions are on page 1.  REMEMBER WHEN YOU ENTER YOUR NUMBERS DO NOT PUT $$ IN FRONT OF THEM THEY WILL SHOW UP WHEN YOU FORMAT YOUR NUMBERS FOR CURRENCY!!!!

After you have created the spreadsheet you will add the graphs.  Each graph will be on its own seperate sheet (page) and you will name that sheet the last name of the renters that the graph represents, example change Sheet 2 to Delgado and so forth.  So when you finish you will have five sheets total.  To copy the graphs to their own sheet you simple create the graph on the initial page then cut and paste it to the new sheet.  Make sure you are changing the names of the graphs to the renters last names.

Save this spreadsheet as Bills Charts_your name to the computer then upload to your drive and go back and delete it from your computer.

No comments:

Post a Comment