1. The Excel file Firm Data shows the prices charged and different product sizes. Prepare a worksheet using VLOOKUP function that will compute the invoice to be sent to a consumer when any product type, size and order quantity are entered. 2. In the Excel file, Banking Data, apply the following data visualization tools: a. Use data bars to visualize the relative values of Median Home Value. b. Use color scales to visualize the relative values of Median Household Wealth. c. Use an icon set to show high, medium and low bank balances where high is above $30,000, low is below $10,000 and medium is anywhere in between. 3. In Purchase Orders database, conduct a Pareto Analysis of the Cost per order data. What conclusions can you reach? 4. In the Sales Transaction database, use Excel's filtering capability to extract all orders that used PayPal, all orders under $100 and all orders that were over $100 and used a credit card. 5. A manager needs to identify some information from the Purchase Order Excel file but has only order number. Modify the Excel file to use VLOOKUP function to find the item description and cost per order for the following order numbers: Aug11008, Sep11023 and Oct11020.

1. The Excel flie Firm Doto shows the prices charged and different product sizes. Prepare a worksheet using VLOOKUp function that will compute the invoice to be sent to a consumer when any product type, size and order quantity are entered. 2. In the Excel file, Banking Dato, apply the following data visualization tools: a. Use data bars to visualize the relative values of Median Home Value. b. Use color scales to visualize the relative values of Median Household Wealth. c. Use an icon set to shyw high, medium and low bank balances where high is above $30,000, low is below $10,000 and medium is anywhere in between. 3. In Purchase Orders database, conduct a Pareto Analysis of the Cost per order data. What conclusions can you reach? 4. In the Sales Transaction database, use Excel's filtering capablity to extract all orders that used Paypal, all orders under $100 and all orders that were over $100 and used a credit card. 5. A manager needs to identify some information from the Purchase Order Excel file but has only order number. Modify the Excel file to use VLOOKUP function to find the item description and cost per order for the following order numbers: Aug11008, Sep11023 and Oct11020