Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started