Скачать или смотреть Shelly Cashman Excel 365/2021 | Module 7: SAM Project 1b | Chisholm-Grant Academy

Shelly Cashman Excel 365/2021 | Module 7: SAM Project 1b | Chisholm-Grant Academy #shellycashman

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/4B6NMKKBK...

Whatsapp Number:
+919116641093
+918005564456

Gmail Id:
[email protected]

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.

PROJECT STEPS
1. Clare Seeley is the chair of the Class Reunion committee for the 2015 class of Chisholm-Grant Academy in Hanover, New Hampshire. She is preparing a draft of a workbook to send to classmates involved in planning the reunion and asks for your help in importing data and adding other content to the workbook.

Go to the Reunion Organizers worksheet. Change the formatting of cell D4 and use the tools on the Shape Format tab to modify the WordArt containing the worksheet title, "Chisholm-Grant Academy", as follows to coordinate these elements with the rest of the worksheet:
a. Change the text fill color of the WordArt to Green, Accent 1.
b. Change the text outline color of the WordArt to Dark Green, Accent 2.
c. Copy the formatting from cell C4 to cell D4.
2. The worksheet should list information about the reunion committee members, which is contained in a webpage.

Import data from the webpage as follows:
a. From the Data tab, use 'From HTML' to open the Support_EX365_2021_7b_Mac_Committees.html webpage as a table in a new workbook.
b. Copy the table, with column headers included, from the new workbook. In the Reunion Organizers worksheet, paste the table in cell G12. Close the new workbook without saving.
c. Format the pasted data in the range G12:L19 as a table using White, Table Style Light 8. (Hint: Make sure "My table has headers" is checked.)
3. In the new table, change some data to reflect updates in the committees:
a. Delete the table row for Kayla Chen because she can no longer serve on the Food and Beverage committee.
b. Find the text "Registration" and replace it with Welcome to use the correct committee name.
4. Clare wants to list the committee information in the range A5:E10. The webpage table separated the first and last names, but Clare wants to list the full name on the Reunion Organizers worksheet.

List the first and last names of each committee member in a single cell as follows:
a. In cell A5, enter a formula using the CONCAT function that displays the first name shown in cell G13 followed by a space (" ") and then the last name shown in cell H13.
b. Fill the range A6:A10 with the formula in cell A5 to list the full names of the remaining committee members.
5. Incorporate the imported data in the range B5:E10 as follows:
a. Copy the Committee data from the range I13:I18 and paste only the values in the range B5:B10.
b. In cell C5, enter a formula using the PROPER function to capitalize the first letter in each word in the Role text in cell J13.
c. Fill the range C6:C10 with the formula in cell C5 to list the roles of the remaining committee members.
d. In cell D5, enter a formula using the LEFT function to insert the first 3 characters on the left of cell K13. Copy the formula in cell D5 to the range D6:D10.
e. In cell E5, enter a formula using the RIGHT function to insert the last 2 characters on the right of cell L13. Copy the formula in cell E5 to the range E6:E10.
f. Resize columns A:E to their best fit, resize column G to 19.00, and resize column H to 14.00.
g. Hide rows 12–18 so that the worksheet does not display duplicated data.
6. Clare already imported a budget summary on the Budget worksheet but wants to display the data in the range G5:H8 of the Reunion Organizers worksheet. She asks you to switch the rows and columns when you insert the data to fit in the range G5:H8.

Go to the Budget worksheet. Copy the data in the range A1:D2, and then transpose the rows and columns as you paste the data on the Reunion Organizers worksheet starting in cell G5.
7. In the Reunion Organizers worksheet, insert and format a picture of the organizers for the fifth class reunion as follows as motivation for the current organizers:


shelly cashman excel 2019, module 7 sam project 1b, excel excel project, shelly cashman excel 2019 module 7 sam project 1b, module 7 sam project 1b excel, excel sam project module 7, new perspectives excel 2019 module 7 sam project 1b, new perspectives excel 2019, excel 2019 module 7 sam project 1b, Module 9-12 sam capstone project 1a, Module 8 end of module project 1, Module 9-12 sam capstone project 1b