On the ‘’Classes’’ worksheet, convert the table to a cell rang. Keep the formatting.
On the ‘’Instructional Hours’’ worksheet, modify the chart to display ‘’Hours’’ as the Primary Vertical Axis Title.
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.
On the ‘’Last Semester’’ worksheet, remove the table row that contains ‘’ Agriculture’’ data. Do not change outside the table.
On the ‘’Summary’ worksheet, in cell B15, use a function to display the highest sales amount from the ‘’Total Sales’’ column.
You are revising a sales summary report for Northwind Traders.
On the ‘’Summary’’ worksheet, in cells F4:F11, use conditional formatting to apply the Yellow Fill with Dark Yellow Text format to cells that contain values greater than ‘’$5,000,000.’’
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 ‘’Contact’’ worksheet, in the ‘’Email Address’’ column, use a functional to construct email addresses for each person using the first name and ‘’@humongousinsurance.com,’’
On the ‘’Authors’’ worksheet, in the ‘’Bonus’’ column, use a function to display ‘’500’’ if the ; Books Sold’ is greater than 10,000. Otherwise, display ‘’100’’.
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’’.
