Excel files you will need to upload

Requirements: 1111 Open excel file: excel2016_conditionalformatting.xlsx download Click the Challenge worksheet tab in the bottom-left of the workbook. Select cells B3:J17. Let’s say you’re the teacher and want to easily see all of the grades that are below passing. Apply Conditional Formatting so it Highlights Cellscontaining values Less Than 70 with a light red fill. Now you want to see how the grades compare to each other. Under the Conditional Formatting tab, select the Icon Set called 3 Symbols (Circled). Hint: The names of the icon sets will appear when you hover over them. Open excel file: excel2016_intropivottables.xlsx download Create a PivotTable in a separate sheet. We want to answer the question What is the total amount sold in each region? To do this, select Region and Order Amount. When you’re finished, your workbook should look like this: In the Rows area, remove Region and replace it with Salesperson. Add Month to the Columns area. Change the number format of cells B5:E13 to Currency. Note: You might have to make columns C and D wider in order to see the values Open excel file: excel2016_morepivottables.xlsx download In the Rows area, remove Region and replace it with Salesperson. Insert a PivotChart, and choose the type Line with Markers. Insert a slicer for Regions. Use the slicer to only show the South and East regions. Change the PivotChart type to Stacked Column. In the PivotChart Fields pane to the right, add Month to the Legend (Series) area. Note: You can also click the PivotTable and then add Monthto the Columns area; the result will be the same. PART 13
Open excel file:excel2016_whatifanalysis.xlsx download
Click the Challenge tab in the bottom-left of the workbook.
In cell B8, create a function that calculates the average of the sales in B2:B7.
The workbook shows Dave’s monthly sales amounts for the first half of the year. If he reaches a $200,000 mid-year average, he will receive a 5% bonus. Use Goal Seek to find how much he needs to sell in June in order to make the $200,000 average Open excel file:excel2016_whatifanalysis.xlsx download Click the Challenge tab in the bottom-left of the workbook. In cell B8, create a function that calculates the average of the sales in B2:B7. The workbook shows Dave’s monthly sales amounts for the first half of the year. If he reaches a $200,000 mid-year average, he will receive a 5% bonus. Use Goal Seek to find how much he needs to sell in June in order to make the $200,000 average Open excel file:excel2016_whatifanalysis.xlsx download
Click the Challenge tab in the bottom-left of the workbook.
In cell B8, create a function that calculates the average of the sales in B2:B7.
The workbook shows Dave’s monthly sales amounts for the first half of the year. If he reaches a $200,000 mid-year average, he will receive a 5% bonus. Use Goal Seek to find how much he needs to sell in June in order to make the $200,000 average