Blog

City of Floma Audit Report Your skills with Microsoft Word are highly regarded by the partners in the consulting firm that hired you. You are tasked with finishing the 2018 annual audit report for the City of Floma. The audit report has been completed by consultants and the lead consultant wrote an executive summary. You will insert the executive summary in the report, format the report professionally and prepare a mail merge to the city council members that includes a link to the report. a. Open and save it as . b. Begin by inserting a cover page which serves as the city’s document standard. Choose the cover page. Type in the placeholder. Delete the , , and placeholders. Type in the placeholder. c. Change the document’s color scheme to . d. Delete the first two paragraphs on page two. e. In the blank paragraph under the heading , insert the text from the document . Delete the blank paragraph above the heading . f. Create a header with centered and right aligned. Create a bottom paragraph border in . g. Insert an page number. Ensure that the header and footer on the first page are different and have no text in them. h. Modify the line spacing of the style to . Add a first line indent of . i. Modify the styles and to remove the first line indent. j. Insert a blank paragraph at the end of the document. Select the heading on page three and the table underneath and move them to the bottom of the document. Insert a page break before the heading . k. Select the table under the heading and apply the style . l. Add a table caption below the table with the text . The label is added by Word. m. Apply the table style. n. Replace the hyphen in Full-time in row 1, column 2 with a no

n-breaking hyphen. o. Bottom left align the text in row 1, column 1. Bottom right align the text in all but the first column of row 1. p. Adjust the width of column 1 so that the words do no break across two lines. Equally distribute the width of the other columns. q. Merge the cells in columns 1 through 4 in the bottom row of the table. Type the text (include the colon) in the merged cell. Right-align the text. r. Insert a formula in row 4, column 5 to calculate the total new hires. Delete the comment left by . s. Review the document for spelling and grammar errors. Ignore all occurrences of the word . t. Insert a Table of Contents before the heading . Choose . Modify the styles and to remove the first line indent. u. Insert the following citation before the period ending the sentence in the second paragraph below the heading : Corporate Author: Name of Web Page: Year: Month: Day: URL: v. Share the audit report document online and get a link. w. Open and save it as . x. Paste the link to the audit report document at the end of the line that starts with . y. Conduct a mail merge using the sheet of the Excel file as the data source. z. Delete the word on the first line, and then insert a greeting line using the format . Match the field to . Preview the results. aa. At the end of the letter, add two blank paragraphs. Leave the first blank. Type , insert a line break, and then type . bb. Complete the merge of the document producing a new document with four pages. Save the merged document as . cc. Save and close all files. Based on your instructor’s directions, submit the following: w00_cumexam_LastFirst (the audit report) w00_cumexam_letter_LastFirst (the mail merge document)