MSExcel - Pricing Comparisons
One of the great things about spreadhseets is how quickly and easily you can create spreadsheets and then compare prices.
In this task you are going to create a workbook that has 7 different sheets in it.
The sheets will include:
- A sheet that compares the base price of 5 minivans form 1996 to 2000
- A sheet that looks at how the price of options for the Chevrolet minivan has increased from 1996 to 2000
- A sheet that looks at how the price of options for the Ford minivan has increased from 1996 to 2000
- A sheet that looks at how the price of options for the Mazda minivan has increased from 1996 to 2000
- A sheet that looks at how the price of options for the Dodge minivan has increased from 1996 to 2000
- A sheet that looks at how the price of options for the Plymouth minivan has increased from 1996 to 2000
- A sheet that compares the total cost comparison for the minivans
This task has been created as a step-by-step guide.
Be sure to follow the steps closely.
And another thing...
You're probably thinking to yourself: "Minivans? They are so boring".
Well, as you do this assignment, don't think of those boring minivans that you usually see.
Imagine that your comparing prices for these minivans...