please help with the formulas Create new Sheet and save with name AssignmentNo$2.$

Create the worksheet shown above.

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.

Enter the formula to find TOTAL SALARY for the first employee where:

TOTAL SALARY $=$ SALARY $+$ COMMISSION

Copy the formula to the remaining employees.

Enter the formula to find TOTALS, AVERAGE, HIGHEST, LOWEST, and COUNT values.

Copy the formula to each column.

Format numeric data to include commas and two decimal places.

Align all column title labels horizontally and vertically at the center.

Create a header with your name on the left, your page number in the center, and your I.D$.$ number

on the right.

Create a footer with DATE on the left and TIME on the right.

Save file.