Npithia.files.wordpress.com



Task1 - Week 7 A.L.MOTORS

A.L.Motors, based in Mid Wales, is part of a large company specialising in the sale of performance cars. The manager of A.L.Motors uses a spreadsheet to calculate sales, manage data and to aid administration.

The spreadsheets main function is to perform various calculations regarding sales data. For example, the manager may wish to know how many Toyota MR2s have been sold as a percentage of the total quarterly sales?

Additional calculations will need to show where a car is to be displayed, in the showroom or on the forecourt, dependant on how many have sold.

The manager of "A.L. Motors" is due to present the quarterly sales figures at the regional staff meeting.

1. The following information must be entered onto the spreadsheet.

2. From the spreadsheet the manager will be able to calculate totals, averages, and percentages.

Units sold monthly from October – December 2005

Toyota MR2 sold 140, 20, 110, Aston Martin sold Virage – 19, 19, 18, Porsché 911 Turbo sold 35, 33, 21, Jaguar XJS sold 60, 68, 72, Rover MGF sold 93, 130, 113, and TVR Griffith sold 79, 88, 74.

TASKS

1. Build a worksheet using the information shown above.

2. Name your worksheet Cars Sold.

3. Use the AutoSum button to sum the total units sold for October.

4. Use AutoFill to calculate the total units sold for November and December.

5. Use AutoSum to calculate the total units sold for the Toyota MR2 from October to December.

6. Use AutoFill to sum the total units sold for the remaining cars.

7. Highlight the label A.L. Motors and click the Merge and Center button.

8. Use the paste function button to calculate the average units sold for the Toyota MR2 from October to December.

9. Use the AutoFill feature to copy the formula down to calculate the averages for each of the other makes of cars.

10. Using absolute cell referencing, try to calculate what the total number of cars sold is as a percentage of the grand total.

11. If a particular model is selling well more than 50, then A.L. Motors will display the car inside the showroom. However, if the car is selling below target, that is less than 50 then it will be displayed on the forecourt.

Use the IF function to show which cars are to be displayed in the showroom and which are to be displayed on the forecourt.

If the average units sold is greater than 50 the car is displayed in the showroom.

If the average units sold is less than 50 the car is displayed on the forecourt.

12. Save your work, using your full name as a filename in your personal filespace.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download