$6.$ With the worksheets still grouped, format cell A$1$ using the Orange, Accent $1,$ Lighter $\backslash (\backslash$mathbf$\{80\backslash \%\}\backslash )$ fill color to provide more visual interest to all five worksheets.

$7.$ With the worksheets still grouped, set a $1"$ custom margin at the Top of the worksheets to prepare for printing the data. Ungroup the worksheets.

$8.$ Kendra wants to add a hyperlink to the worksheets to make it easier to navigate. She asks you to add the first hyperlink to show her how it works. She also wants to add a hyperlink to the company website and another to her email address so people reviewing the workbook data can contact her.

Add hyperlinks to the Quarter $1$ worksheet as follows:

a$.$ On the Quarter $1$ worksheet, type Quarter $2$ in cell A$27$ to enter the text to use as a hyperlink.

b$.$ In cell A$27,$ add a hyperlink that links to cell A$1$ of the Quarter $2$ worksheet in the current workbook.

c$.$ Add a ScreenTip using Next Quarter as the ScreenTip text.

d$.$ In cell A$28,$ add a hyperlink that links the "MusicBot website" text to the www$.$musicbot.example.com website.

e$.$ In cell A$29,$ add a hyperlink that links the "Contact Kendra Liang" text to the kI@musicbot.example.com email address.

$9.$ Use the hyperlink in cell A$27$ to go to the Quarter $2$ worksheet. In cell A$3,$ remove the hyperlink, which Kendra no longer needs.

$10.$ Kendra has verified all of the Quarter $2$ revenue data except for the data in the CDs and Vinyl category. She asks you to secure the rest of the Quarter $2$ worksheet data so that no one can change it$.$

Protect the worksheet as follows:

a$.$ Unlock the CDs and Vinyl data $($range B$22$:D$25)$ so that Kendra can change it later.

b$.$ Protect the Quarter $2$ worksheet so that users can unprotect it without a password. Also allow users to select locked and unlocked cells.

$11.$ Kendra plans to print the Quarter $2$ worksheet, but wants to keep the CDs and Vinyl data separate from the Streaming, Songs, and Albums data. Insert a page break so that row $21$ prints on a new page.

$12.$ Kendra will verify the data on the Quarter $3$ worksheet by comparing it to the original data in another workbook. She wants to use a hyperlink to access the other workbook quickly.

Add a hyperlink to the Quarter $3$ worksheet as follows:

a$.$ Go to the Quarter $3$ worksheet, and then type Original data in cell A$26$ to enter the text to use as a hyperlink.

b$.$ In cell A$26,$ add a hyperlink that links to the Support$\_$EX$19\_6$a$\_$Q$3.$xlsx workbook.

$13.$ Hide the Quarter $3$ worksheet so that no one can view the unverified data.