$21$ Instructions:

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\%$; fo

For the sales amount from $5,000$ up to less than $10,000,$ the discount is $5\%$; for the sa

Date Discount: Mon, $10\%$; Tue, $5\%$; Wed, $0\%$; Thu, $2\%$; Fri, $20\%$

Calculate Unit Price using VLOOKUP function

Calculate Extension$/$Sales Amount, which is equal to Unit Price X Quantity

Calculate Sales Amount Discount Amount using VLOOKUP function $(($format cell to Currency$)$

Calculate Date Discount Amount using VLOOKUP function $($format cell to Currency$)$

Calculate Discounted Price, which is equal to the Extension $-($Sales Amount Discount$)-($Date Di

Calculate Total in cells F$11$ to $|11|$