{"id":104494,"date":"2022-11-11T15:02:10","date_gmt":"2022-11-11T15:02:10","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/exp19_word_ch03_ml2_fresh-computer-science-homework-help\/"},"modified":"2022-11-11T15:02:10","modified_gmt":"2022-11-11T15:02:10","slug":"exp19_word_ch03_ml2_fresh-computer-science-homework-help","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/exp19_word_ch03_ml2_fresh-computer-science-homework-help\/","title":{"rendered":"Exp19_word_ch03_ml2_fresh | Computer Science homework help"},"content":{"rendered":"
\n

\u00a0\u00a0<\/p>\n

Exp19_Word_Ch03_ML2_Fresh<\/strong><\/h2>\n

Word Chapter 3 Mid-Level 2 – Fresh\u00a0<\/strong><\/h2>\n

Exp19 Word Ch03 ML2 Fresh<\/strong><\/p>\n

\u00a0\u00a0<\/p>\n

Project Description:<\/strong><\/h3>\n

You are preparing a one-page flyer promoting a meal planning service and app. The flyer includes information, some of which is shown in a table, describing the new service. You will merge the flyer with a data source to produce personalized copies of the flyer.<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

Start Word. Download \u00a0\u00a0and open the file named Exp19_Word_Ch03_ML2_Fresh.docx<\/em>. \u00a0\u00a0Grader has automatically added your last name to the beginning of the \u00a0\u00a0filename.<\/p>\n

\u00a0<\/p>\n

Ensure that \u00a0\u00a0nonprinting characters are displayed. At the second blank paragraph that \u00a0\u00a0follows the document logo, insert a 2×1 table. Type Meal \u00a0\u00a0Planning Series <\/strong>in the first cell of the table. Type Volume 24<\/strong> in the next cell and \u00a0\u00a0right-align it. Format all text in the table as italics, with a font size of \u00a0\u00a010 pt.<\/p>\n

\u00a0<\/p>\n

Adjust the width of \u00a0\u00a0both columns in the table to 2″. Center the table horizontally on the page. Shade the table with Green, \u00a0\u00a0Accent 6, Lighter 60%.<\/p>\n

\u00a0<\/p>\n

Select text at the \u00a0\u00a0end of the page, beginning with Citrus \u00a0\u00a0Salmon Whole Grain Rice Bowl<\/em> and ending in 490<\/em> (whether you select the paragraph mark that follows 490 <\/em>is irrelevant). Convert the \u00a0\u00a0selected text to a table, accepting all default dialog box selections.<\/p>\n

\u00a0<\/p>\n

Adjust the width of \u00a0\u00a0the second column to 1\u201d. Insert a row above the first row and type Meal \u00a0\u00a0Selection <\/strong>in \u00a0\u00a0the first cell. Type Calories <\/strong>in the second. Apply Align \u00a0\u00a0Center alignment to both entries in row 1.<\/p>\n

\u00a0<\/p>\n

Insert a column at \u00a0\u00a0the right of the second column. Type Remaining Calorie Count <\/strong>in row 1 of the new \u00a0\u00a0column. Text will wrap in the cell.<\/p>\n

\u00a0<\/p>\n

Click in the third \u00a0\u00a0column on the second row (below Remaining \u00a0\u00a0Calorie Count<\/em>). Include a formula to subtract Calories from 1200<\/strong>. You do not need to \u00a0\u00a0select a Number format. Repeat the formula down the column, adjusting the \u00a0\u00a0cell reference for each row.<\/p>\n

\u00a0<\/p>\n

Insert a column to \u00a0\u00a0the left of the first column and adjust column width of the new column to 1\u201d. \u00a0\u00a0Merge all cells in the new column. Type FRESH! <\/strong>in the merged cell. \u00a0\u00a0Click Text Direction in the Alignment group on the Table Tools Layout tab \u00a0\u00a0twice to rotate the text attractively. Click Align Center. Change the font \u00a0\u00a0size of text in the first column to 26.<\/p>\n

\u00a0<\/p>\n

Modify all formulas \u00a0\u00a0in the last column to adjust for the newly inserted column. You should change \u00a0\u00a0the letter in each formula from b <\/em>to \u00a0\u00a0c.<\/strong> Note that the formula will change, but the results \u00a0\u00a0remain the same. Change the calorie count for Barbecue Chicken Pizza<\/em> to 550<\/strong>. Update the formula \u00a0\u00a0field in the next cell to reflect the new amount for calories remaining.<\/p>\n

\u00a0<\/p>\n

Apply a table style \u00a0\u00a0of Grid Table 5 Dark \u2013 Accent 6 (row 5, column 7 under Grid Tables). Select \u00a0\u00a0text in row 1 (but not the merged cell) and choose Align Center alignment. \u00a0\u00a0Apply Align Center alignment to all numbers in the last two columns.<\/p>\n

\u00a0<\/p>\n

Center the table on \u00a0\u00a0the page horizontally. Select the first column. Select the first double line \u00a0\u00a0style shown (click the Line Style dropdown arrow, not Border Styles) and a \u00a0\u00a0line weight of \u00bd pt. Select a pen color of Green Accent 6. Apply the border \u00a0\u00a0selection to all borders of the selected column.<\/p>\n

\u00a0<\/p>\n

Place the insertion \u00a0\u00a0point at the end of the document (after Download \u00a0\u00a0the Fresh! app from your friends at)<\/em>. Press SPACEBAR. Click the Mailings \u00a0\u00a0tab and begin a mail merge, choosing to create letters and selecting recipients \u00a0\u00a0from an existing list. You will use the Access database, Fresh App Contacts.accdb. <\/em>Note, Mac users will use the text file, \u00a0\u00a0Fresh App Contacts.txt<\/em>. Edit the \u00a0\u00a0recipient list and sort by Grocery Name in ascending order.<\/p>\n

\u00a0<\/p>\n

Insert a merge field \u00a0\u00a0of Grocery_Name.<\/em> Preview the \u00a0\u00a0results and finish the merge of all records. Select and copy all text in the \u00a0\u00a0new document. Display the original document, move to the end of the document \u00a0\u00a0(after Download the Fresh! app from \u00a0\u00a0your friends at Associated Grocers<\/em>), and insert a page break. Paste the \u00a0\u00a0copied text, resulting in a 6-page document.<\/p>\n

\u00a0<\/p>\n

Save and close Exp19_Word_Ch03_ML2_Fresh.docx<\/em>. Close \u00a0\u00a0all other open documents without saving. Submit Exp_Word_Ch03_ML2_Fresh.docx <\/em>as directed.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u00a0\u00a0 Exp19_Word_Ch03_ML2_Fresh Word Chapter 3 Mid-Level 2 – Fresh\u00a0 Exp19 Word Ch03 ML2 Fresh \u00a0\u00a0 Project Description: You are preparing a one-page flyer promoting a meal planning service and app. The flyer includes information, some of which is shown in a table, describing the new service. You will merge the flyer with a data source […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-104494","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/104494","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=104494"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/104494\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=104494"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=104494"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=104494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}