1.

You are a volunteer completing a sales proposal for the Neighborly Corner Grocery store. To make the title page more attractive, format the "Neighborly" title paragraph on page 1 as follows: a. Add a Box paragraph border. b. Apply the Aqua, Accent 1 border color (5th column, 1st row of the Color palette in the Borders and Shading dialog box). c. Use a 3 pt. border width. d. Apply the Blue-Gray, Accent 4, Lighter 80% shading color (8th column, 2nd row of the Shading gallery).

Add a paragraph border to the title.

Change the border color.

Change the border width.

Apply paragraph shading.

2.

Format the "Corner Grocery Store" subtitle paragraph as follows so it coordinates with the title paragraph: a. Add a Box paragraph border. b. Apply the Blue-Gray, Accent 4 border color (8th column, 1st row of the Color palette in the Borders and Shading dialog box). c. Use a 3 pt. border width.

Add a paragraph border to the subtitle.

Change the border color.

Change the border width.

3.

Create a 1" Left indent and a 1" Right indent for the "Neighborly" paragraph and the "Corner Grocery Store" paragraph to fit the borders more tightly around the text.

Change the Left paragraph indentation of the title.

Change the Right paragraph indentation of the title.

Change the Left paragraph indentation of the subtitle.

Change the Right paragraph indentation of the subtitle.

4.

To increase visual impact, add a custom picture watermark to the document using the file Support_SC_WD16_4a_Neighbors.jpg, available for download from the SAM website.

Insert a picture watermark.

5.

On page 1, complete and format the SmartArt graphic by modifying it as follows: a. Enter the text Fresh Produce into the first shape. b. Change the colors of the SmartArt graphic to Gradient Loop – Accent 1. c. Apply the Intense Effect SmartArt style.

Enter text in a SmartArt shape.

Change the colors of the SmartArt.

Apply a SmartArt style.

6.

Expand the character spacing of the "Where neighbors meet" paragraph to 1.5 pt. to make the paragraph more noticeable.

Change the character spacing of text.

7.

Insert a Next Page section break at the beginning of the "Welcome to the Neighborly Corner Grocery" heading paragraph to separate the title page from the other two pages.

Insert a section break.

8.

On page 2, clear the formatting from the paragraph beginning "The Neighborly Corner Grocery…" and ending "…take care of it." to return the paragraph to the Normal style.

Clear the paragraph formatting.

9.

Select the five bulleted paragraphs in the "In Stock" section, and then sort the paragraphs so they appear in alphabetical order, allowing readers to find information more easily.

Sort a list in alphabetical order.

10.

In the same five bulleted paragraphs, add visual appeal by changing the bullet character to a picture inserted from the file Support_SC_WD16_4a_Bullet.png, available for download from the SAM website.  (Hint: Opening the file Support_SC_WD16_4a_Bullet.png in any application prior to using it as picture bullets may cause this step to grade incorrectly. If you have opened the file, delete it and download a new copy from the SAM website before completing this step.)

Change the bullets to a picture.

11.

In the blank paragraph below the "Prepared Foods" heading, insert text from the file  Support_SC_WD16_4a_Deli.docx, available for download from the SAM website, to include a description of the store's prepared foods department.

Insert text as an object from a file.

12.

On page 3, format the "Sandwich Board" table as follows to make it easier to read: a. In row 1, merge the cells in columns 2, 3, and 4. b. Use Align Center to center the "Select a size" heading in the merged cell both horizontally and vertically. c. Autofit the table to its contents. d. Shade row 1 with the Blue-Gray, Accent 4, Lighter 80% shading color (8th column, 2nd row of the Shading gallery). e. Sort rows 3–12 so that the sandwiches appear in alphabetical order.

Merge table rows.

Align text in a table cell.

Autofit a table.

Change the shading of a table row.

Sort text in a table alphabetically.

13.

On page 3, format the "NCGG Membership" table as follows to balance the columns: a. Change the width of column 1 to 1.75". b. Distribute columns 2–4 so that they are of equal width.

Adjust the column width in a table.

Distribute columns in a table.

14.

Complete the table by adding formulas as follows: a. In the "First-year total" row of the "Student" column, insert a formula that sums the numeric values above the "First-year total" row. b. Insert the same formula for the "Individual" and "Family" columns.

Insert a formula in a table cell.

Insert a formula in a table cell.

Insert a formula in a table cell.

15.

In the "Family" column, change the price of the "Refundable investment" amount from $125.00 to $105.00. Update the formula in the "First-year total" row for the "Family" column to display the correct total.

Edit text in a table.

Update a field in a table.

16.

At the bottom of page 3, use the Format Painter to copy the formatting from the paragraph beginning "Neighborly Corner Grocery…" and ending "…all week long" to the last paragraph in the document so the last two paragraphs have the same formatting.

Use the Format Painter.