S 2: 1. Create an Excel spreadsheet to perform a series of calculations on the data shown in table below. 2. Calculate the commission and total salary. 3. Using if formula, find commission status. Commission status is High if commission earn was > $1000 else the status is Low. 4. Using vlookup formula, find salesperson's evaluation based on total sales. 5. Sort Salespersons' name in alphabetical order. 6. Calculate average total salary, highest total salary, and lowest total salary. 7. Your spreadsheet should include a graph of total sales and base salary over salesperson. . Salesperson Ahmad Ismail Ali Abbas Lee Vinesh Iman Siti Yang Umar Zain Total Base Sales Salary Commission Salary $98,000 $35,000 $24,000 $35,000 $39,000 $50,000 $56,000 $35,000 $81,000 $50,000 $17,000 $50,000 $22,000 $35,000 $35,000 $35,000 $35,000 $50,000 $72,000 $64,000 $25,000 $70,000 Commission Percentage Total Sales < $50,000 Total Sales > $50,000 SOFTWARE EXPERT SDN BHD 3% 4% Total Commission Salesp