Create data tables to analyze the results of the sales team on an individual basis. Create a gender analysis table. Utilize the IF, MAX, SUM IF, and COUNT IF Functions.

Name Commissions Bonus Total Gender Analysis Total Ave. Bjorg Declerk Gomez Jones Lu Romanov Smith Urubu Watanabe Men Women (f) (m) (f) (m) (f) (m) (f) (m) (f) $ $ $ $ $ 1,567 2,364 1,005 2,521 831 1,496 2,210 2,056 $ $ 2,850 $ 100 Bonus for all salespeople earning $2,000 or more in commissions