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 ‘’Region 1’’ worksheet, perform a multi-level sort, Sort table data by ‘’Product’’ (A to Z) and then by ‘’Total Sales’’ (Largest to Smallest).
From the ‘’Graduation’’ worksheet. Move the chart to a new chart sheet named ‘’Graduation Chart.’’
You are compiling class data to present to the enrollment director at the School of Fine Art.
On the ‘’Substitutes’’ worksheet beginning at cell A1, import the data from the Substitutes text file in the Documents folder. Use the first row of the data source as headers.
On the ‘’New Policies’’ worksheet, in cells J5:J13, insert Win/Loss sparkllines to compare the January through June values.
TESTED 22 Feb 2025
