5th Grade Computer Class - Excel: Car Prices

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

 

http://www.carmax.com      Zip Code - 77380