This assignment is going to be completed in Excel. To begin, download the attached file and save it as Assignment $6\_$LastName,FirstName

Rename the current sheet containing the dataset to Dataset

Create a new sheet named Summary & Pivot Table

In the new sheet, use intersheet referencing to create a summary of the overall data in your Dataset sheet. To do this, use one of the following functions:

IF$,$ SUMIF, COUNTIF

Create a Pivot Table and chart using the information within your Dataset sheet

In your Dataset sheet, reformat the data using at least three of the following skills:

Conditional Formatting, Data Validation, Slicers, Flash Fill

Create a sheet named Overview, discuss the following points:

Which of the functions you chose to use in your Summary sheet, and why

Which three of the formatting options you used, and why

The elements you chose to utilize in your Pivot Table to best communicate the data

To submit, upload file in Excel format to Blackboard.

Pro tip: when choosing your formatting or function usage, be sure to make choices that better the readability and interpretation of your chosen data. Think of it this way $-$ if I were your boss, who was seeing this workbook for the first time, what would you want me to see? What do you need to fall within that five$-$second rule?