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:

Bean-Shaped

Descriptive term typically used to describe the shape of organs or structures, notably the kidneys.

Lymphatic Organs

Organs, including the lymph nodes, spleen, and thymus, that are part of the immune system, helping to filter pathogens and produce white blood cells.

Lymph Nodes

Small, bean-shaped structures that are part of the lymphatic system, helping the body fight infections and other diseases.

Innate Physical Barrier

Natural barriers formed by the body’s anatomy, such as the skin and mucosal surfaces, that help prevent the entry of pathogens.