Exercises 1

https://bit.ly/36ZPKzO (youtube.com)

1. What are the steps of creating a chart for a set of data in Excel?

Exercise 2

Intermediate Excel Functions for Managing Data

Create tables in Excel, sort data, create charts, format data, and many more. Essentially, the goal is for you to be exposed to the different functions that quickly organize data when needed.

1. Convert the list to a table. (Excel )
2. Sort values from the biggest to the smallest value.
3. Create two charts from the table. Please feel free to choose any chart type that you think would best represent the data.
4. Title your charts "Jones Family Expenses, Q1 2022". Try adding legends and any element you wish to add. You may also experiment with different chart designs.
5. Save your changes

	Total	January	February	March
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
Miscellaneous	$ 300.00	$ 125.00	$ 95.00	$ 80.00