Answered step by step
Verified Expert Solution
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
- 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 from the biggest to the smallest value.
- Create two charts from the table. Please feel free to choose any chart type that you think would best represent the data.
- 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.
- 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
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