Introduction steps Download the attached Excel data file. Rename the file in the following way: YourFirstname_YourFamilyname.xlsx In report create 4 sheets with the following names: Problem #1, Problem #2, Problem #3, Problem#4. The results of each Problem should be placed into the corresponding sheets. Problem #1. Property Analysis (2%) Copy Property Data into Problem #1 sheet. 1. Sort the records in A-Z order using the property Type variable and simultaneously by Sq_ft variable in largest to smallest order. At the bottom of the table for each numeric column add MIN, MAX, Average values. Dont forget to add labels to identify these values. For each property type pls highlight by color three of them on top and three of them at the bottom. 2. Copy the green table into Problem#1 sheet and fill it by the help of Excel functions (not manually). 3. On the same sheet create two histograms of Price for 4 and 8 number of intervals (bins). Pay attention to label axes and chart titles. What conclusion can be done based on the above histograms? Problem #2. Decision Matrix (1%) Suppose that you are planning to take a trip and you have five different destinations to choose from. The attractiveness of each destination (in the range from 0 up to 5) were rated by special company before. Copy the Decision Matrix template into Problem #2 sheet. By the help of Excel randomly assign weights to each criterion in the range from 0.2 to 1. By the help of Excel randomly assign grades for each destination in the range from 0 to 5. Calculate scores for each destination. Explain which destination you will pick and why? Highlight by color the final answer. Problem #3. Employee Retirement & Health Plan (1%) A company contributes to employees retirement plans at the rate of 4% of the employees annual salary. To be eligible for this benefit, an employee must have full-time status with two or more years of employment. Write the Excel formula to calculate: 1) Retirement Contribution in $$ for each employee; 2) Health Plan Cost ($10K of annual coverage for employees who choose the family plan, and $8K for employee with individual plan). The best solution will be if you could use a single logical formula in each task. But theres more than one way to do this as you know. Problem #4. SWOT Analysis (1 %) Provide SWOT Analysis for any one problem from the list. At least 4 factors should be used in each table segment. Final steps Before saving results please check that all charts have titles and axes names. Save your results in one report file: YourFirstname_YourFamilyname.xlsx Submit your report to the Dropbox before the Deadline. Only in the case of Dropbox technical issues, submit your report to my Slate email.