Using Microsoft Excel - SUV Comparison


Today, you will create two charts to compare 2011 SUV mileages and prices. We will use cars.com to locate data for each spreadsheet.

1. Open Microsoft Excel.
2. Save as yourname_excelcomparison.xls
3. Set up your first Excel spreadsheet like this:
Type of SUV
Name of SUV
Lowest price
Highest price
Compact SUV



Midsize SUV



Full-size SUV



Luxury SUV



Hybrid SUV



4. Copy and paste this spreadsheet data on Sheet 2 so you have the same basic set up.
5. Change Lowest Price to City mileage. Change Highest price to Highway mileage.
Type of SUV
Name of SUV
City Mileage
Highway Mileage
Compact SUV



Midsize SUV



Full-size SUV



Luxury SUV



Hybrid SUV



Remember to SAVE OFTEN!
When finished entering all the data, create a chart on a separate page - rename the pages so you know what each page contains.