Grader $-$ Instructions

Excel $2022$ Project

YO$22\_$Excel$\_$Ch$13\_$Assessment$\_$Visualize$\_$the$\_$Paper$\_$Mill's$\_$Data

Project Description:

The Paper Mill is a mid$-$sized business that specializes in selling printer paper to small U$.$S$.$ businesses at a discount. You have been asked to create a report that uses visualizations to illustrate how the business is doing from a few different perspectives. You will create a column chart, line chart, and a map visualization based on the sales data provided.

Steps to Perform:

$\backslash$table$[[$Step$,$Instructions,$\backslash$table$[[$Points$],[$Possible$]]],[1,\backslash$table$[[$Start Excel. Open the downloaded file named Excel$\_$CH$13\_$PS$2\_$PaperSales xlax. Grader has$],[$automatically added your last name to the beginning of the filename. Save the file to the$],[$location where you are storing your files.$]],0],[2,\backslash$table$[[$On the Sales worksheet, with cell A$1$ selected, display the Power Pivot tab, and then in the$],[$Tables group, click or press Add to Data Model.$]],14],[3,\backslash$table$[[$Close the Power Pivot for Excel window. Display the SalesReport worksheet. Type Paper Mill$],[$Sales Report in cell A$1,$ changing the font to $18pt$ and bold.$]],4],[4,\backslash$table$[[$Insert a PivotChart into the worksheet using the workbook's Data Model as the source. Move$],[$the PivotChart so that the upper$-$left corner of the chart is in cell B$2$ and the lower$-$right comer$],[$of the PivotChart is in I$16.]],8],[5,\backslash$table$[[$Add $2024$ Sales as the Value and Month Order as the Axis. Ensure the chart is a Clustered$],[$Column chart. If necessary, remove the legend. Add the chart fitle $2024$ Sales by Month to$],[$the PivotChart.$]],12],[6,\backslash$table$[[$Insert a second PivotChart into the worksheet using the workbook's Data Model as the$],[$source$.$ Move the PivotChart so that the upper$-$left comer of the chart is in cell J$2$ and the$],[$lower$-$right corner of the PivotChart is in Q$16.]],8],[7,\backslash$table$[[$Add $2024$ Sales as the Value and Month Order as the Axis. Add Region as the Legend.$],[$Change the chart type to a Line with Markers chart. Add the chart fitle $2024$ Sales by Region$],[$to the PivotChart.$]],18],[8,\backslash$table$[[$Insert a PivotTable into cell C$21$ on the worksheet using the workbook's Data Model as the$],[$source$.$ Add State as the Row and $2024$ Sales for the Values. Remove the Grand Totals for$],[$both Rows and Columns.$]],8],[9,\backslash$table$[[$Insert a slicer for Month Order. Move the Slicer so that the upper$-$left comer is in cell J$21$ and$],[$the lower$-$right corner of the Slicer is in L$40.]],8],[10,\backslash$table$[[$Convert the Pivot Table to Formulas. Insert a Filled Map Chart using the converted PivotTable.$],[$Type $2024$ Sales by State as the chart title. Move the Chart so that the upper$-$left corner of$],[$the chart is in cell C$21$ and the lower$-$right corner of the chart is in $135.]],12],[11,$Hide the Gridlines and Headings on the worksheet.,$8],[12,$Save and close Excel$\_$CH$13\_$PS$2\_$PaperSales. Exit Excel. Submit the file as directed.,$0],[$Total Points,$100]]$

Created On: $08/24/2022$

$1$YO$22\_$Excel$\_$CH$13\_$Assessment$\_$Atemate $-$ Visualize the Paper Mills

Data $1\mathrm{.}1$