1) Put an X to mark the appropriate cells to show that everyone in Sales attended Part 2

2) Highlight the cells and fill the cells with Red containing the names of the individuals in Claims that did not attend Part 3

3) Format Column H to be 'Currency' with 2 decimal places. Be sure it includes the $ automatically.

4) Each individual must pay $25 for each session they attended. Using a formula of your choice, fill Column H with the total owed for sessions attended, subtracting anything already paid. You may choose to add a header. (Hint: IF or COUNTIF are two possible choices)

5) Sort the entire file (except the headers) A-Z by Last name

6) Add a filter to all Columns, but do not filter the file

7) Bold 'Total Paid'

8) 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.

Leadership Training 6-Part Series INSURANCE GROUP DepartmentSalesSalesClaimsAccountingAccountingSalesClaimsMarketingAccountingHRHRSalesClaimsClaimsFirstNameBobHeidiJosieWendyLorettaWalterMistyMatildaElizabethAlvinBrianMeganMariaMichealLastNameCarverLeeGatesCrockerJohnsonRiveraWhitfieldLewisHicksRiosGainesBosworthMenziesRussellPart1XXXXXXXXXXXPart2XXXXPart3XXXXXTotalPaidTotalOwed$50.00$50.00$75.00$20.00$20.00$20.00$50.00$25.00