Excel Module 5 SAM Project B Min Jee Woo Artwork | Excel Module 5 SAM Project 1b

#Excel_Module_5_SAM_Project_B #ExcelModule5SAMProjectB #NP #EX19 #NP_EX19_5b #ExcelModule5SAMProject1b #Excel_Module_5 #ExcelModule5 #Excel_Module_5_SAM_Project_1b #NP_EX19_5b_FirstLastName_1.xlsx #Min_Jee_Woo_Artwork #MinJeeWooArtwork




Contact Me

Email :[email protected]
WhatsApp:+923096000718
WhatsApp Direct Chat : https://wa.link/sspsfs



#Excel Module 5 SAM Project B
#Excel_Module_5_SAM_Project_B
#ExcelModule5SAMProjectB
#Excel Module 5 SAM Project 1b
#Excel_Module_5_SAM_Project_1b
#ExcelModule5SAMProject1b
#Excel Module 5 SAM Project B Min Jee Woo Artwork
#Excel_Module_5_SAM_Project_B_Min_Jee_Woo_Artwork
#ExcelModule5SAMProjectBMinJeeWooArtwork
#New Perspectives Excel 2019 Module 5 SAM Project 1b
#New_Perspectives_Excel_2019_Module_5_SAM_Project_1b
#NewPerspectivesExcel2019Module5SAMProject1b
#shelly cashman excel 2019 module 5 sam project 1b
#shellycashmanexcel2019module5samproject1b
#shelly_cashman_excel_2019_module_5_sam_project_1b
#Min Jee Woo Artwork
#Min_Jee_Woo_Artwork
#MinJeeWooArtwork
#GENERATING REPORTS FROM MULTIPLE WORKBOOKS
#GENERATINGREPORTSFROMMULTIPLEWORKBOOKS
#GENERATING_REPORTS_FROM_MULTIPLE_WORKBOOKS
#NP_EX19_5b_FirstLastName_1.xlsx
#NP_EX19_5b_FirstLastName_2.xlsx
#NP_EX19_5b
#cengage
#np
#EX19
#Cengage_Excel_Module_5_SAM_Project_B




PROJECT STEPS
1. Min Jee Woo is an artist who makes her living selling her artwork at art fairs around the Midwest. Min Jee is using an Excel workbook with multiple worksheets to summarize the sales of her artwork by fair location. She asks for your help in completing the sales information for this year. Break the external link in the worksheet, so that the formulas in the range B3:D6 of the Art Fairs worksheet are replaced with static values. Then switch to the Art Fairs worksheet.
2. In cell B5, remove the hyperlink, leaving the unlinked text "Eva Martinez" in the cell.
3. In cell D4, create a hyperlink to an email address as follows:
a. Link to the following email address: [email protected]
b. Use [email protected] as the text to display.
c. Use Contact the Gateway Art Fair organizers as the ScreenTip text.

4. In cell B10, create a hyperlink to a document describing the four art fairs as follows:
a. Link to the file Support_NP_EX19_5b_Descriptions.docx.
b. Use Art fair descriptions as the text to display.
c. Use Descriptions of the four art fairs as the ScreenTip text.
5. Edit the hyperlink in cell B9 as follows:
a. Use Online art fair calendar as the display text.
b. Use Display the calendar of art fairs in the U.S. as the ScreenTip text.
6. Min Jee wants to apply consistent formatting to the worksheets she collected from separate workbooks. Group the Chicago, St. Louis, and Minneapolis worksheets together and then make the following formatting updates:
a. Change the font size in the merged range A1:F1 to 16 point.
b. Apply the 20% - Accent 1 cell style to the merged range A2:F2.
c. Bold the values in the range A5:A8.
d. Apply the Accounting number format with two decimal places and $ as the symbol to the range B5:F9.
e. Resize the column width of columns B:F to 14. Do not ungroup the worksheets.




#NP_EX19_1a_FirstLastName_1.xlsx
#NP_EX19_1b_FirstLastName_1.xlsx
#NP_EX19_2a_FirstLastName_1.xlsx
#NP_EX19_2b_FirstLastName_1.xlsx
#NP_EX19_3a_FirstLastName_1.xlsx
#NP_EX19_3b_FirstLastName_1.xlsx
#NP_EX19_4a_FirstLastName_1.xlsx
#NP_EX19_4b_FirstLastName_1.xlsx
#NP_EX19_5a_FirstLastName_1.xlsx
#NP_EX19_5b_FirstLastName_1.xlsx

#NP_EX19_6a_FirstLastName_1.xlsx
#NP_EX19_6b_FirstLastName_1.xlsx
#NP_EX19_7a_FirstLastName_1.xlsx
#NP_EX19_7b_FirstLastName_1.xlsx
#NP_EX19_8a_FirstLastName_1.xlsx
#NP_EX19_8b_FirstLastName_1.xlsx
#NP_EX19_9a_FirstLastName_1.xlsx
#NP_EX19_9b_FirstLastName_1.xlsx
#NP_EX19_10a_FirstLastName_1.xlsx
#NP_EX19_10b_FirstLastName_1.xlsx
#NP_EX19_11a_FirstLastName_1.xlsx
#NP_EX19_11b_FirstLastName_1.xlsx
#NP_EX19_12a_FirstLastName_1.xlsx
#NP_EX19_12b_FirstLastName_1.xlsx



#NP_EX19_1a
#NP_EX19_1b
#NP_EX19_2a
#NP_EX19_2b
#NP_EX19_3a
#NP_EX19_3b
#NP_EX19_4a
#NP_EX19_4b
#NP_EX19_5a
#NP_EX19_5b
#NP_EX19_6a
#NP_EX19_6b
#NP_EX19_7a
#NP_EX19_7b
#NP_EX19_8a
#NP_EX19_8b
#NP_EX19_9a
#NP_EX19_9b
#NP_EX19_10a
#NP_EX19_10b
#NP_EX19_11a
#NP_EX19_11b
#NP_EX19_12a
#NP_EX19_12b



#ExcelModule1SAMProject1aTabulaInsuranceAgency
#ExcelModule1SAMProject1bCityofNewMonroe
#ExcelModule2SAMProject1aBergamotUrgentCareClinic
#ExcelModule2SAMProject1bVillanovaTechnologyGroup
#ExcelModule3SAMProject1aScrubJayPeripherals
#ExcelModule3SAMProject1bMedSightInstruments
#ExcelModule4SAMProject1aAlanisParksDepartment
#ExcelModule4SAMProject1bStuartsBank
#ExcelModule5SAMProject1aNarbonneSuites
#ExcelModule5SAMProject1bMinJeeWooArtwork