Search no File Home Insert Draw Design Layout References Mailings Review View Help O PROTECTED VIEW Be carefulles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing x ctic Do 2016 Pro gro 1116 YO16_XL_CH09_GRADER_PS1_HW - Sports Store Customers 1.3 Project Description: Joe Nelson has a small sports equipment store that has a growing list of customers. The other supervisors have been saving customer information in different formats Joe would like to have all the data in an Excel spreadsheet. He has asked you to take on the task of getting the data together and putting them in the formats he would like for his planned marketing effort Steps to Perform Points Possible Step Instructions 0 1 15 2 3 8 Start Excel Open the downloaded workbook named chog grader_M_start to Save the fle with the name eschosgrader M lastust using your last and first name necessary enable content Import the data from the query Customer in the hos Sports Customers acc) database into the CustomerDatabase worksheet in cel A2 In cells C20.type the following column headings Clean Home, First Name, Last Name Street Address City State, Pull Name In cel C3, use the CLEAN and TRM functions to remove any nonprintable characters and extra space from the name in column A Resee the columnas neded to fit the contents Inclou use the RIGHT, LEN, FIND Actions to erad the first name from column Use the PROPER function to ensure that all fiestrames are in the appropriate case. Rece the columnas needed to fit the contents 4 10 5 12 6 12 In cel E, use the LEFT FINDunction to extrad the last name from colm C Use the PROPER function to ensure that tastrames are in the appropriate e Reste the colom as beeded to the contents In cell F3, the LEFT and FIND Runction to trad the street address troncom Use the PROPER Lunction to ensure that the names are in the appropriate case. Res.ce the columnasheeded to the contents 7 12 8 15 3 incel Gue the MD, LEN, FINO fonction to extra testy name from the address in com. Retete con seded to the contents In cell 10, the RIGHT function to trad the state from the rest in cotone B. Rize Become a need to the con In cause contention to put the customer festname and attrame together wa in between Rescue the columnasted to fit the Save the workbook Close the book Este titra workbook as directed 10 11 0 Total Points 10 w Pro Auto On Table Tools 05h00 grader. 1. Thoubokhang Saved Review View Developer Data Mining Fe Home Draw Page Layout Formula D Analytic Solver Design XC Wwwpled (Caltri - - A BAA Format Painter Closed $ - % hpLqWhy Skby Conditional Formats Normal had Formatting Yoble- fond A Sol M N state Full Na 1 2 Camera 1, effery 4 Mendoza, les Swanson, Madison th, Olivia 7 Joseph wer, TN Rodrigues, Wild 10 RING 11 Ronald 12 tabelle 13 14 G Joe's Sports Equipment Supply Add Clean CN Last Street City 10 ATKINS, MM 3862 ANNETTE SE, NM 250SLER , Tome NM 5 BARONIK d. Pa NM 1967 St, Cedar Cres NM MY TALONES NU 15 MIDDEN Ave, San Side NM LAKE HOOD WOONM 391 BRIDGET AV INN 1711 SETTLERS ON 13 17 20 Search no File Home Insert Draw Design Layout References Mailings Review View Help O PROTECTED VIEW Be carefulles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing x ctic Do 2016 Pro gro 1116 YO16_XL_CH09_GRADER_PS1_HW - Sports Store Customers 1.3 Project Description: Joe Nelson has a small sports equipment store that has a growing list of customers. The other supervisors have been saving customer information in different formats Joe would like to have all the data in an Excel spreadsheet. He has asked you to take on the task of getting the data together and putting them in the formats he would like for his planned marketing effort Steps to Perform Points Possible Step Instructions 0 1 15 2 3 8 Start Excel Open the downloaded workbook named chog grader_M_start to Save the fle with the name eschosgrader M lastust using your last and first name necessary enable content Import the data from the query Customer in the hos Sports Customers acc) database into the CustomerDatabase worksheet in cel A2 In cells C20.type the following column headings Clean Home, First Name, Last Name Street Address City State, Pull Name In cel C3, use the CLEAN and TRM functions to remove any nonprintable characters and extra space from the name in column A Resee the columnas neded to fit the contents Inclou use the RIGHT, LEN, FIND Actions to erad the first name from column Use the PROPER function to ensure that all fiestrames are in the appropriate case. Rece the columnas needed to fit the contents 4 10 5 12 6 12 In cel E, use the LEFT FINDunction to extrad the last name from colm C Use the PROPER function to ensure that tastrames are in the appropriate e Reste the colom as beeded to the contents In cell F3, the LEFT and FIND Runction to trad the street address troncom Use the PROPER Lunction to ensure that the names are in the appropriate case. Res.ce the columnasheeded to the contents 7 12 8 15 3 incel Gue the MD, LEN, FINO fonction to extra testy name from the address in com. Retete con seded to the contents In cell 10, the RIGHT function to trad the state from the rest in cotone B. Rize Become a need to the con In cause contention to put the customer festname and attrame together wa in between Rescue the columnasted to fit the Save the workbook Close the book Este titra workbook as directed 10 11 0 Total Points 10 w Pro Auto On Table Tools 05h00 grader. 1. Thoubokhang Saved Review View Developer Data Mining Fe Home Draw Page Layout Formula D Analytic Solver Design XC Wwwpled (Caltri - - A BAA Format Painter Closed $ - % hpLqWhy Skby Conditional Formats Normal had Formatting Yoble- fond A Sol M N state Full Na 1 2 Camera 1, effery 4 Mendoza, les Swanson, Madison th, Olivia 7 Joseph wer, TN Rodrigues, Wild 10 RING 11 Ronald 12 tabelle 13 14 G Joe's Sports Equipment Supply Add Clean CN Last Street City 10 ATKINS, MM 3862 ANNETTE SE, NM 250SLER , Tome NM 5 BARONIK d. Pa NM 1967 St, Cedar Cres NM MY TALONES NU 15 MIDDEN Ave, San Side NM LAKE HOOD WOONM 391 BRIDGET AV INN 1711 SETTLERS ON 13 17 20