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

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.​