Exploring Microsoft Office Word2013

Chapter 3

Department Consolidation

You are the administrative assistant for an assistant dean at a college in western New York. With recent budget cuts, a proposal has been made to consolidate several departments. You have been asked to create a document, using a table, containing the names of professors in the computer science and information system departments, which are the two departments under consideration for consolidation. This document will be used as a data source document in a mail merge to disperse information on consolidation meetings.

Open w03_chap_data(Data File 1) and save it as w03_Department_List.
Select the entire document and use the Convert Text to Table feature to change this tabbed data into a six-column, seven row table to be created by separating text at tabs.
Make the necessary changes to display the professors’ names in two separate columns. The first column will have the heading First Name and the second column will have the heading Last Name. Copy and paste the names in the correct column.
Insert a new column in the table to the right of the Zip column and a new row in the table below the last name. Type Salaryin the first cell of the new column and type Average in the seventh cell of the new row. Type the following numbers in cells 2 through 7 of the Salary column: $72,000, $65,000, $81,000, $58,000, $68,000, $55,000.Enter the formula to calculate the average of the numbers in column 7 in the lastcell of that column and format the answer in the currency number format.
Sort the data in the table by department in ascending order and then by last name in ascending order. Do not include the header row or average row in the sort.
Select the table style of Grid Table 4 – Accent 3 (fifth row, fourth column, under Grid Tables). Remove bold formatting from the first names in the column 1.
Click the Border Style arrow and select Double solid lines, ½ pt from the gallery. Apply this border style to the outside border of the table. With the Border Style still set for Double solid lines, ½ pt, select a pen color of Black, use the Border Painter to create a border between the second and third column of the table. Save this document.
Open w03_chap_data2(Data File 2)and save it as w03_Meetting_Letter.
Start a mail merge using this letter as the source document. The recipient information will come from w03_Department_List. Be sure to exclude the last record (the average) in the data source.
Replace the bracketed Current Date with today’s date. Replace the starred placeholders with corresponding merge fields from the recipient table. Replace Firstname and Lastname in the closing with your first and last names. Save this letter with the merge fields, before completing the final merge, as w03_Meetting_Letter.
Complete the merge of all records, producing a document of six letters, each addressed to a recipient in the data source. Save the merged letters as w03_Merged_Letters. Close the w03_Metting_Letter without saving it.
Submit w03_Department_List and w03_Merged_Lettersvia email to .