1. Add a sheet which contains a pivot table showing the three species and the number of penguins in each species. Sort the table by the number of penguins in each species, with the highest shown first. (2 points) 2. Add a sheet which contains a pivot table showing average weight (body_mass_g), broken down by the species and sex. All numbers should be shown with commas (if 1,000 or over) and one digit to the right of the decimal point. (4 points) 3. Add a pivot chart to the the pivot table specified in #2. Make a clusters column chart with a cluster for species, and within the cluster, show the average weight of the males and females, but not the penguins where the sex is not recorded. (4 points)

1. Add a sheet which contains a pivot table showing the three species and the number of penguins in each species. Sort the table by the number of penguins in each species, with the highest shown first. (2 points) 2. Add a sheet which contains a pivot table showing average weight (body_mass_g), broken down by the species and sex. All numbers should be shown with commas (if 1,000 or over) and one digit to the right of the decimal point. (4 points) 3. Add a pivot chart to the the pivot table specified in \#2. Make a clusters column chart with a cluster for species, and within the cluster, show the average weight of the males and females, but not the penguins where the sex is not recorded. ( 4 points) 1. Add a sheet which contains a pivot table showing the three species and the number of penguins in each species. Sort the table by the number of penguins in each species, with the highest shown first. (2 points) 2. Add a sheet which contains a pivot table showing average weight (body_mass_g), broken down by the species and sex. All numbers should be shown with commas (if 1,000 or over) and one digit to the right of the decimal point. (4 points) 3. Add a pivot chart to the the pivot table specified in \#2. Make a clusters column chart with a cluster for species, and within the cluster, show the average weight of the males and females, but not the penguins where the sex is not recorded. ( 4 points)