Emphasis

Heading $1$

Heading $2$

A

Paragraph

Styles

$3$

To improve the readability of the worksheet, center the worksheets titles.

On the Sales worksheet, set the horizontal alignment for cell ranges $A1$:$H2$ to Center Acr Selection.

To allow for future formatting of the title, increase the height of row $1$ only to $30$ Hide row $3.$

In cell $H4,$ type Total

In cell A$15,$ type Total

$6$

To save time entering data, use the fill handle to copy the month cell B$4$ through G$4.$

To make the worksheet visually appealing, in cell range $B4$:$H4,$ apply the Angle Counterclockwise orientation.

$7,$ Next you want to total the services by month.

In cell range B$15$:G$15,$ enter a function to calculate the monthly totals.

$8$

In cell range $H5$:$H15,$ enter a function to calculate the total of each service offered.

$9$

Continue formatting the worksheet by completing the following:

In cell range $A4$:$H4,$ apply Heading $3$ cell style.

In cell A$1,$ apply Title cell style.

In cell A$2,$ apply Heading $4$ cell style.

$10$

To improve the readability of the worksheet numbers, in cell ranges $B5$:$H5$ and $B15$:$H15,$ apply the Accounting Number Format.

$11$

To align the numbers with the totals in cell range $B15$:$H15,$ in cell range $B6$:$H14,$ apply the Comma Style format.

$12$ In cell range B$15$:H$15,$ apply Total cell style.