Olivia Clausen is a product analyst for Media Hub, a website that sells audio books, movies, TV shows, and other medla around the world. Olivia is tracking sales for the year and asks for your help in projecting future sales and visualizing the sales data.

The United States, Canada, and Australla worksheets have the same structure and contain similar data. Group the United States, Canada, and Australla worksheets to make changes to the three worksheets at the same time. The first change is to display today's date.

In $($Ay H$1$ of the United States worksheet, enter a formula using the TODAY function to display today's date.

Find the text "Science fantasy" and then change it to Science fiction to use the more common term.

Use the month name in cell H$5$ to fill the range $15$:$05$ with the names of the remaining months in the year.

Olivia wants to use the cell formatting in merged cell H$6$ in other places in the workbook. Create and apply a cell style as follows:

a$.$ Create a cell style named Subhead based on the formatting in merged cell H$6.$

b$.$ Apply the new Subhead cell style to cell $H8.$

Olivia thinks Media Hub has a good chance of increasing the number of audio book downloads in the United States to $14,000$ in December. For May, she estimates $11,432$ downloads, which is the average number of monthly downloads from January to April.

Project the number of downloads in June to November by filling the series for the first projection $($range $H7$:$07$ with a linear trend.

ashman Excel $365/2021|$ Module $5$:SAM Project la

$5.$ Olivia also wants to know how the number of downloads would increase if customers downloaded $3\%$ more audio books each month from June to December.

Project the number of downloads in June to December for the second projection $($range H$9$:$09)$ based on a growth series using $1\mathrm{.}03$ as the step value.

$7.$ Olivia wants to consolidate the sales data in the United States, Canada, and Australia on the All Locations worksheet.