1. Question 1 Once you have completed the project, what is the formula in cell I21 on the Question tab? 1 point =IFERROR(VLOOKUP($B21,Data_Set_Clean_Ans!$B$8:$M$108,9,FALSE),”-“) =IFERROR(VLOOKUP($B21,Data_Set_Clean!$B$8:$M$108,9,FALSE),”-“) =IFERROR(VLOOKUP($B21,Data_Set_Clean!$B$8:$M$110,9,FALSE),”-“)
3. Question 3 You have been asked to supervise an intern and do not have the time to review and explain common mistakes in their data set. Which function can…
1. Question 1 What are three functions that reformat text? (See: Data Cleansing: Text Handout) 1 / 1 point Proper, Upper, Lower Proper, Mid, Lower Upper, Lower, Mid Upper,…
2. Question 2 Which text function does not allow you to select a substring from a string? 1 / 1 point Right function Find function Left function Mid function…
2. Question 2 Alex received a note that there was an update to some of the data he has been working on. What is the correct formula that Alex should…
1. Question 1 Which of the following data cleansing functions allows you to remove all spaces from a string, with the exception of single spaces between words? 1 point …
3. Question 3 Which function allows you to remove all non printable characters from text? 1 / 1 point VALUE function CLEAN function TEXT function SUBSTITUTE function …
1. Question 1 In the image of the data set below, which number represents the lookup value? 1 point Distributor ID 2. Product code 3. Month…
4. Question 4 What is the correct formula structure for completing a vLookup? 1 point =VLOOKUP (table_array,lookup_value,col_index_num, [range_lookup]) =VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) =VLOOKUP (table_array, col_index_num, table_array,…
3. Question 3 True or False HLookup is similar to VLookup – only it allows you to search for data horizontally. 1 point True False
