Answered step by step
Verified Expert Solution
Link Copied!

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 image text in transcribed
image text in transcribed
**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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Structured Edp Auditing

Authors: Gabriel Rothberg

1st Edition

0534979319, 978-0534979317

More Books

Students also viewed these Accounting questions