Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started