IS 300 Management Information Systems – Homework 5 on Excel Lesson 4

IS 300 Management Information Systems – Homework 5 on Excel Lesson 4 for Fall 2021

Learning Objectives:

Create Excel Microsoft Excel charts

Determine the appropriate chart to visualize different types of data

Dashboards

Column and Bar charts

Alternative Column charts

Line charts

Pie Charts

Area Chart

Other types

Note: For this homework you will use the excel student file called: Fall 2021 Homework 5 on Excel Lesson 4 for Student -add your name.xlsx

Use the worksheet Education Census in your student file. Create a Column Chart that looks at Marital Status for those with an Advanced Degree. Add horizontal, vertical and heading titles. Hint: Select the column of: Advanced Degree. Move the Graph below the data on the same sheet.

Create a Column Chart with the Education Census data. Add a heading title and vertical title. Select the Bachelor’s Degree data. Add the data table for the series below. Move the Graph below the data on the sheet.

Create a Pie chart for the Education Census data: Use Bachelors Degree. See below:

Use the worksheet Employment Data in your student file. Create a clustered column chart. For: All Employees, Men and Women. Do not select the column for total employment. Edit the series name to display All Employees, Men and Women. Use chart Design Style 7, to create the gridlines shown below. Add a Heading, vertical and horizontal titles. See Below.

Use the worksheet Employment Data in your student file. Create a clustered chart as question 3 and add formatting and a data table, see below. Format as follows:

Use the worksheet EXPORT in the Excel student File. Create a line chart for the US Exports to China and the US Imports from China. Add heading, horizontal and vertical titles.

Use the worksheet EXPORT in the Excel student File. Create a Clustered Columns chart for the US Imports from China. Add heading, and vertical titles. Add a Trend line.

Use the worksheet EXPORT in the Excel student File. Create a Stacked Area Chart for the US Exports to China and the US Imports from China. Add heading, horizontal and vertical titles. Display as a stacked area chart.

Create a pie chart the data found in Stocks. Format as follows: