Using the Spreadsheet Below, Provide the Steps in Using Excel

question 30

Essay

Using the spreadsheet below, provide the steps in using Excel formulas in finding the cost of the first order for Item number 1345, and the total cost of all Item numbers 1345, using the Match and Index functions in Excel. Column B is sorted by item number in ascending order. $\begin{array}{|l|l|l|l|l|l|}\hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } \\\hline 1 & \text { Purchase Orders } & & & & \\\hline2\\\hline 3 & \text { Supplier } & \text { Item No. } & \text { Item Cost } & \text { Quantity } & \text { Cost per Order } \\\hline 4 & \text { Rex Technologies } & 1123 & \$ 89 & 35 & \$ 3115 \\\hline 5 & \text { Rex Technologies } & 1234 & \$ 150 & 15 & \$ 2250 \\\hline 6 & \text { Rex Technologies } & 1345 & \$ 15 & 40 & \$ 600 \\\hline 7 & \text { Rex Technologies } & 1345 & \$ 15 & 20 & \$ 300 \\\hline 8 & \text { Max's Wavetech } & 1345 & \$ 5 & 10 & \$ 50 \\\hline 9 & \text { MMax's Wavetech } & 1765 & \$ 278 & 27 & \$ 6950 \\\hline 10 & \text { Max's Wavetech } & 1654 & \$ 120 & 18 & \$ 2160 \\\hline 11 & \text { Rex Technologies } & 1765 & \$ 54 & 56 & \$ 3024 \\\hline 12 & \text { Rex Technologies } & 1100 & \$ 71 & 33 & \$ 2343 \\\hline 13 & \text { Rex Technologies } & 1100 & \$ 10 & 14 & \$ 140 \\\hline 14 & \text { Rex Technologies } & 1683 & \$ 7 & 25 & \$ 175 \\\hline 15 & \text { IMax's Wavetech } & 1683 & \$ 100 & 31 & \$ 3100 \\\hline\end{array}$

---

Definitions:

Cost

The value or price associated with acquiring, producing, or maintaining goods or services.

Absenteeism

The habitual non-presence of an employee at their job, which can be due to various reasons such as illness, personal issues, or lack of job satisfaction, negatively impacting productivity.

Performance Reviews

Formal assessments where an employee's work performance is evaluated and discussed to identify strengths and areas for improvement.

Strong Points

Distinguished abilities or attributes that give an individual or organization a competitive advantage.