Bike Store Profits

SOLs CT 6-8.4 - 6-8.6, CT 6-8.8

1. Create the following spreadsheet of bicycles and their prices

 

2. Use a subtraction formula in column D to find out how much profit the store makes on each bike - example =(B9-C9)

3. You do not need to include column B or C, so hide them by right-clicking the column letter and selecting Hide to create a chart that looks similar to the following: