Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given below is a sample list of 20 products in a grocery store with the product code, the price, and the associated discount rates. Product

Given below is a sample list of 20 products in a grocery store with the product code, the price, and the associated discount rates.

Product code

Price ($)

Discount (%)

A003

4.00

5

A345

2.70

0

B985

4.50

5

C765

1.50

0

F302

3.00

5

B453

6.80

10

A109

9.50

10

F432

4.80

5

D234

5.40

10

B432

2.60

0

D765

6.90

10

A406

2.60

5

D203

5.40

10

F405

3.60

0

C432

5.20

5

C106

3.20

5

D324

1.30

0

F456

5.20

10

A156

2.50

5

B654

1.10

0

A: Display your use of the VLOOKUP function and find the price of the products A109, F432, B985, D203, C432, B654, and A345.

B: Display your use of the COUNTIF function and determine the number of products associated with each discount rate - 0%, 5%, and 10%, from the provided list.

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

Finance Operations

Authors: Charles Finley

1st Edition

1491292423, 978-1491292426

More Books

Students also viewed these Finance questions

Question

explain the need for human resource strategies in organisations

Answered: 1 week ago

Question

describe the stages involved in human resource planning

Answered: 1 week ago