Select the Data sheet tab and copy cells A$1$:A$2.$ Paste them in cell A$1$ on the PivotTable sheet.

Select Align Left for cells A$1$:A$2$ and $16$ pt$.$ as the font size. Edit the label in cell A$2$ to display Contract

Amounts, September through December $($Figure $4-104).$

Figure $4-104$ Completed PivotTable

Copy the Data sheet to the end and name the copy Subtotals.

Select cell D$5$ and sort by City in $A$ to $Z$ order.

Select cell A$5$ and remove the fittor.

Use the Subtotal command to show a SUM for the contract amounts for each city.

$26.$

Edit the label in cell A$2$ to display Contract Amounts by City.

Format the sheet to Landscape orientation, center the page vertically, and scale it to fit one page.

Click the Billable Hours sheet tab and select cell A$4.$

Click the Format as Table button $[$Home tab, Styles group$],$ use Orange, Table Style Medium $10,$ and remove

the data connections.

Type $5\%$ Add On in cell E$4$ and press Enter.

$31.$

Build a formula in cell E$5$ to multiply cell D$5$ by $105\%$ and press Enter to copy the formula.

Select cells A$1$:A$2$ and left align them. Then select cells A$1$:E$2,$ and press command $+1$ to open the Format

Cells dialog box. On the Alignment tab, in the Horizontal Alignment drop$-$down, and select Center Across

Selection from the Horizontal list.