Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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:

Car type

Number of units sold

Price ()

Total ()

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: =

Car type

Price ()

Adventure

8,000

Sports

9,000

Supreme

15.000

Standard

7,000

Cruiser

12,000

Touring

11,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 in Excel to retrieve information forspecific cases from the table above. You should show how to retrieve the price and total (in ) for the Sports car.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Ethics

Authors: Iris Stuart

1st Edition

1118542401, 9781118542408

More Books

Students also viewed these Accounting questions