1.

As an executive assistant at Crown Medical, a medical device manufacturer in Cleveland, Ohio, you are drafting a business proposal for a spin-off business focusing on a system for performing accurate hearing tests. The proposal must contain 1000 words or less.  On page 1, expand the character spacing of the paragraph "Executive Summary" by 2 point to call attention to the heading.

Change the character spacing.

2.

Format the bulleted list in the "Objectives" section as follows to make the list more logical and attractive: a. Demote the two bulleted items after the "Sales and marketing" item ("Design and carry out…" and "Establish awareness…") by one level. b. Change the color of the bullets to Aqua, Accent 5 for the four first-level bulleted items ("Management team", "Sales and marketing", "Product development", and "Customer service").

Demote list items.

Change the color of bullets.

3.

Sort the four paragraphs in the "Company Background" section in ascending order by paragraph.

Sort paragraphs.

4.

On page 2, split and merge cells in the "Start-Up Costs" table and insert a formula as follows to make the table easier to interpret: a. Split the cell containing the text "Requested Funding Total Amount" into 2 columns and 1 row. b. Insert a formula in cell B9 (the cell to the right of the "Total Requested:" cell) that sums the values above the cell. c. Merge cells B9, C9, and D9 (the three cells to the right of the "Total Requested:" cell).

Split a table cell.

Insert a formula in a table cell.

Merge table columns.

5.

Format the "Start-Up Costs" table as follows to improve its appearance and usefulness: a. Change the top and bottom cell margins to 0.04 for all cells in the table. b. Shade row 1 (the header row) using the Aqua, Accent 5, Lighter 60% shading color. c. Change the direction of the "Difference provided by owners" text so that it reads from top to bottom.  d. Resize column A to fit the cell contents using AutoFit.

Change the margins of a table cell.

Apply shading to a table cell.

Change the direction of text in a table cell.

Resize a column using AutoFit.

6.

Format and sort the table in the "Roles and Shares" section as follows to make the table more useful as a reference and to coordinate with the "Start-Up Costs" table: a. Sort the table in descending order by the numbers in the "Share" column without sorting the header row. b. Change the color of all the table borders to Aqua, Accent 5 to match the color of the "Start-Up Costs" table. c. Distribute the rows in the table. d. Change the width of column C (the "Share" column) to 1.35". e. Align the percentage amounts in the "Share" column using Align Center Right.

Sort a table.

Change the color of a table cell border.

Distribute table rows.

Resize a table column.

Align text in a table column.

7.

Format the shaded "For More Information" section at the bottom of page 2 as follows to set it apart from the rest of the document: a. Change the indentation of the two paragraphs ("For More Information" and "Contact Michael Linde…") to a 0.5" Left Indent. b. Format the heading text "For More Information" in Small caps to distinguish it from other headings.

Change the paragraph indentation.

Change the font case.

8.

Update the field after the "Number of words:" text to accurately reflect the number of words in the document.

Update the word count.

9.

Insert a Draft 1 watermark to emphasize that the document is being developed. [Mac Hint: Insert a Text watermark using the Draft option. Change the Transparency to 50% and the Orientation to Diagonal.]

Insert a watermark.

10.

Add a cover page as follows to create a professional opening page for the document: a. Insert the Slice (Dark) cover page. b. Type Crown Auditory Testing as the document title. c. Type Business proposal as the document subtitle.

Insert a cover page.

Enter text in the document title placeholder.

Enter text in the document subtitle placeholder.