Using the Spreadsheet Below, Give the Cell Address Which Would

question 18

Essay

Using the spreadsheet below, give the cell address which would have the formula shown. $\begin{array}{|l|l|}\hline{\text { Cell Formula }} & \text { Belongs in Cell } \\\hline=\mathrm{VLOOKUP}(\mathrm{B} 18, \$ \mathrm{~B} \$ 10: \$ \mathrm{C} \$ 12,2) & \\\hline=\mathrm{VLOOKUP}(\mathrm{D} 23, \$ \mathrm{~F} \$ 11: \$ \mathrm{G} \$ 14,2) & \\\hline=\mathrm{K} 19^{*}(\$ \mathrm{I} \$ 16-\mathrm{I} 19) & \\\hline=\mathrm{VLOOKUP}(\mathrm{H} 27, \$ \mathrm{~B} \$ 10: \$ \mathrm{C} \$ 12,2) & \\\hline=\mathrm{AVERAGE}(\mathrm{L} 18: \mathrm{L} 27) & \\\hline\end{array}$

---

Definitions:

Transaction-Based

Referring to activities, processes, or systems that are triggered by transactions or exchanges between parties.

Process-Oriented

An approach that focuses on the processes within an organization as a means to achieve efficient results and improvement.

Inventory Turnover Effect

A measure of how quickly a company can sell its stock within a given period, indicating the efficiency of inventory management and sales performance.

Return on Investment

A measure of the gain or loss generated on an investment relative to the amount of money invested.