Lab 2.07B - Commissions

  • Use the Excel file below to start this lab. You will calculate sales commissions based on a sales commission percent. 

    1. You need to 'lock in' the sales commission rate as an absolute cell address (example $A$5) when using in calculations.
    2. You need to use Flash Fill to separate name into first and last name.
    3. You need to use the Table option and sort by last name.