 a Pivot table named as Low-Pricing-Items in which contains Item description(co

 a Pivot table named as Low-Pricing-Items in which contains Item description(column label), Vendor Names (row lable) and Minimum Item Cost.  For each item, identify the supplier who provides the lowest price for the item. The above Objects of your answers for Q1-Q3 should be included in your Business Software Assignment 1 EXCEL file. Your answer for Q4—a summary of Q1-3–can be posted on a separate worksheet of the same EXCEL file of Q1-3.