JosephCarnevaleePortfolio1

In this ePortfolio I created a spreadsheet in Microsoft Excel to describe the utility usage and cost in our home. I made a simple table that had the titles: Month, Electric, Gas, Water, Monthly Totals. I first input all the data into this table and then began to use formulas to quicken the process. To get the average cost of each utility I used the =AVERAGE function and highlighted the range of cells under the utility to get an average of the expense. I also used the =SUM function to add up the costs for each utility to get the yearly cost for each. Next, I used Conditional Formatting to get the green data bars in each cell to represent the amount corresponding to each expense. Along with the data bars I used sparklines to also give a visual of expenses over a period of time. Finally I added two data charts as a visual. One a Line Chart, and the other an area chart.