$5.$ Edit the hyperlink in cell B$10$ as follows:

a$.$ Use Narbonne Suites website as the display text.

b$.$ Use View the public$-$facing website for Narbonne Suites as the ScreenTip text.

$6.$ Edra wants to apply consistent formatting to the worksheets submitted by each of the statewide managers. Group the Idaho, Montana, and Oregon worksheets together and then make the following formatting updates:

a$.$ Change the font size in the merged range A$1$:F$1$ to $18$ point.

b$.$ Apply the $20\%-$ Accent $6$ cell style to the merged range A$2$:F$2.$

c$.$ Bold the values in the range A$6$:A$10.$

d$.$ Apply the Accounting number format with zero decimal places and $ as the symbol to the range B$6$:F$10.$

e$.$ Resize the column width of column B$-$F to $12.$ Do not ungroup the worksheets.