Your Perfect Assignment is Just a Click Away

We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!

glass
pen
clip
papers
heaphones

Software Productivity

Software Productivity

Software Productivity

Grader – Instructions Word 2016 Project

EX16_WD_CH03_GRADER_CAP_AS – Weather 1.6
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.

Steps to Perform:
Step

Instructions

Points Possible

1

Download and open the file named EX16_WD_CH03_GRADER_CAP_AS.docx.

0

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

12

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.

12

4

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

10

5

Delete the Winter row.

10

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.

12

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.

10

8

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

5

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.

2

10

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

5

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.

9

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.

7

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.

6

14

Complete the merge, merging all records.

0

15

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

0

Total Points

100

Created On: 07/05/2019 1 EX16_WD_CH03_GRADER_CAP_AS – Weather 1.6

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Homework Place only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Homework Place are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Homework Places is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Homework Place, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.