USA Annual Purchases Report 2020 Customer ID Gender Education Annual Salary City New York Annual Purchases...

 

Transcribed Image Text:

USA Annual Purchases Report 2020 Customer ID Gender Education Annual Salary City New York Annual Purchases University High School University University University University High School С11 6233 7500 Instructions: 4233 4999 6560 6750 С12 M New York 1. Format the tables as given in the picture 1 С13 F Seattle (Alignment, Shading, Borders, Wrap text, Orientation etc). Format Annual Purchases and Annual Salary to dollar curency with two decimal places. 2. Calculate the Total Annual Purchases for each City (B16:B18) 3. Calculate the Average Annual Purchases for each Education (B21:B23) 4. Calculate the total number of customers from each gender (B26:B27) 5. Calculate the total annual salary for each gender in each city (E17:F19) 6. Calculate the total annual purchases for each gender in each city (E23:F25) 6 points Insert and format the charts as given below 4 points С14 M Chicago 5001 12000 3 C15 F New York 7034 17500 C16 F Chicago 5345 13150 6 С17 F Seattle 790 3799 8 240 2150 4300 22450 232 2500 С18 F Seattle None C19 Seattle University 10 C20 F New York None 11 12 13 14 City New York Annual Salary Gender City New York Total Annual Purchases Male Female 15 Chicago Total Annual Salary 16 17 Seattle Chicago 18 Seattle 30000 20000 Population 19 13150 2245999 12000 Education Average Annual Purchases 20000 12499 10000 University High school Annual Purchas Gender City New York Female 20 IMale Male Female New York Chicago Male 40% Male Female None Seattle Female 21 60% 22 Chicago New York Chicago 12000 Seattle 23 Male Female Gender Population Seattle 12499 22450 24 20000 13150 12699 Male 25 26 Female 27 A B E USA Annual Purchases Report 2011 Customer Annula Gender City Education Annual Salary ID Purchases C11 New York University 6233 7500 C12 M 4233 4999 New York High School Seattle Chicago University New York University Chicago University Seattle Seattle Seattle New York None C13 F University 6560 6750 C14 5001 12000 C15 F 7034 17500 5345 790 240 4300 232 C16 13150 High School None University C17 F 3799 C18 F 2150 C19 M 22450 C20 f 2500 Total Annual Annual Salary Gender City Purchases City New York New York Male Female Chicago Seattle Chicago Seattle Average Education Annual Purchases Annual Gender Purchases University High school Female City New York Chicago Seattle Male None Gender Population Male Female USA Annual Purchases Report 2020 Customer ID Gender Education Annual Salary City New York Annual Purchases University High School University University University University High School С11 6233 7500 Instructions: 4233 4999 6560 6750 С12 M New York 1. Format the tables as given in the picture 1 С13 F Seattle (Alignment, Shading, Borders, Wrap text, Orientation etc). Format Annual Purchases and Annual Salary to dollar curency with two decimal places. 2. Calculate the Total Annual Purchases for each City (B16:B18) 3. Calculate the Average Annual Purchases for each Education (B21:B23) 4. Calculate the total number of customers from each gender (B26:B27) 5. Calculate the total annual salary for each gender in each city (E17:F19) 6. Calculate the total annual purchases for each gender in each city (E23:F25) 6 points Insert and format the charts as given below 4 points С14 M Chicago 5001 12000 3 C15 F New York 7034 17500 C16 F Chicago 5345 13150 6 С17 F Seattle 790 3799 8 240 2150 4300 22450 232 2500 С18 F Seattle None C19 Seattle University 10 C20 F New York None 11 12 13 14 City New York Annual Salary Gender City New York Total Annual Purchases Male Female 15 Chicago Total Annual Salary 16 17 Seattle Chicago 18 Seattle 30000 20000 Population 19 13150 2245999 12000 Education Average Annual Purchases 20000 12499 10000 University High school Annual Purchas Gender City New York Female 20 IMale Male Female New York Chicago Male 40% Male Female None Seattle Female 21 60% 22 Chicago New York Chicago 12000 Seattle 23 Male Female Gender Population Seattle 12499 22450 24 20000 13150 12699 Male 25 26 Female 27 A B E USA Annual Purchases Report 2011 Customer Annula Gender City Education Annual Salary ID Purchases C11 New York University 6233 7500 C12 M 4233 4999 New York High School Seattle Chicago University New York University Chicago University Seattle Seattle Seattle New York None C13 F University 6560 6750 C14 5001 12000 C15 F 7034 17500 5345 790 240 4300 232 C16 13150 High School None University C17 F 3799 C18 F 2150 C19 M 22450 C20 f 2500 Total Annual Annual Salary Gender City Purchases City New York New York Male Female Chicago Seattle Chicago Seattle Average Education Annual Purchases Annual Gender Purchases University High school Female City New York Chicago Seattle Male None Gender Population Male Female

Answer rating: 100% (QA)

City Total Annual Purchases Annual Salary Gender Chart ... View the full answer