Module $5$: SAM Project $16$

$5.$ Edit the hyperlink in cell $B9$ as follows:

a$.$ Use Online art fair calendar as the display text.

b$.$ Use Display the calendar of art fairs in the U$.$S$.$ as the Screentip text.

$6.$ Min Jee wants to apply consistent formatting to the worksheets she collected from separate workbooks. Group the Chicago, St$.$ Louis, and Minneapolis worksheets together and then make the following formatting updates:

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

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

c$.$ Bold the values in the range $A5$:$A8.$

d$.$ Apply the Accounting number format with two decimal places and $ as the symbol to the range B$5$:F$9.$

e$.$ Resize the column width of columns B:F to $14.$ Do not ungroup the worksheets.