Manage Data Cells and Ranges

Remove the conditional formatting from the Stock column and table on the Stock Count worksheet.

On the Stock Count worksheet, remove the hyperlink functionality but leave the text in cell C27.

Import OrganicVege.txt located in the Exam Tutorial 2 folder as a table on a new worksheet.

Apply the cell style Light Blue, 20% – Accent 2 to cell A8.

Navigate to the named cell range AppsHeading2 and delete only the contents, leaving the empty cells.

Rename Table1 to Rates.

Clear the formatting in cell range A4:D4 on the Rental Rates worksheet.