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:

Direct Quotation

A report of the exact words of an author or speaker, typically enclosed in quotation marks.

Plagiarism

The act of copying someone else's work or ideas and presenting them as one's own without crediting the original source.

Summary

A brief statement or account that covers the main points of a more extensive document or presentation.

Paraphrase

The act of rewording text or speech to achieve clearer understanding, often to simplify or clarify meaning.