1. Create 3 lookip tablet basted on the following information: Unit Price Apple, 545; Banana, 534; Crape, 5a9, Kumquat 5150; Orange. 190 . Sales Amount Disceunt. For the sales amount un to inss than 1,600 , the discount is 0%; for the sales amount free 1,000 up to less than 5,000 , the discount is 2% : For the sales amount from 5.050 up to less than 10.000, the disceunt is 5%, for the sales anount 10,000 and up, the discount is b\%. Date Discount Mon, 10th. Tue, 5tw; Wod, Cy, The, 2\%, Fri, 20\% 7. Calculate Unie Peice uring Vhoorup function 2. Calculate Extensionigales Aenount, atich is equal te Unit Price X Guantifr. 4. Caltulate Sales Amount Discount Ameunt ving h. OOKUD function idformat cell to Currencyl 5. Calcuiate Oate Disceunt Amount uaing VLOOKUP function (tormat cell to Cutreacy? E. Caisulate Discounted Price, Which is equal to the Eutension - (Sales Ambuent Discount)-(Date Diteount Amount) 7 Caltulate Total in cells Fit to ift 6. Do Not shange the arder of the data trom At to it?. 12 13 Unit Price Vlookup \begin{tabular}{|l|l|r|} \hline 4 & Apple & 45 \\ \hline 5 & Banana & 34 \\ \hline 6 & Grape & 89 \\ \hline 7 & KumQuat & 150 \\ \hline 8 & Orange & 20 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline \multicolumn{2}{|c|}{ Sales/Extension Discount } \\ Vlookup \\ \hline=1000 to 5000 & 2% \\ \hline>=5000 to 10000 & 5% \\ \hline>=10000 & 8% \\ \hline \end{tabular} 1. Create 3 lookup tables based on the following information: Unit Price: Apple, \$45; Banana, \$34; Grape, \$89; Kumquat,\$150; Orange, \$20 Sales Amount Discount: For the sales amount up to less than 1,000, the discount is 0%; for the sales amo For the sales amount from 5,000 up to less than 10,000 , the discount is 5%; for the sales amount 10,00 Date Discount: Mon, 10\%; Tue, 5\%; Wed, 0\%; Thu, 2\%; Fri, 20\% 2. Calculate Unit Price using VLOOKUP function 3. Calculate Extension/Sales Amount, which is equal to Unit Price X Quantity 4. Calculate Sales Amount Discount Amount using VLOOKUP function ((format cell to Currency) 5. Calculate Date Discount Amount using VLOOKUP function (format cell to Currency) 6. Calculate Discounted Price, which is equal to the Extension - (Sales Amount Discount)-(Date Discount Amou 7. Calculate Total in cells F11 to 111 8. DONOT change the order of the data from A1 to 112 quat, $150; Orange, $20 s than 1,000 , the discount is 0%; for the sales amount from 1,000 up to less than 5,000 , the discount is 2%; 000 , the discount is 5%; for the sales amount 10,000 and up, the discount is 8%. 6: Fri, 20\% Price X Quantity JP function ((format cell to Currency) (format cell to Currency) ision - (Sales Amount Discount)-(Date Discount Amount) 1. Create 3 lookip tablet basted on the following information: Unit Price Apple, 545; Banana, 534; Crape, 5a9, Kumquat 5150; Orange. 190 . Sales Amount Disceunt. For the sales amount un to inss than 1,600 , the discount is 0%; for the sales amount free 1,000 up to less than 5,000 , the discount is 2% : For the sales amount from 5.050 up to less than 10.000, the disceunt is 5%, for the sales anount 10,000 and up, the discount is b\%. Date Discount Mon, 10th. Tue, 5tw; Wod, Cy, The, 2\%, Fri, 20\% 7. Calculate Unie Peice uring Vhoorup function 2. Calculate Extensionigales Aenount, atich is equal te Unit Price X Guantifr. 4. Caltulate Sales Amount Discount Ameunt ving h. OOKUD function idformat cell to Currencyl 5. Calcuiate Oate Disceunt Amount uaing VLOOKUP function (tormat cell to Cutreacy? E. Caisulate Discounted Price, Which is equal to the Eutension - (Sales Ambuent Discount)-(Date Diteount Amount) 7 Caltulate Total in cells Fit to ift 6. Do Not shange the arder of the data trom At to it?. 12 13 Unit Price Vlookup \begin{tabular}{|l|l|r|} \hline 4 & Apple & 45 \\ \hline 5 & Banana & 34 \\ \hline 6 & Grape & 89 \\ \hline 7 & KumQuat & 150 \\ \hline 8 & Orange & 20 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline \multicolumn{2}{|c|}{ Sales/Extension Discount } \\ Vlookup \\ \hline=1000 to 5000 & 2% \\ \hline>=5000 to 10000 & 5% \\ \hline>=10000 & 8% \\ \hline \end{tabular} 1. Create 3 lookup tables based on the following information: Unit Price: Apple, \$45; Banana, \$34; Grape, \$89; Kumquat,\$150; Orange, \$20 Sales Amount Discount: For the sales amount up to less than 1,000, the discount is 0%; for the sales amo For the sales amount from 5,000 up to less than 10,000 , the discount is 5%; for the sales amount 10,00 Date Discount: Mon, 10\%; Tue, 5\%; Wed, 0\%; Thu, 2\%; Fri, 20\% 2. Calculate Unit Price using VLOOKUP function 3. Calculate Extension/Sales Amount, which is equal to Unit Price X Quantity 4. Calculate Sales Amount Discount Amount using VLOOKUP function ((format cell to Currency) 5. Calculate Date Discount Amount using VLOOKUP function (format cell to Currency) 6. Calculate Discounted Price, which is equal to the Extension - (Sales Amount Discount)-(Date Discount Amou 7. Calculate Total in cells F11 to 111 8. DONOT change the order of the data from A1 to 112 quat, $150; Orange, $20 s than 1,000 , the discount is 0%; for the sales amount from 1,000 up to less than 5,000 , the discount is 2%; 000 , the discount is 5%; for the sales amount 10,000 and up, the discount is 8%. 6: Fri, 20\% Price X Quantity JP function ((format cell to Currency) (format cell to Currency) ision - (Sales Amount Discount)-(Date Discount Amount)
