New Perspectives Word 2019 | Module 3: End of Module Project 2

To Get this Solution Contact us on Email and WhatsApp is given in Video
WhatsApp no : +923114151799
Email address: [email protected]

1. You work in the Financial Affairs office of Milton University and are completing the final draft of the university's annual report.

Change the hyphenation option so the document hyphenates automatically.
2. In the list after the "By the Numbers" heading, demote the paragraphs beginning "About 90 percent…" and "For families with incomes…" by one level. Promote the paragraph "Sustainability" by one level.
3. On page 2, in the blank paragraph in the "Financial Highlights" section, insert a table with 3 columns and 4 rows, and then enter the data shown in Table 1.
Table 1: Financials

Item 2020 2021
Assets $60 $70
Endowment $20 $30
Facilities $50 $50

4. Sort the table after the "Scholarship Campaign" heading in ascending order by the "Contributor" column. Delete one of the duplicate "Friends" rows. In the blank cell of the Amount column, insert a formula that sums the values above the cell, and then resize column A (the "Contributor" column) to its best fit.
5. Align the text in the "Amount" cell (cell B1) using the Align Top Center option. Align the dollar amounts in the "Amount" column (cells B2 to B6) using the Align Top Right option.
6. In the table after the "New Scholarships" heading, insert a column to the right of the "Annual Amount" column and enter the data shown in Table 2.
Table 2: New Table Column

Undergraduate
#samsimnetsolution
#Excel Module 3 SAM End of Module Project 2 Milton University
#ExcelModule3SAMEndofModuleProject2MiltonUniversity
#Excel_Module_3_SAM_End_of_Module_Project_2_Milton_University
#samsimnetsolution
#cengage
#NP
#samsimnetsolution
#NP_WD19_EOM3-2_FirstLastName_1.docx
#NP_WD19_EOM3-2_FirstLastName_1.docx
#NP_WD19_EOM3-2
#samsimnetsolution
#EX19
#samsimnetsolution
#Excel Module 3 SAM End of Module Project 2
#ExcelModule3SAMEndofModuleProject2
#Excel_Module_3_SAM_End_of_Module_Project_2
#samsimnetsolution
#Excel Module 3: End of Module Project 2
#ExcelModule3EndofModuleProject1
#Excel_Module_3_End_of_Module_Project_2
#samsimnetsolution
#Milton University
#Milton University
#Milton University
#samsimnetsolution
#PERFORM CALCULATIONS WITH FORMULAS AND FUNCTIONS
#PERFORMCALCULATIONSWITHFORMULASANDFUNCTIONS
#PERFORM_CALCULATIONS_WITH_FORMULAS_AND_FUNCTIONS
#samsimnetsolution
#New Perspectives Excel 2019 Module 3 End of Module Project 2
#New_Perspectives_Excel_2019_Module_3_End_of_Module_Project_2
#NewPerspectivesExcel2019Module3EndofModuleProject2
#samsimnetsolution
#Shelly Cashman Excel 2019 Module 3 End of Module Project 2
#Shelly_Cashman_Excel_2019_Module_3_End_of_Module_Project_2
#ShellyCashmanExcel2019Module3EndofModuleProject2
#samsimnetsolution



7. Apply the List Table 4—Accent 1 table style to the "New Scholarships" table. Remove the First Column table style option. Add a Right border to the "Scholarship" and "Annual Amount" columns, and then change the color of the borders to Blue-Gray, Accent 1.
8. On each line of the list after "Endowed Professorships" heading, set a 4.0" left tab stop with leader option 2 (the dotted leader). Press TAB to replace the space between the word "Professorship" and the department name in the list.
9. Insert the Slice 1 header, apply the Different First Page option for the header, and then close the Header & Footer Tools.
10. Insert a cover page using the built-in Slice (Dark) style. Use Annual Report to replace the Document Title placeholder, and use Milton University to replace the Document Subtitle placeholder.

New Perspectives Word 2019

Module 3 End of Module Project 2

NP_WD19_EOM3-2

Enhancing a Report

Milton University Word Project

Annual Report Word 2019 Project

#NewPerspectives

#WordModule3

#EOM3Project2

#SAMProject or #SAM

#EnhancingAReport