Put an X to mark the appropriate cells to show that everyone in Sales and HR attended Part 2
Highlight the cells and fill the cells with Red containing the names of the individuals in Claims that did not attend Part 3
Format Column J to be ‘Currency’ with 2 decimal places. Be sure it includes the $ automatically.
Each individual must pay $25 for each session they attended. Using a formula, fill Column H with the total owed for sessions attended, subtracting anything already paid.
Sort the entire file (except the headers) A-Z by Last name
Add a filter to all Columns, but do not filter the file
Bold ‘Total Paid’
Add conditional formatting to the Total Owed cell for anyone who owes more than $25 for the conference. Have the cell turn red if the total owed is more than $25.
Change the last name ‘Crocker’ to your professor’s last name
