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

Understand the application of Excel's conditional formatting and style commands.

Comprehend the management and organization of Excel worksheets and cells.

Learn to effectively use the spell check and ignore functions in Excel.

Master the techniques for managing and manipulating worksheet columns and rows.

---

Definitions:

Conversion Cost

The combined costs of direct labor and manufacturing overheads that are incurred to convert raw materials into finished goods.

Production Process

The sequence of operations or activities involved in converting raw materials and components into finished goods or services.

Process Costing

A costing method used for homogeneous products that are produced in a continuous process, allocating costs over the entire production run.

Cost Of Goods Sold

The direct costs attributable to the production of the goods sold by a company, including materials and labor.