Task 1

A car dealer specialises in selling six types of cars named simply as "Touring',

"Cruiser", "Standard", "Supreme", "Sports and Adventure. The shop wants

you to create an Excel sales table consisting of the following entries:

You need to use data-validation to retrieve any car (and its price) as a list for

the cell presented in the shaded region above. The price () should be

retrieved from the following table using an XLOOKUP formula. The number

of cars (N° of units) should not exceed THREE. The Total (£) column should

be calculated using the following Excel formula:

Total = N° of units sold × Price

Required:

Demonstrate the use of Excel data validation by producing some useful

screenshots. Include formulae to show your understanding of how to use the

data validation facility in Excel to retrieve information for specific cases from

the table above. You should show how to retrieve the price and total (in £)

for the 'Sports' car.