Question: explain steps and answer on excel worksheet please **open picture to see question at the bottom** 36. A college graduate who is living in Cincinnati

36. A college graduate who is living in Cincinnati expects to earn an annual salary of $55,000. The Excel file Cost of Living Adjustments shows the comparative salaries in other cities and percentage adjustments for living expenses. Develop an Excel template that allows the user to enter current annual expenses (in Cincinnati) for groceries, housing, utilities, transportation, and health care and compute the corresponding expenses for any selected city and the net salary surplus for both Cincinnati and the selected city. An example of what the output should look like is provided next: Cincinnati Atlanta $60,482.00 $55,000.00 Salary Annual Expenses Groceries Housing Utilities Transportation Healthcare Total Salary Surplus $7,800.00 $14,400.00 $3,000.00 $1,020.00 $4,200.00 $30,420.00 $24,580.00 $8,970.00 $18,000.00 $2,700.00 $1,081.20 $4,410.00 $35,161.20 $25,320.80 39. Use Pivot Tables to find the number of sales transac- tions by product and region, total amount of revenue by region, and total amount of revenue by region and product in the Sales Transactions database
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
