On the ‘’Revenue’’ worksheet, convert cells A3:B7 to a table with headers. Apply the Green, Table Style Light 14 style.
On the ‘’Enrollment Summary’’ worksheet, apply the Style 7 chart and the Monochromatic Palette 6 color to the chart.
On the ‘’New Policies’’ worksheet, change the elements displayed on the chart by changing the chart layout to Layout 3.
You are analyzing insurance sales data for the first six months of the year.
On the ‘’New Policies’’ worksheet change the horizontal alignment of the ‘’Agent’’ names to Left (Indent). Set the indent to 1.
On the ‘Comparison’ chart sheet, swap the data the axis.
On the ‘’Projections’ worksheet, in the ‘’Quarter2’’ column, enter a formula that multiples the value in the Quarter 1’’ column by the ‘Q2_increase’ named range. Use the range name in the formula instead of a cell reference or value.
On the ‘Historical Sales’’ Worksheet display the formulas instead of the values.
On the ‘’Sales’’ worksheet, in the ‘City Code’’ column, modify the formula to display the letters in unpercase.
On the ‘’Classes’’ worksheet, convert the table to a cell rang. Keep the formatting.
From the ‘’Graduation’’ worksheet. Move the chart to a new chart sheet named ‘’Graduation Chart.’’
TESTED 15 Oct 2025