excel2

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: 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**. 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.
 * = **Type of SUV** ||= **Name of SUV** ||= **Lowest price** ||= **Highest price** ||
 * < **Compact SUV** ||<  ||<   ||<   ||
 * < **Midsize SUV** ||<  ||<   ||<   ||
 * < **Full-size SUV** ||<  ||<   ||<   ||
 * < **Luxury SUV** ||<  ||<   ||<   ||
 * < **Hybrid SUV** ||<  ||<   ||<   ||
 * = **Type of SUV** ||= **Name of SUV** ||= **City Mileage** ||= **Highway Mileage** ||
 * < **Compact SUV** ||<  ||<   ||<   ||
 * < **Midsize SUV** ||<  ||<   ||<   ||
 * < **Full-size SUV** ||<  ||<   ||<   ||
 * < **Luxury SUV** ||<  ||<   ||<   ||
 * < **Hybrid SUV** ||<  ||<   ||<   ||