All our Essay orders are Original, and are written from scratch. Try us today at 30% off

Exp19_Word_Ch03_HOEAssessment_Radio

Grader – Instructions Word 2019 Project
Exp19_Word_Ch03_HOEAssessment_Radio
 
Project Description:
You work with the Radio Advertisers Federation to promote the use of radio advertising. In this document, you provide a summary of research related to the weekly reach of various media sources, including tables describing the reach as well as the weekly hours most households spend with those sources. The summary will be distributed to various local advertisers as part of a mail merge process.
 

Steps to Perform:

Step
Instructions
Points Possible

1
Start Word. Download and open the file named Exp19_Word_Ch03_HOEAssessment_Radio.docx . Grader has automatically added your last name to the beginning of the filename.
0

2
Ensure that Ruler is shown and that nonprinting characters are displayed. Move to the last page of the document and type the following, beginning in the first cell of the blank row at the bottom of the table: 24 RA Tablet 78.1
2

3
Move to the second blank paragraph following the table. Draw a table approximately 6 inches wide and 3 1/2 inches tall. Draw one vertical grid line at approximately 3 inches from the left to create two columns. Draw 5 horizontal grid lines to divide the table into 6 approximately evenly spaced rows of about 1/2 inch each. Rows do not have to be precisely spaced as you will distribute them later.
5

4
Erase the vertical gridline in the first row, so that the row includes only one column. Ensure the insertion point is located in the first row and type Table 2 – Weekly Hours (Average Watch or Listen Time). (Ensure that a space precedes and follows the hyphen and do not type the period.) Press TAB and complete the table as follows (do not press TAB at the end of the last entry): Radio 25.7 TV 21.5 Smartphone 18.3 PC 10.7 Tablet 7.7
4

5
Select Table 2 and change the font size of all text to 12 pt. Apply bold formatting to the first row in Table 2. Delete the Category column in the first table. Insert a row above the first row in Table 1 and type Table 1 – Weekly Reach of Media. (Ensure that a space precedes and follows the hyphen and do not type the period.)
3

6
In Table 1, insert a row between Hub and Insight. Type the following in the new row, ensuring that the new entry is in Times New Roman, 12 pt. Nielsen Smartphone 142.3
3

7
In Table 2, insert a blank row above row 2. Type Source in the first cell of the new row and type Hours in the second cell. Apply bold formatting to both cells. Select Table 2, ensure that the Table Tools Layout tab is selected, and click Distribute Rows.
5

8
Select cells in the first column of Table 1, from row 2 through the end of the table. Ensure that you do not include text from row 1. Split the cells, making sure to deselect Merge cells before split. Type Source in cell 2 of row 2 in Table 1. Complete the remaining cells in the second column as follows. (Type only those shown in column 2 of the list below.) PPM 30 Hub 87 Neilsen 82 Insight 26 RA 12
5

9
Insert a row below the last row in Table 1. In the third column of the new row, type Total. Apply bold formatting to the word Total and apply Align Center Right alignment. In the next cell on the same row, enter a formula to sum all cells in the column above. You do not need to select a number format.
8

10
Sort the rows containing media sources in Table 1 (rows 3-7) by Column 3 in ascending order so that the media sources are shown in alphabetical order. Do not include the heading rows or the total row in the sort.
4

11
Insert a column to the right of the last column in Table 1 and type Percentage of Total in the second row of the new column. In the third row of the last column, type a formula that divides the Households Reached value in the cell to the left by the Total in the last row and then multiplies by 100 to convert the result to a percentage. The formula is =d3/d8*100. Select a number format of 0.00%.
3

12
Include a formula in each cell in the Percentage of Total column except for the last cell (on the Total row), adjusting cell references in each formula to reflect the current row. Apply Align Center alignment to all numeric entries in the last two columns.
7

13
Merge all cells in the first row of Table 1 and ensure that the text is centered. Change the number of households reached by TV to 197.5. Update the field in the last row of that column (the total) and also update all fields in the last column to reflect that change.
7

14
At the first blank paragraph at the beginning of the second page, insert text from Radio_Statistics.docx. In Table 1, apply a style of Grid Table 4 – Accent 3 (row 4, column 4 under Grid Tables). Deselect First Column in the Table Style Options group to remove bold formatting from the first column. Bold all cells in row 2 and apply Align Center alignment.
6

15
Center both tables horizontally on the page. Select Table 2. Select a border style of Double solid lines, ½ pt, Accent 3 (row 3, column 4). Apply the border style to all borders.
7

