Assignment InstructionsStepInstructionsPoint Value1Start Word. Download and open the file named Exp19_Word_Ch03_ML1_Football.docx. Grader has automatically added your last name to the beginning of the filename.02Select tabbed text in the document from # (in the top-left corner) to 13.4 (in the bottom-right corner), including the paragraph mark on the same line, and convert the text to a table, accepting all default settings. Change page orientation to Landscape.53Change the font of the second and third lines (Midwest Athletic Conference and Season Statistics) to Cambria 16 pt. Delete column 1 in the table. Change the font of all table data to Cambria 10 pt.64AutoFit the contents of the table. Ensure that no team names in column 1 are bold or underlined. However, entries in row 1 should remain bold and underlined.55Insert a row above row 1 in the table. Type Offensive Statistics in the first cell on the new row. Type Rushing Statistics in the next cell on the same row. Merge the second through sixth cells on the first row. Apply Align Center alignment to Rushing Statistics..66Type Passing Statistics in the next cell on the first row. Select the cell containing Passing Statistics and the next three cells on the first row. Merge the cells. Apply Align Center alignment to Passing Statistics. Merge the remaining cells on row 1, type Total in the merged cell, and apply Align Center alignment to Total.67Insert a row between HARKINSVILLE and DAKOTA STATE and type the following data in the new row:JAMES COLLEGE 38.2 41.0 220.5 4.2 19.7 32.7 0.601 199.2 7.6 57.9 449.3 5.9 12.748Select a table style of Grid Table 5 Dark - Accent 2 (row 5, column 3 under Grid Tables). Select all table text. Apply a Pen Color of Orange, Accent 2, Darker 50% (row 6, column 6 under Theme Colors) with a line weight of ½ pt and a line style of a single line to outside borders.69Ensure that the pen color is Orange, Accent 2, Darker 50% and the line weight is ½ pt. Click Line Style, select the first double-line style shown and apply the selection to the border along the horizontal line separating row 1 from row 2, and also along the vertical line separating the first column from the second. Do not extend the vertical line into row 1.510Move to the end of the document, press ENTER twice, and insert a 3x5 table. Enter the following data in the table.Calvin Spraggins SPR 1428Demaryius Schuster DEN 1197Brandon Marchant CHI 1182Wayne McAnalley IND 1156Sparky Hall HOU 1114411Change the column width of all columns in the new table to 1.5". Apply Align Center alignment to all entries in the last two columns.512Insert a new blank row at the top of the new table. Type Receiving Yards in the first cell on row 1. Change the font size of the entry on row 1 to 14 pt. Merge all cells in row 1. Ensure that Receiving Yards is centered.813Shade the first row of the second table with Orange, Accent 2, Lighter 60% (row 3, column 6 under Theme Colors).214Add a new blank row at the end of the second table and type Average in the first cell of the new row. Enter a formula in the last cell of the new row to average all entries in the column above. You do not need to select a number format.715Align both tables horizontally in the center of the page. Check for spelling and grammatical errors. All names in both tables are correct.416Change the receiving yards for Calvin Spraggins to 1451. Update the average to reflect the change.417Click any cell in the first table. Click the Table Tools Design tab and click Border Painter in the Borders group. With the pointer resembling a pen, click the double-line border that divides the first and second rows of the first table to “sample” it. Then drag to apply the sampled border to the border dividing the first and second rows in the second table. Press Esc or click Border Painter to toggle off the setting.418Add a caption below the first table with the following text: Figure 1: Midwest Athletic Conference Offensive Statistics. (Do not type the period and ensure that a space follows the colon.) Add a caption below the bottom of the second table that reads Figure 2: Average Receiving Yards. (Do not type the period and ensure that a space follows the colon.) Modify the Caption style to include a font color of Orange, Accent 2, Darker 50%. Caption style font should be bold (not italicized) and centered horizontally.919Begin a mail merge procedure, creating a letter and selecting as a recipient list Sheet1$ of Universities.xlsx. Sort the data source by University in ascending order. Filter the data source to limit to State of NC. Merge the University field with the source document so that the university name displays after the text Draft Prepared for: on page 1. Ensure that the insertion point is after the space that follows the colon before inserting the merge field. Preview results and complete the mail merge, choosing Edit Individual Documents and merging all.020Select and copy all text in the new document. Display the original document, move to the end of the document (after the caption on the second table), and insert a page break. Paste the copied text, resulting in a five page document. 1021Save and close Exp19_Word_Ch03_ML1_Football.docx. Close all other open documents without saving. Submit Exp19_Word_Ch03_ML1_Football.docx as directed.0Close

Instructions Select one of the following sample visual reports to analyze: Sample_ReportwViz_Dept of Ed2? Sample_ReportwViz_EPA ? Sample_ReportwViz_NASA ? Sample_ReportwViz_Alcoa? Analyze the document for use of the following design elements. For each of the following elements, answer the following questions: Elements Headers, footers, titles Headings and bulleted lists Labeling of visuals Placement and size of visuals References to visuals in the text Use of color Questions Is the elements used in the report? How is the element used? What’s the element’s purpose? Is the element used effectively?