Given Below Is a Sample List of 20 Products in a Grocery

question 48

Essay

Given below is a sample list of 20 products in a grocery store with the product code, the price, and the associated discount rates. $$\begin{array} { | c | c | c | } \hline \text { Product code } & \text { Price (\$) } & \text { Discount (\%) } \\\hline \text { A003 } & 4.00 & 5 \\\hline \text { A345 } & 2.70 & 0 \\\hline \text { B985 } & 4.50 & 5 \\\hline \text { C765 } & 1.50 & 0 \\\hline \text { F302 } & 3.00 & 5 \\\hline \text { B453 } & 6.80 & 10 \\\hline \text { A109 } & 9.50 & 10 \\\hline \text { F432 } & 4.80 & 5 \\\hline \text { D234 } & 5.40 & 10 \\\hline \text { B432 } & 2.60 & 0 \\\hline \text { D765 } & 6.90 & 10 \\\hline \text { A406 } & 2.60 & 5 \\\hline \text { D203 } & 5.40 & 10 \\\hline \text { F405 } & 3.60 & 0 \\\hline \text { C432 } & 5.20 & 5 \\\hline \text { C } 106 & 3.20 & 5 \\\hline \text { D324 } & 1.30 & 0 \\\hline \text { F456 } & 5.20 & 10 \\\hline \text { A156 } & 2.50 & 5 \\\hline \text { B } 654 & 1.10 & 0 \\\hline\end{array}$$ ​
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.​

---

Definitions:

18 Years

A legal milestone of adulthood in many countries, signifying the age at which an individual assumes adult responsibilities and rights.

Personality Disorder

A type of mental disorder characterized by unhealthy patterns of thinking, functioning, and behaving.

Inner Experience

Refers to the personal, subjective phenomena of an individual's emotional and thought processes.

Outward Behavior

Observable actions or reactions of an individual, as opposed to internal thoughts or feelings.