Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Download the Excel workbook attached and rename it with the filename: First Name, Last Name- Week 7. Convert the list to a table. Sort values

  1. Download the Excel workbook attached and rename it with the filename: First Name, Last Name- Week 7.
  2. Convert the list to a table.
  3. Sort values from the biggest to the smallest value.
  4. Create two charts from the table. Please feel free to choose any chart type that you think would best represent the data.
  5. Title your charts "Brown's Family Expenses, Q3 2022". Try adding legends and any element you wish to add. You may also experiment with different chart designs.
  6. Save your changes.

Total July August September
Electricity & Water Bill $ 860.00 $ 250.00 $ 230.00 $ 380.00
Phone Bill $ 450.00 $ 150.00 $ 150.00 $ 150.00
Internet $ 270.00 $ 90.00 $ 90.00 $ 90.00
Gas $ 190.00 $ 60.00 $ 65.00 $ 65.00
Apartment rental $ 4,350.00 $ 1,450.00 $ 1,450.00 $ 1,450.00
Donation $ 250.00 $ 150.00 $ 50.00 $ 50.00
Car maintenance $ 300.00 $ 100.00 $ 100.00 $ 100.00
Car Repairs $ 800.00 $ 800.00 $ - $ -
Car Insurance $ 750.00 $ 250.00 $ 250.00 $ 250.00
Medical insurance $ 710.00 $ 230.00 $ 250.00 $ 230.00
Groceries $ 2,400.00 $ 1,000.00 $ 300.00 $ 1,100.00
Miscellaneaous $ 300.00 $ 125.00 $ 95.00 $ 80.00

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

Cases In Human Resource Management In Hospitality

Authors: Shirley Gilmore

1st Edition

0131119834, 9780131119833

More Books

Students also viewed these General Management questions

Question

What is a polytomous variable?

Answered: 1 week ago