Question #$2$:

Switch to the Sales by Rep worksheet. Will created a macro to insert a chart of sales by each sales representative. From the last time he ran the macro, the worksheet displays a chart in the incorrect format $($a bar chart$).$ The chart also includes sales data for Harsia and Lewison, but not Sattinger. Will has already updated the macro to produce a column chart instead of a bar chart. Troubleshoot and edit the data range in the macro as follows:

a$.$ Assign the SalesChart macro to the button labeled Chart Sales by Rep.

b$.$ Edit the SalesChart macro by changing the selected range in the following lines of code to include the Sattinger label in cell A$8$ and sales value in cell C$8$:

Range$("$A$5$:A$7,$C$5$:C$7").$Select

and

ActiveChart.SetSourceData Source:$=$Range$($

c$.$ Save the changes, then delete the bar chart.

d$.$ Click the Chart Sales by Rep button to run the updated SalesChart macro to verify the chart includes the information for all three sales reps.

e$.$ Resize and reposition the column chart so the upper$-$left corner is in cell E$4$ and the lower$-$right corner is in cell K$18.$

Switch to the Thermostat worksheet Will has already created two scenarios in the Thermostats worksheet. Create a third scenario to examine the effects of a $10$ percent sales reduction in thermostat models as follows:

a$.$ In the Scenario Manager, add a new scenario and use Unit Sales Decrease $10\%$ as the scenario name.

b$.$ Change the units sold values in the range F$12$:H$12.$

c$.$ Use the information shown in Table $1$ below as the values for the changing cells.

Table $1$: Unit Sales Decrease $10\%$ Scenario Values $q,$

$\backslash$table$[[$Changing Cell,Value$],[$Aurora$\_$Units$\_$Sold $($F$12),19800$