1.

As an associate market analyst at Spree Wireless, a global media and communications company, you are completing the final draft of a report on customer tablet usage, which will help determine whether the company continues to sell tablet devices. Start by using the Navigation pane to format headings and refine the organization of the document as follows: a. Demote the "Key Areas of Difference" heading so that it uses the Heading 2 style. b. Promote the "Report Study Group" heading so that it uses the Heading 1 style.

Demote a heading.

Promote a heading.

2.

In the blank paragraph in the "Tablet Considerations" section on page 2, insert and format an informative diagram as follows: a. Insert the Basic Process SmartArt from the Process section of the SmartArt gallery. b. Type Market in the left shape. c. Type Customers in the middle shape. d. Type Usage in the right shape. e. Resize the SmartArt to a height of 2.4" and a width of 5".

Insert SmartArt.

Enter text in the first SmartArt shape.

Enter text in the second SmartArt shape.

Enter text in the third SmartArt shape.

Resize SmartArt.

3.

In the blank paragraph in the "Survey Results" section on page 3, show the number of minutes customers use tablets by inserting a table with 4 columns and 2 rows, and then entering the data shown in Table 1.

Enter text in table cell A1.

Enter text in table cell B1.

Enter text in table cell C1.

Enter text in table cell A2.

Enter text in table cell C2.

Enter text in table cell B2.

Enter text in table cell D1.

Enter text in table cell D2.

4.

Format the new table as follows to suit the design of the document: a. Apply the List Table 3—Accent 6 table style. b. Remove the First Column table style option.

Apply a table style.

Toggle table style options.

5.

Make the following changes to the "Seniors using tablets" table so the data is easier to interpret: a. Sort the table in descending order by the "Tablet (%)" column. b. In the blank cell of the table, insert a formula that sums the values above using the 0% number format. c. Resize column C (the "Tablet (%)" column) to its best fit.

Sort a table.

Resize a table column.

Insert a formula with a specified number format in a table cell.

6.

The "All adult customers owning tablets" table needs to be updated because it includes a repeated row and is missing data. Modify the table as follows: a. Delete row 5, which contains the text "Men" and "33" and repeats the data in row 3. b. Insert a row at the end of the table. c. Type 65+ in the first cell of the new row. d. Type 32 in the second cell of the new row.

Delete a row in a table.

Enter text in table cell A9.

Enter text in table cell B9.

7.

Format the "All adult customers owning tablets" table as follows to suit the design of the document: a. Apply the List Table 3—Accent 6 table style to the table. b. Remove the First Column table style option. c. Merge the cells in the "Gender" row. d. Apply Align Top Center to only the data in the Percentage column (cells B2, B3, B5, B6, B7, and B8). e. Format the table to AutoFit Window.

Apply a table style.

Toggle table style options.

Align text in a table column.

Format a table using AutoFit.

Merge table cells.

8.

After the heading "Report Study Group" on page 4, format the list of job titles and employee names as follows to make them easier to read: a. On each line, beginning "Market Analyst Hugh Cunningham" and ending "Executive Assistant Zack Kealy", set a 3.25" left tab stop with option 2 (dotted) leaders. b. Press TAB to replace the space between the job title and the employee name so that the names are aligned with the new tab stop.

Set a tab stop.

Position text using a tab stop.

Set a tab stop.

Set a tab stop.

Position text using a tab stop.

Position text using a tab stop.

Position text using a tab stop.

Position text using a tab stop.

Set a tab stop.

Set a tab stop.

9.

Insert the Slice 1 header, and then close the Header & Footer Tools.

Insert a header.

10.

Insert a cover page as follows: a. Insert the cover page using the Slice (Dark) style. b. Replace the Document Title placeholder with the following text:  Spree Wireless c. Replace the Document Subtitle placeholder with the following text:  Tablet Customer Report

Insert a cover page.

Enter text in the Document Title placeholder.

Enter text in the Document Subtitle placeholder.