Solved

Using the Spreadsheet Below, Provide the Steps in Using Excel

Question 21

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.  A  B  C  D  E 1 Purchase Orders 23 Supplier  Item No.  Item Cost  Quantity  Cost per Order 4 Rex Technologies 1123$8935$31155 Rex Technologies 1234$15015$22506 Rex Technologies 1345$1540$6007 Rex Technologies 1345$1520$3008 Max’s Wavetech 1345$510$509 MMax’s Wavetech 1765$27827$695010 Max’s Wavetech 1654$12018$216011 Rex Technologies 1765$5456$302412 Rex Technologies 1100$7133$234313 Rex Technologies 1100$1014$14014 Rex Technologies 1683$725$17515 IMax’s Wavetech 1683$10031$3100\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}

Correct Answer:

verifed

Verified

To find the order cost associated with t...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents