Lab 2.07B - Commissions
-
Use the Excel file below to start this lab. You will calculate sales commissions based on a sales commission percent.NOTE:
- You need to 'lock in' the sales commission rate as an absolute cell address (example $A$5) when using in calculations.
- You need to use Flash Fill to separate name into first and last name.
- You need to use the Table option and sort by last name.