1.

You are writing an article that will be available as a file to download from the TopJobs website, and you need to update and format the tables in the document. Start by sorting the "Personality types" table on page 1 as follows: a. Sort the table in ascending order by the contents of the "Type" column. b. Specify that the table has a header row so you do not include the header row in the sort.

Sort a table.

2.

Format the "Personality types" table as follows to add visual appeal: a. Apply the Grid Table 4 - Accent 1 style to the table. b. Remove the special formatting from the first column only.

Apply a table style.

Toggle table style options.

3.

In the "Fastest-growing occupations" table at the bottom of page 1 and continuing on page 2, include information about another occupation by inserting a new row below the "Emergency medical technician" row, which appears on page 2, with the data shown in Table 1 in the Instructions file.

Insert a table row and enter data.

4.

To remove inaccurate information, delete the "Therapist assistant" row from the "Fastest-growing occupations" table.

Delete a row.

5.

To emphasize the header row and balance the contents across the page, format the "Fastest-growing occupations" table as follows: a. Shade the header row using the Green, Accent 1, Lighter 80% shading color (5th column, 2nd row of the Theme Colors palette). b. Distribute the columns in the entire table so that the column widths are equal.

Shade a table row.

Distribute table columns.

6.

Resize the "Typical expenses" table on page 2 so each row has a height of 0.25", making the contents easier to read.

Resize table rows.

7.

Merge and split cells in the "Typical expenses" table as follows to organize its contents: a. In column 1, merge the cells in rows 1–6. b. Split the last row into one row with three columns. c. Type Total: in the last row of column 2, then bold the "Total:" text.

Merge table rows.

Enter text in a table.

Bold text in a table.

Split a table row.

8.

Format the "Typical expenses" table as follows to better suit its contents: a. Set the width of column 1 to 0.95", then set the width of column 3 to 1.0". b. Apply the Align Center alignment option to the contents of column 1. c. Apply the Align Center Right alignment option to the following cells: • All of column 3 • Cell containing the "Preparation Subtotal:" text • Cell containing the "On the Job Subtotal:" text • Cell containing the "Total:" text

Adjust the column width in a table.

Adjust the column width in a table.

Align text in a table column.

Align text in a table column.

Align text in table cells.

9.

Complete the "Typical expenses" table by adding fields with formulas as follows: a. In the "Amount" column of the "Preparation Subtotal:" row, insert a field with a formula that calculates the sum of the four Preparation expenses. b. In the "Amount" column of the "On the Job Subtotal:" row, insert a field with the following formula to calculate the sum of the three On the Job expenses: =SUM(C7:C9) c. In the "Amount" column of the "Total:" row, insert a field with the following formula to calculate the total expenses: =C6+C10 d. Because the Technology expense amount seems low, change the amount from $750.00 to $1100.00. (Hint: Do not type the period following the new amount.) e. Update the fields showing the "On the Job Subtotal:" and the "Total:" to display the new amounts.

Insert a formula in a table cell.

Insert a formula in a table cell.

Insert a formula in a table cell.

Edit text in a table cell.

Update a formula in a table cell.

Update a formula in a table cell.

10.

In the "Typical expenses" table, remove the right border from column 2 to reduce clutter.

Remove a table border.

11.

In the blank paragraph after the "Employment factors" heading, insert a table with two columns and four rows, then enter the data shown in Table 2 in the Instructions file to complete the document.

Insert a table.

Enter text in a table.

Enter text in a table.

Enter text in a table.

Enter text in a table.

Enter text in a table.

Enter text in a table

Enter text in a table.

Enter text in a table.