A motorcycle dealer specialises in selling six types of motorcycles 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: Motorcycle type Number of units sold Price () Total () You need to use data-validation to retrieve any motorcycle (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 motorcycles (N of units) should not exceed TWO. The Total () column should be calculated using the following Excel formula: Total N of units sold Price Motorcycle type Price () Touring 6,000 Cruiser 5,000 Standard 4,000 Supreme 7,500 Sports 10,000 Adventure 7,000 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 on Excel to retrieve information for specific cases from the table above. You should show how to retrieve the price and the total (in ) for the 'Adventure' motorcycle. Note: All your screenshots and explanation should be included on a maximum of TWO