You are asked to prepare an Excel dashboard to present the results of a Salary Survey about Excel users. The management has asked for the following analyses with Excel PivotChart reports: Average Salary by Country, and Average Salary by Job Type The management also want the ability to drill down the analysis by Country, and Job Type (using Slicers.) You can use any combination type of PivotCharts for the dashboard but make sure that your dashboard is easy to read, easy to use, and fits in one screen. (In total we have 2 PivotChart reports and 2 Slicers.) Format average salary to the nearst thousand with K, e.g., $133 K for $132,588. Please create a dashboard on a new worksheet and label it ""Salary Dashboard"". You can add as many worksheets to the end as you like for the intermediate steps but have the ""Salary Dashboard"" worksheet right by the ""Salary Analysis"" worksheet." Salary in USD Job Type Country $132,588 Accountant Australia $79,553 Accountant Australia $81,593 Accountant Australia $71,394 Accountant Australia $127,489 Accountant Australia $64,254 Accountant Australia $95,000 Analyst Australia $22,438 Analyst Australia $101,991 Analyst Australia $173,385 Analyst Australia $96,891 Analyst Australia $66,294 Analyst Australia $96,891 Analyst Australia $96,891 Analyst Australia $131,770 Accountant Canada $245,840 Analyst Canada $64,902 Analyst Canada $34,418 Analyst Canada $63,918 Analyst Canada $52,118 Analyst Canada $50,438 Analyst Canada $83,000 Analyst Canada $49,168 Analyst Canada $72,769 Analyst Canada $78,669 Analyst Canada $49,168 Analyst Canada $35,401 Analyst Canada $63,520 Analyst Germany $83,846 Analyst Germany $50,816 Analyst Germany $53,357 Consultant Germany $90,198 Consultant Germany $53,357 Consultant Germany $3,562 Accountant India $3,205 Accountant India $12,822 Accountant India $10,685 Accountant India $3,205 Accountant India $4,274 Accountant India $2,137 Accountant India $3,651 Accountant India $40,068 Accountant India $20,515 Accountant India $126,094 Accountant UK $47,285 Accountant UK $59,107 Accountant UK $67,776 Accountant UK $19,000 Accountant UK $53,590 Accountant UK $53,590 Accountant UK $45,709 Accountant UK $39,404 Accountant UK $53,590 Accountant UK $39,404 Accountant UK $55,954 Accountant UK $45,000 Accountant USA $30,232 Accountant USA $85,000 Accountant USA $45,000 Accountant USA $40,000 Accountant USA $56,000 Accountant USA $63,000 Accountant USA $107,000 Accountant USA $140,000 Accountant USA $50,000 Accountant USA $64,300 Accountant USA $38,000 Accountant USA