Defi Text AutoSum Recently Financial Lagical Used Date & Time Lookup & Math & Reference More Functions E Crew Trig C B D E F H ID Value Item 610 E-mail 648 Department 883 Department 622 Last For this sheet, you will use the Problem 1 table on the sheet named "Data. This table provides an ID and item information for employees. You will need to create range names. You may use working columns if you would like. You will use the MATCH and INDEX functions for this problem. Insert function(s) in cell E4 to provide the appropriate value from the table based on the ID provided (col C) and item requested (col D) as presented in the table on the sheet Data." Copy this function to cells ES:E7. This function must be copyable. All formulas/functions must be copyable and avoid hard coding 10 points Sro Prob 2 Data Prob 3 Data 3A Data 3 B Prob4 Autosave Exam 3 @tu. Home Draw Page Layout Insert Formulas Review Data View Tell me Define Name fx Text Insert Function AutoSum Recently Financial Logical Used Date & Lookup & Math & Time Reference Trig More Functions E create from Selection 82 E G Degree 1 Major 2 History Political Science 4 Accounting s Sociology 7 9 10 For this sheet, you will use the Problem 2 table on the sheet named "Data." You may use working columns it seeded/desired Enter a function() within call that will use the table on sheet Data and the major Information in column A to provide the Degree name. You will need to create a range name for this sheet. Copy the function in cell B2 to cells 13.05. 12 13 14 15 16 17 18 19 20 21 22 23 Format as appropriate All formulas/functions must be copyable and void hard coding. 10 points Accounting 35 LA Problem 2 Data Criminal Biolo Chemistry Education History BA RS BA BA HA REEDC DORN ELIOT ELIOT CATHE Nursing AS FALILT Psycholon Sociolo BS BA LA REEDC 24 25 Major 26 Degree 27 Residence Hall 28 29 30 31 32 33 34 35 36 37 Prob 1 Prob Data Prob 3 Data 3A Data 3B Prob4 Prob 4 Dat Ready Circular References Defi Text AutoSum Recently Financial Lagical Used Date & Time Lookup & Math & Reference More Functions E Crew Trig C B D E F H ID Value Item 610 E-mail 648 Department 883 Department 622 Last For this sheet, you will use the Problem 1 table on the sheet named "Data. This table provides an ID and item information for employees. You will need to create range names. You may use working columns if you would like. You will use the MATCH and INDEX functions for this problem. Insert function(s) in cell E4 to provide the appropriate value from the table based on the ID provided (col C) and item requested (col D) as presented in the table on the sheet Data." Copy this function to cells ES:E7. This function must be copyable. All formulas/functions must be copyable and avoid hard coding 10 points Sro Prob 2 Data Prob 3 Data 3A Data 3 B Prob4 Autosave Exam 3 @tu. Home Draw Page Layout Insert Formulas Review Data View Tell me Define Name fx Text Insert Function AutoSum Recently Financial Logical Used Date & Lookup & Math & Time Reference Trig More Functions E create from Selection 82 E G Degree 1 Major 2 History Political Science 4 Accounting s Sociology 7 9 10 For this sheet, you will use the Problem 2 table on the sheet named "Data." You may use working columns it seeded/desired Enter a function() within call that will use the table on sheet Data and the major Information in column A to provide the Degree name. You will need to create a range name for this sheet. Copy the function in cell B2 to cells 13.05. 12 13 14 15 16 17 18 19 20 21 22 23 Format as appropriate All formulas/functions must be copyable and void hard coding. 10 points Accounting 35 LA Problem 2 Data Criminal Biolo Chemistry Education History BA RS BA BA HA REEDC DORN ELIOT ELIOT CATHE Nursing AS FALILT Psycholon Sociolo BS BA LA REEDC 24 25 Major 26 Degree 27 Residence Hall 28 29 30 31 32 33 34 35 36 37 Prob 1 Prob Data Prob 3 Data 3A Data 3B Prob4 Prob 4 Dat Ready Circular References