Southern Methodist University CH3 Midwest Athletic Conference Season Statistics HW

User Generated

LhwvnaUna

Business Finance

Southern Methodist University

Description

Assignment Instructions

StepInstructionsPoint Value
1Start 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.0
2Select 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.5
3Change 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.6
4AutoFit 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.5
5Insert 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..6
6Type 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.6
7
Insert 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.7
4
8Select 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.6
9Ensure 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.5
10
Move to the end of the document, press ENTER twice, and insert a 3x5 table. Enter the following data in the table.


Calvin Spraggins SPR 1428
Demaryius Schuster DEN 1197
Brandon Marchant CHI 1182
Wayne McAnalley IND 1156
Sparky Hall HOU 1114
4
11Change 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.5
12Insert 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.8
13Shade the first row of the second table with Orange, Accent 2, Lighter 60% (row 3, column 6 under Theme Colors).2
14Add 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.7
15Align both tables horizontally in the center of the page. Check for spelling and grammatical errors. All names in both tables are correct.4
16Change the receiving yards for Calvin Spraggins to 1451. Update the average to reflect the change.4
17Click 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.4
18Add 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.9
19Begin 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.0
20
Select 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.
10
21Save and close Exp19_Word_Ch03_ML1_Football.docx. Close all other open documents without saving. Submit Exp19_Word_Ch03_ML1_Football.docx as directed.0

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Here is the final file

Draft Prepared for: Charge University

Midwest Athletic Conference
Season Statistics
Offensive Statistics
Team
UWA
HARKINSVILLE
JAMES COLLEGE
DAKOTA STATE
BISHOP
MUNFORD
CENTRAL STATE
ITAWAMBA
TERRELL UNIV
USM
CHASE COLLEGE
VALLEY BAPTIST
TAYLOR STATE
CHARGE UNIV
SOUTH GREEN
LAYTON COLLEGE
MMU
SOUTHWESTERN

PPG
28.5
26.1
38.2
38.5
37.2
36.4
23.5
36.4
25.3
18.7
35.0
44.1
30.4
19.8
23.2
21.2
29.2
29.2

RA
63.0
30.4
41.0
40.4
42.3
45.8
30.7
41.8
67.2
36.5
43.2
44.2
36.8
28.7
35.2
40.5
39.6
31.7

Rushing Statistics
RY
RYPA
328.7 5.2
114.4 3.8
220.5 4.2
224.6 5.6
230.4 5.4
190.7 4.2
119.8 3.9
219.0 5.2
369.8 5.5
148.4 4.1
214.2 5.0
225.5 5.1
173.1 4.7
91.3
3.2
157.4 4.5
175.3 4.3
161.6 4.1
151.0 4.8

COMP
6.7
30.3
19.7
15.3
24.8
21.5
22.5
21.4
4.3
12.2
24.7
23.7
19.7
21.3
18.6
16.3
22.7
18.7

ATT
11.6
48.6
32.7
23.1
40.9
32.7
38.1
31.7
10.0
21.4
38.1
38.5
29.6
39.4
33.9
31.7
37.8
31.8

PCT
0.576
0.624
0.601
0.663
0.607
0.656
0.591
0.675
0.427
0.572
0.650
0.615
0.665
0.541
0.548
0.516
0.601
0.589

Passing Statistics
PY
PYPA
107.2 9.3
312.7 6.4
199.2 7.6
214.5 9.3
291.4 7.1
258.5 7.9
...


Anonymous
Really great stuff, couldn't ask for more.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags