ent Drow Design Layout References Mailings Review View Help Excel Exercise 6. Find the Avenue Annual Purchases for each Education 7. Find the total number of customers from each gender 8. Pod the tool annual salary for each pender in each city. 9. Create the following Chart Obte . Working with Sua IT, Count IF andare Stats Inserting Charts Annual Phurchases USA Annual Purchases Report 2011 Population Cad Amy Enter your search term ICI 4 51 M M More York School HU 5433 MO . 17011 Male Orca 2.000 Female T OT 32 10 . M 1720 14 12 Dette 1. Total Annual Purchases 12 13 14 Anary dhe DE M Puth Gender Anual Purchases Vs. Annual Salary Female Purth City Mile how York 17 Chic P 1 2 Wale 7 1. Open a new workbook and create the above worlasheet. 1. Make sure that your worksheet looks like the picture Alignment Shedding Borders. Wrap het. Orientation...) 3. Fund the cutie cutomer 4. Format ColumE&D to Currency with dollar in and two decimal places Find the Total Annual Purchases for each City Accessibility Initigate room a ere to search a 23 34"F ent Drow Design Layout References Mailings Review View Help Excel Exercise 6. Find the Avenue Annual Purchases for each Education 7. Find the total number of customers from each gender 8. Pod the tool annual salary for each pender in each city. 9. Create the following Chart Obte . Working with Sua IT, Count IF andare Stats Inserting Charts Annual Phurchases USA Annual Purchases Report 2011 Population Cad Amy Enter your search term ICI 4 51 M M More York School HU 5433 MO . 17011 Male Orca 2.000 Female T OT 32 10 . M 1720 14 12 Dette 1. Total Annual Purchases 12 13 14 Anary dhe DE M Puth Gender Anual Purchases Vs. Annual Salary Female Purth City Mile how York 17 Chic P 1 2 Wale 7 1. Open a new workbook and create the above worlasheet. 1. Make sure that your worksheet looks like the picture Alignment Shedding Borders. Wrap het. Orientation...) 3. Fund the cutie cutomer 4. Format ColumE&D to Currency with dollar in and two decimal places Find the Total Annual Purchases for each City Accessibility Initigate room a ere to search a 23 34"F