Community theatre

Community Little Theatre

• Report rights infringement
• published: 04 Oct 2016
• views: 0

http://homework.plus/products.php?product=Community-Little-Theatre Community Little Theatre Project Description: In this project, Zane Castile, the Executive Director of Community Little Theatre, wants to use a form letter to announce the new season of the theater. Mr. Castille wants to use tables to organize various information he wants discussed in the letter. To help Mr. Castile accomplish his goals, you will convert text to a table, format tables, perform calculations in a table, and use the mail merge feature to create form letters. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Word. Download and open the file named Exploring_w04_Grader_IR.docx. 0 2 Convert the text that begins with The Sound of Music and ends with July 1 to a table, using tabs to separate the text into columns. 6 3 In the table that begins The Sound of Music,sort the contents of the table by Column 1 in descending order. 3 4 On the second blank line below the paragraph that begins Here at CTL, insert a table with two columns and two rows. In the table you just inserted, enter Membership in the top left cell and $100 in the top right cell. Enter Individual Tickets in the bottom left cell and $150 in the bottom right cell. 10 5 In the Membership table, change the width of both columns to 2 inches. 4 6 In the Membership table, change the height of both rows to 0.5 inches. 4 7 In the Membership table, center the text in all the cells vertically and horizontally. 6 8 In the Membership table, center the table between the right and left margins of the page. 6 9 In the Membership table, change the formatting of all cell borders to a double-line with 3/4 pt width. 6 10 In the Multiple Ticket Discounts table, delete the last row. 6 11 In the Multiple Ticket Discounts table, split the cells in the second row into 2 columns and 1 row. 6 12 In the Multiple Ticket Discounts table, insert a column to the right of the Discounted Price column. Enter the text Total Cost in the third row of the new column. 6 13 In the Multiple Ticket Discounts table, merge the cells in the first row. 6 14 Apply the table style Light List – Accent 2 to the Multiple Ticket Discounts table. 6 15 In the Multiple Ticket Discounts table, in the Total Cost column, use the Product function to calculate the total cost for each ticket and discount option. Format the function results using the number format $#,##0.00;($#,##0.00). Hint: On the Layout tab, click the Formula button. In the Formula dialog box, in the Formula field, replace the current contents with =PRODUCT(LEFT). Select the number format and click OK. Repeat this process in the each of the cells. 10 16 Start the mail merge process (not the Mail Merge Wizard), selecting the option to create letters. Select the recipients from an existing list using the first table in the downloaded w04_list.xlsx workbook. On the third line of the document, immediately before the comma [,] after Dear, insert the merge field Title. Press SPACEBAR and then insert the merge field Last_Name. 0 17 Merge all records to a new document. The new document will have three pages. Save the document as w04_merged.docx. 0 18 Close all open documents, saving the changes and then exit Word. Submit the w04_merged.docx document as directed. 0 Total Points 85