Remember
to save all work in your flash drive
· Go
to the internet and find prices for the following vehicle – In model and year
of your choice
1. Hummer
2. Avalanche
3. Acura MDX
4. Honda Element
5. Nissan
6. Infinity QX4
7. Lexus GX 470
8. Porsche Cayenne
9. Mercedes-Benz ML555
10.
BMW X5
11.
Cadillac Escalade
12.
Land Rover
13.
Toyota Sequoia
14.
Toyota Camry
15.
Smart Car
1.
Open Excel and plot in the
names of the cars and prices (10 points)
2.
Make column heading - Cars in A1 and
Prices in B1
3. Find
the minimum price, maximum price, and average price for all the cars (30 points)
4.
Make a column graph and put in a chart
title (20 points)
5.
Go to the internet and find pictures of
the cars and save in your picture folder.
6.
Convert your column graph into a
picture graph (20 points)
7.
Change page orientation to Landscape
(10 points)
8.
Go to page layout view and put your
name on the header (10 points)
Due on Tuesday Nov 18 (5A) and Thursday Nov 20 (5B). Late submission will be penalized - 10 points off for each late day
