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 ''Prices'' worksheet, in the ''Tax column, enter a formula that multiples the value in the ''Unit Price'' column by cell L2.
On the ''New Policies'' worksheet, change the elements displayed on the chart by changing the chart layout to Layout 3.
On the ''New Policies'' worksheet, add a Total Row to the table. Configure the Total Row to display the number of new policies for each month and for the 6-month total.
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.