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.
You are compiling data about courses at Bellows College.
On the ‘’Last Semester’’ worksheet configure A3:F3 to automatically wrap the text.
On the ‘’Next Semester’’ worksheet, create a Clustered Column chart that displays the ‘’Program’’ names and the ‘’Average Cost per student’’ data. Place the chart to the right of the table. The exact size and position of the chart do not matter.
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 ‘’Instructional Hours’’ worksheet, adjust the width of columns B,G to exactly 12.
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 ‘’New Policies’’ worksheet, in the ‘’Inactive Months column, use a function to count the number of months with no new policies, by Agent.
At NOD Publishers, you are preparing a workbook for the company’s annual review.
On the ‘’Summary worksheet, from the existing text in cell A2, insert a hyperlink to ‘’http://www:nodpublishers.com with a ScreenTip that displays ‘’Company Website’’.
On the ‘’Sales’’ worksheet, in the ‘City Code’’ column, modify the formula to display the letters in unpercase.