Objectives: Working with Sum IF and Count IF statements. Inserting Charts. USA Annual Purchases Report 2011 Annual salary CHI CH2 New Yor w York School 36213 54 M Chicae SIRENE + 52.300 16 Tort City Purchases 21 22 24 25 Sender 25 Mate Population 1. Open a new workbook and create the above worksheet and save it with the name "Exercice 4". 2. Make sure that your worksheet looks like the picture (Alignment, Shedding, Borders, Wrap text, Orientation ...). 3. Find the entire customer IDs. 4. Format Colum E & D to Currency with dollar sign and two decimal places. 5. Find the Total Annual Purchases for each City. 6. Find the Average Annual Purchases for each Education. 7. Find the total number of customers from each gender. 8. Find the total annual salary for each gender in each city. 9. Create the following Chart: Annual Phurchases Population Male female YATA1 COTTOTI Anual Purchases Vs. Annual Salary $30,000 $25,000 $20,000 $15,000 $10,000 will..I. $5,000 SO C11 CIB C19 20 Annual Purchases Annual Salary Objectives: Working with Sum IF and Count IF statements. Inserting Charts. USA Annual Purchases Report 2011 Annual salary CHI CH2 New Yor w York School 36213 54 M Chicae SIRENE + 52.300 16 Tort City Purchases 21 22 24 25 Sender 25 Mate Population 1. Open a new workbook and create the above worksheet and save it with the name "Exercice 4". 2. Make sure that your worksheet looks like the picture (Alignment, Shedding, Borders, Wrap text, Orientation ...). 3. Find the entire customer IDs. 4. Format Colum E & D to Currency with dollar sign and two decimal places. 5. Find the Total Annual Purchases for each City. 6. Find the Average Annual Purchases for each Education. 7. Find the total number of customers from each gender. 8. Find the total annual salary for each gender in each city. 9. Create the following Chart: Annual Phurchases Population Male female YATA1 COTTOTI Anual Purchases Vs. Annual Salary $30,000 $25,000 $20,000 $15,000 $10,000 will..I. $5,000 SO C11 CIB C19 20 Annual Purchases Annual Salary