D 1 Panda EST Monthly Sales Report - July Salary Total Salary 2 3 4 Emp. No. Name 5 S101 Ahmed 6 S105 Hassan 7 S112 Ali 8 S107 Waleed 9 5110 Mohammed 10 S103 11 12 Totals 13 Average Highest 15 Lowest 16 Count Sales Amount Comission 1600 25002 1800 3000 1500 2200 2000 4500 1700 3500 1600 2500 Samir 2 ? ? ? ? ? ? ? ? ? ? ? ? 2 2 2 1. Create the worksheet shown above. 2. Set the column widths as follows: Column A: 8, Column B: 14, Columns C & D: 15, Columns E & F: 14. 3. Enter the formula to find COMMISSION for the first employee. The commission rate is 2% of sales, COMMISSION = SALES * 2% Copy the formula to the remaining employees. 4. Enter the formula to find TOTAL SALARY for the first employee where: TOTAL SALARY = SALARY+ COMMISSION. Copy the formula to the remaining employees. 5. Enter formula to find TOTALS, AVERAGE, HIGHEST, LOWEST, and COUNT values. Copy the formula to each column. 6. Format numeric data to include commas and two decimal places. 7. Align all column title labels horizontally and vertically at the center 10. Save the file with name Exercise 2