I need this assignment done in the morning...Can anyone proficient with Word complete this?

Office 2016 – myitlab:grader – Instructions Word Project

EX16_WD_CH03_GRADER_CAP_AS - Weather 1.1

Project Description:

In the following project, you will modify a document prepared for publication in one or more journals related to weather statistics in the United States. Climate change, or global warming, is suspected by some to be a factor in the change in injuries and fatalities related to natural disasters and weather trends. The document and related table will be combined with a data source in a mail merge operation to send to selected journal editors.

Instructions:

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

Step

Instructions

Points Possible

1

Download and open the file named EX16_WD_CH03_GRADER_CAP_AS.docx.

0.000

2

Insert a column at the right of the 10-Year Average column in the table. Add the following data in the new column, beginning in row 2:
64
42
65
200
122
23
34
60
32

6.000

3

Type 30-Year Average in the fourth cell on row 1. Insert a new row at the top of the table, merge cells in the new row, and type U.S. Natural Disaster Statistics. Format the first row with Align Center alignment.

6.000

4

Align Center all entries in the second, third, and fourth columns from row 2 through the last row in the table.

7.000

5

Delete the Winter row.

6.000

6

Add a row below the last row in the table. Type Total in the first cell of the new row. Insert a formula in the second, third, and fourth columns of the new row to total all values above.

9.000

7

Apply Grid Table 5 Dark, Accent 5 table style to the table (fifth row, sixth column under Grid Tables). Select the table. Select a pen color of Blue, Accent 5, Darker 50%. Apply the color to Outside Borders.

9.000

8

Bold all entries in row 2. Shade row 2 with Blue-Gray, Text 2, Lighter 40%.

9.000

9

Select row 2 and apply a Single solid line, 1 1/2 pt., Accent 1 (second row, second column under Theme Borders) border style to the outside borders of the selected row.

8.000

10

Change the format of the formula in the second cell of the last row (total for Year 2015) to #,##0.

7.000

11

Click the Mailings tab, click Start Mail Merge, and then click Letters. Click Select Recipients, and then click Use an Existing List. Browse for the Ex16_WD_CH03_GRADER_CAP_AS_Datasource.xlsx workbook and select Sheet1. Sort the data source in ascending order by State.

12.000

12

At the beginning of the document, replace the text [Address Block] with the merge fields as follows:
First_Name (Press SPACEBAR) Last_Name
Address
City, (Type a comma, then press SPACEBAR) State (Press SPACEBAR) Zip
At the end of the document, replace [Journal Name] with data from the Journal_Name field. Preview the letters.

8.000

13

Adjust the address block so that it is single spaced with no spacing before or after paragraphs. Format the journal name in the last line of the document in italics.

7.000

14

Complete the merge, merging all records.

6.000

15

Save the merged document as EX16_WD_CH03_GRADER_CAP_AS_LastFirst.docx and close the document. Close EX16_WD_CH03_GRADER_CAP_AS.docx without saving the document. Exit Word. Submit EX16_WD_CH03_GRADER_CAP_AS_LastFirst.docx as directed.

0.000

Total Points

100.000

Updated: 05/09/2017 2 Current_Instruction.docx