16
Select row 1 of Table 2 and apply a custom shading color of Red – 137, Green – 121, and Blue – 139. Change the font color of all text in row 1 to White, Background 1 and ensure that it is bold. Shade all remaining rows, including those on page 3, in Light Gray, Background 2. Change the Pen Color to Black, Text 1, and drag the border dividing row 1 from row 2 in Table 2.
4

17
Select the first two rows of Table 2 and repeat the header rows so that they display at the top of the table section that is currently shown on page 3. Include a caption below Table 1 with the text Table 1 : Household Reach of Media Sources. (Do not type the period and ensure that a space follows the colon.) Include a caption below Table 2 with the text Table 2 : Average Weekly Hours. (Do not type the period and ensure that a space follows the colon.) Modify the Caption style to include center alignment with bold, italicized text.
10

18
Move to the end of the document and press ENTER. Insert text from Ratings_Sources.docx. Select all text from Ratings Source to http://www.rainc.com. Whether you select the paragraph mark following the URL is irrelevant; however, do not select the blank paragraph on the following line. Convert the selected text to a table, accepting all default settings. Apply a table style of Grid, Table 4 (row 4, column 1 under Grid Tables) and add a caption below the new table as Table 3 : Major Ratings Sources. (Do not type a period.)
9

19
Begin a mail merge procedure, selecting the Access database Source Ratings.accdb as a recipient list. Note Mac users, select the text file Source Ratings.txt as a recipient list. Edit the recipient list to add the following record and respond affirmatively when asked to update the recipient list: Source ID Company Guild Member B9111 Insight False

0

20
Filter the recipient list to select only those with a value of False in the Guild Member column. Replace [Company Name] in the last body paragraph on page 2 with the merge field of Company. Be sure to include the brackets in the text to be replaced.
0

21
Preview results and then finish the merge, editing individual documents and merging all. Press CTRL+A to select all of the merged document and copy the selection. Display Exp19_Word_Ch03_HOEAssessment_Radio, move the insertion point to the end of the document (after the last caption) and insert a page break. Paste all copied text, resulting in a 7-page document
8

22
Save and close Exp19_Word_Ch03_HOEAssessment_Radio.docx. Close all other open documents without saving. Submit Exp19_Word_Ch03_HOEAssessment_Radio.docx as directed.
0

Total Points
100

 
Created On: 02/08/2021 1 Exp19_Word_Ch03_HOEAssessment – Radio 1.3
The post Exp19_Word_Ch03_HOEAssessment_Radio first appeared on Assignment writing service.

  

Testimonials

Best Service

The book review I asked for is so amazing! Endless thanks to your team for completing my review and for...

Great Job

Great job! Those were you, guys, who made my coursework perfect in time according to all my requirements. I will...

Best

They look cool and trustworthy enough to me. I gather they made discounts as their prices are quite affordable if...

Comes through every time

I have used this website for many times, and each time they found perfect writers for me and they produce...

No Complaints So far Guys

Yeah …I really like all the discounts that they offer, the prices are very flexible. Plus they have different promotions...

Mh! not bad…

The worst part ever was to find my deadline postponed for 1 hour ! They couldn`t finish the essay within...

CLICK HERE  To order your paper

About Scholarfront Essay writing service

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for upto 20% off in their first Order. Our payment method is safe and secure.

 CLICK HERE to Order Your Assignment

 

ORDER WITH 15% DISCOUNT

Let your paper be done by an expert

Custom Essay Writing Service

Our custom essay writing service has already gained a positive reputation in this business field. Understandably so, all custom papers produced by our academic writers are individually crafted from scratch and written according to all your instructions and requirements. We offer Havard, APA, MLA, or Chicago style papers in more than 70 disciplines. With our writing service, you can get quality custom essays, as well as a dissertation, a research paper, or term papers for an affordable price. Any paper will be written on time for a cheap price.

Professional Essay writing service

When professional help in completing any kind of homework is all you need, scholarfront.com is the right place to get it. We guarantee you help in all kinds of academia, including essay, coursework, research, or term paper help etc., it is no problem for us. With our cheap essay writing service, you can be sure to get credible academic aid for a reasonable price, as the name of our website suggests. For years, we have been providing online custom writing assistance to students from countries all over the world, including the United States, Canada, the United Kingdom, Australia, Italy, New Zealand, China, and Japan.