Excel is a tool that can be used to do everything from simple calculations like adding, subtracting, multiplying, and dividing to complex statistical calculations and data visualizations. Throughout the course, you will complete $6$ assignments that will allow you to learn some of basic Excel techniques.

Assignment $6$ is designed to give you an understanding of how to create some basic charts in Excel.

The instructions can be found in the file Excel Assignment $6-$ Instructions.docx Download Excel Assignment $6-$ Instructions.docx and are also shown below.

The steps to complete this assignment are below.

Watch the video entitled $$Excel Assignment $6$ Demo $$ Charts $($Data Visualization$)$ in Excel$.$ The video uses the full data file but different data columns to demonstrate the techniques needed to complete the assignment.

Open the demo file called $$Excel Assignment $6$ Demo.xlsx Download Excel Assignment $6$ Demo.xlsx$.$ This is the file used in the demo video. You can review the completed charts in the demo file to help with the assignment.

Open the assignment file called $$Excel Assignment $6.$xlsx Download Excel Assignment $6.$xlsx$$ and do the following:

Create a PivotTable and column chart combination for the variable Work Location and label the chart appropriately.

Create a histogram chart for the variable Age and label the chart appropriately. Move the chart to a new sheet with the name $$Histogram $$ Age$.$ You should be able to see low and high outliers in chart.

Submit your finished spreadsheet assignment in Canvas.