Excel Practical 1

Creating a Cost Comparison Worksheet and Chart

Problem: You have decided to purchase a new minivan but want to compare various dealer prices to prices you found listed on the World Wide Web. You are ordering a Ford Windstar SEL with the six options (security system, engine block heater, entertainment system, front side airbags, floor console, and trailer tow package) listed in Table E2-1 below. Create a worksheet to compare prices for this vehicle with prices from the World Wide Web and three different dealers.

Instructions:

• Use the techniques learned to create a worksheet that includes the data provided in Table E2-1.
• Do not copy the Column Letters or Row numers.Just the data to EXCEL.
• Bold and center the title across cells A1:G1.
• Using a BLACK color, fill in cells F13 and G13
• Calculater the Grand Totals
• Look for the Maximum costs for each
• Look for the Minimum costs for each
• Format the numbers with appropriate formatting
• Format the table.You decide how to format it and choose the colors
• Include a 3D column chart that compares the security package and trailer tow package prices for all of the dealers
• Move the chart to a new worksheet
• Call the worksheet:Comparison Chart.
• Rename the worksheet with the table to Comparison
• Color the tab GREEN
• Adjust the document properties
• Save the workbook as Yourname_P1, where Yourname is your own name.

• Name
• Tags (minimum of 3 – deparated by commas)

Table E2-1