EXP W Capstone Vol2 2.0 complete solutions correct answers key

EXP W Capstone Vol2 2.0 complete solutions correct answers key

Project Description:

You are an intern with the Hospitality Industry Professionals Association (HIPA), which hosts a conference for its members every year at different locations in this country. This year, the conference will be held July 20–22 in Miami, Florida. One of your responsibilities is to create a document that provides a description of HIPA and the conference, the conference agenda, and a form for members to calculate conference expenses. You will apply several Word features to make the document look more professional. Then, you will insert several form controls into the Calculate Your Expenses table and create a macro to align the document. After you create the Agenda bookmark, you will create hyperlinks to this bookmark, the About HIPA bookmarks, and also to a Web site. Restrict the editing to allow filling in forms so that members can only type in description and expense into the Expenses table. Finally, you will create and insert a digital signature into the document.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Start Word. Combine the downloaded exploring_wcap_grader_c2_Original.docx document and the downloaded exploring_wcap_grader_c2_Revised.docx document. Accept all changes in the combined document and save it as exploring_wcap_grader_c2_LastFirst. Close all documents except for exploring_wcap_grader_c2_LastFirst.docx.

0.000

2

Insert a Continuous section break immediately to the left of the Description heading. Change the layout of the section (Section 2) containing the Description heading to two equal columns, with a line between. Change the left and right margins to 0.75 inches.

8.000

3

Insert a column break immediately to the left of the paragraph that begins In addition to.

3.000

4

From the downloaded file exploring_wcap_grader_c2_Fields.xlsx, copy the range A1:B8 to the Clipboard. In the Word document, in the first blank paragraph below the paragraph that begins The Hospitality Industry, paste the copied Excel data as a linked Microsoft Office Excel Worksheet Object. Center the object in the column. Close the spreadsheet file and exit Excel.

4.000

5

At the beginning of the document, to the left of the text About HIPA, insert a Gradient Fill - Aqua, Accent 1, Reflection WordArt with the text HIPA 2016 Conference. Change the width of the WordArt to 6.47 inches and the height to 1.6 inches. Change the font size to 48 pt. Change the wrapping style of the WordArt to Top and Bottom.

8.000

6

Select the paragraph beginning In addition to. Apply Orange, Accent 6, Lighter 80% shading to the selected paragraph.

4.000

7

Immediately to the left of the text The Hospitality Industry, insert the downloaded picture file exploring_wcap_grader_c2_Logo.png. Resize the logo's height to 1.5 inches (its width will automatically change to 1.05 inches) and apply the Tight wrapping style to the picture.

5.000

8

In the first blank paragraph below the paragraph that begins A few of the main reasons, insert a Vertical Curved List SmartArt graphic. Type the following into the three shapes (from top to bottom):
Educational Opportunities
In-person Networking
Inspiration and Innovation

6.000

9

Change the height of the three shapes containing text in the SmartArt graphic to 0.5 inches.

3.000

10

Group the four star shapes below the SmartArt graphic. Set the shape style of the grouped shape to Moderate Effect - Orange, Accent 6.

4.000

11

Switch to Outline view. Select the heading Calculate Your Expenses and the table that follows it, and create a subdocument.

Select the Agenda heading and then insert the downloaded subdocument exploring_wcap_grader_c2_Agenda.docx. Note the original Agenda heading will be replaced when the subdocument is inserted. When prompted, agree to rename the styles in the subdocument. Unlink all subdocuments and close Outline view.

8.000

12

Insert the Retrospect header building block. Enter CONFERENCE INFORMATION in the Title field. Enter 1/1/2016 in the Date field. Apply the Retrospect theme to the document. Apply the Office font theme to the document.

6.000

13

Apply a page background color that uses the Newsprint texture fill effect.

5.000

14

Show the DEVELOPER tab on the Ribbon. Turn on Design Mode. In the table on Page 3, insert a Date Picker Content Control in the cell immediately below Date. 

3.000

15

In the same table, in the cell immediately below Type of Expense, insert a Drop-Down List Content Control. Set the properties for the Drop-Down List to display Type of Expense as the Title. Enter Type in the Tag box. Delete the default value and add the following items to the list in the order given:

Transportation
Lodging
Meals
Misc.

4.000

16

In the table, in the cell below Amount, insert the Legacy control, Text Form Field. Set the properties of the text form field to be a number, the default number to 0, and the format to #,##0. Replace the contents of the Bookmark box with Amt1, and select the option to Calculate on exit. In the cell to the right of Total Expenses, insert the Legacy control, Text Form Field. Set the properties of the text form field to be a calculation, the expression to =SUM(ABOVE) and the format to $#,##0.00;($#,##0.00). Turn off Design Mode.

2.000

17

Create a new macro named Alignment with the description Change document alignment (no period). While recording the macro, be sure to follow the steps exactly as specified. Do not switch between windows in between steps.

Press CTRL+A to select the entire document. Press CTRL+E to change the alignment of the entire document to center. Stop recording the macro. 
 
Open the Alignment macro in the Visual Basic Editor. Edit the text Selection.ParagraphFormat.Alignment = wdAlignParagraphCenter to read Selection.ParagraphFormat.Alignment = wdAlignParagraphLeft. Save the macro.

4.000

18

Copy the entire Alignment macro from the Sub statement to the End Sub statement inclusive. Paste the code into the last line of this Word document. Run the Alignment macro.

4.000

19

On Page 2, create a bookmark to the left of the Conference Agenda heading, using Agenda for the name of the bookmark.

At the top of Page 1, create a hyperlink from the word Agenda to the Agenda bookmark. Create a hyperlink from the text About HIPA to the About bookmark.

6.000

20

On Page 1, in the paragraph that begins The Hospitality Industry, create a hyperlink to the Web page http://www.hipa.conference.net from the text Web site (Note: This link does not actually open a live Web site.)

4.000

21

Restrict editing in the document by selecting Limit formatting to a selection of styles and allow filling in forms as the only type of editing in the document. Start enforcing protection, leaving the password boxes blank.

6.000

22

Create a digital certificate for Conner Lee. Add a digital signature to the document for Conner Lee. Note that you may have to change the signature to select Conner Lee. In the Purpose for signing this document box, type verify integrity of contents (no period). If a warning that the certificate cannot be verified is displayed, click Yes to use the certificate. Also ignore any references to Invalid Signatures that may be displayed in the Backstage after this step is completed.

3.000

23

Save the document in the .docx format, close the document, and then exit Word. Submit the exploring_wcap_grader_c2_LastFirst.docx document as directed.

0.000

Total Points

100.000