Spreadsheet Lab

https://docs.google.com/spreadsheets/d/1i-ryfJo985YNqgs5AMSFfJRrF59l_0dINDUQvCfWfNQ/edit?usp=sharing

For this lab, I first set up my rows and collumns with the appropriate labels. I then filled in my products, and their cost. After filling in the products I added their cost, revenue, and profit. I used a formula to help calculate the profit by subtracting the revenue from cost. Then I created an inflation section, and set it at 1.03. Another column was created for cost with inflation, and profit with inflation. Cost with inflation was calculated by using an absolute reference formula locking the inflation rate with a "$" and multiplying the cost by the inflation rate. Additionally the profit with inflation was created by subtracting cost with inflation with revenue. 

To make the spreadsheet visually appealing, I centered all data labels, added borders, and a chart to highlight the difference between the cost with and without inflation.