New Perspectives Excel 365 | Module 2: End of Module Project 1 Eugene State College скачать в хорошем качестве

New Perspectives Excel 365 | Module 2: End of Module Project 1 Eugene State College

If you directly want to get the project from us then contact us on our Whatsapp. Link is given here, Whatsapp Contact Link: https://api.whatsapp.com/message/4B6N... Whatsapp Number: +919116641093 Gmail Id: singhal.agrawal.bharati@gmail.com We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English. New Perspectives Excel 365 | Module 2: End of Module Project 1 Eugene State College Formatting Workbook Text and Data PROJECT STEPS You work in the Development Office for Eugene State College in Eugene, Oregon. Your boss Karim created a workbook to analyze the donations needed to fund a building expansion and to identify the prospects who could provide the donations. He asks you to format the workbook to make it more appealing and easy to use. Start by changing the theme of the workbook to the Office 2013-2022 Theme to use the same theme as in other Development Office workbooks. On the Capital Campaign worksheet, merge and center the range A1:F1. Apply the custom DevHeading cell style to the merged cell to format it as the worksheet title. Merge and center the range A2:F2. Apply the custom DevSubheading cell style to the merged cell to format it as the worksheet subtitle. Karim wants you to clearly separate the campaign start date and goal information from the table of gift data. In the range A4:B5, apply the Note cell style. In the range A4:A5, apply italic to the text and then right-align it. For cell B4, change the date format to day-month (e.g., 12-Oct). Karim also wants you to format the table of gift data to improve its appearance and identify the numeric data at a glance. In the range A7:F7, center and bold the text, and then change the font color to Blue, Accent 1, Darker 50% (5th column, 6th row of the Theme Colors palette) to format the text as headings. Merge and center the range A8:A10 to indicate the text applies to data in rows 8–10. Copy the formatting of the merged cell in the range A8:A10, then paste the formatting in the range A11:A16 to create two more merged cells. In the range B8:B16, apply the Currency number format with the $ symbol and no decimal places. Copy this format to the range D8:E16 to show that it contains whole dollar amounts. In the range C8:C16, apply the Number number format with no decimal places, and then center the range horizontally to balance the space in the column. In the range F8:F16, apply the Percentage number format with one decimal place. Change the background color of the range A8:F10 to Blue-Gray, Text 2, Lighter 80% (4th column, 2nd row of the Theme Colors palette). Change the background color of the range A11:F13 to White, Background 1, Darker 5% (1st column, 2nd row of the Theme Colors palette). Copy the formatting of the range A8:F10, and then paste the formatting in the range A14:F16 to create an effect of alternating background colors. In the range A7:F16, add a border around all cells using the All Borders option to make the data more legible. Go to the Prospects worksheet. Karim asks you to begin this worksheet with the same title and subtitle as on the Capital Campaign worksheet. Copy the content and formatting from the range A1:F2 in the Capital Campaign worksheet, and then paste them in the range A1:F2 in the Prospects worksheet. Karim wants you to format the cells and numbers in the rest of the worksheet so the data is easier to interpret. In the range B5:C5, apply the Accounting number format with no decimal places to indicate the range contains dollar amounts. In the ranges B6:C12 and D5:E13, apply the Comma number format with no decimal places to make the numbers easier to decipher. Copy the formatting of the merged cell E5 to the range E7:E12 to clarify that the cumulative data applies to two rows of prospects. In the range F5:F6, merge and center the content and then center it vertically to match the formatting of other text in the Recommendation column. Finally, Karim asks you to replace a term with one the Development Office prefers. Find each instance of the word "Donors" and use Gifts as its replacement. #samprojects #cengageassignments #NP_EX365_EOM2-1 #NP_EXCEL #excel_assignments #excel_sam_projects #Module2EndOfModuleProject1 #eugene_state_college #new_perspectives_excel #NP_EX365_EOM2-1_FirstLastName_1.xlsx #NP_EX365_EOM2-1_FirstLastName_2.xlsx