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 ‘’Region 1’’ worksheet, perform a multi-level sort, Sort table data by ‘’Product’’ (A to Z) and then by ‘’Total Sales’’ (Largest to Smallest).
On the ‘’New Policies’’ worksheet, in the ‘’Inactive Months column, use a function to count the number of months with no new policies, by Agent.
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 ‘’Enrollment’’ worksheet, in cells G5:G25, insert Column sparkliness to compare the last, current, and next term values for each class period.
On the ‘’Instructional Hours’’ worksheet, modify the chart to display ‘’Hours’’ as the Primary Vertical Axis Title.
On the ‘’Summary’’ worksheet, expand the chart to include the ‘’Current Year’ data.
On the ‘’Sales’’ worksheet, in the ‘City Code’’ column, modify the formula to display the letters in unpercase.
On the ‘Enrolment Summary’’ worksheet, name the range A3:B7 ‘’Enrollment’’,
On the ‘’Enrollment Summary’’ worksheet, apply the Style 7 chart and the Monochromatic Palette 6 color to the chart.
