1 2 112 A B D 1 3 Excel for Models: INDEX + MATCH 5 INDEX + MATCH 7 INDEX + MATCH & Instruments of Choice 9 Mr. Clean 11 Individual 1 Instrument 13 Captain America Shield 14 Edward Louis Severson III Baritone Vocals 15 Michael Jordan Basketball 16 Miles Davis Saxophone 17 Mr. Clean Antibacterial Multi-Purpose Cleaner 18 Terminator Time Machine 19 Thor Hammer on what value will return using "=match(C9, C13:C19,0)" based on above excel information? Select one: A. #N/A B. Antibacterial Multi-purpose cleaner C. 5 D. None of the above D AB E F G 18 End of Month End of Previous Month End of Next Month 19 Dates 3/7/2019 3/31/2019 2/28/2019 4/30/2019 Which of the following formula can generate the date in F19 (2/28/2019) from D19? Select one: A. =EOMONTH(D19,-1) B. =EOMONTH(D19,1) C. =EOMONTH(D19,0) D. None of the above 1 2 D 2 1 3 Excel for Models: INDEX + MATCH 5 7 INDEX + MATCH INDEX + MATCH & Instruments of Choice Mr. Clean 9 11 13 14 15 Individual Captain America Edward Louis Severson III Michael Jordan Miles Davis Mr. Clean Terminator Thor I Instrument Shield Baritone Vocals Basketball Saxophone Antibacterial Multi-Purpose Cleaner Time Machine Hammer 16 17 18 19 what value will return using "=INDEX(D13:D19, MATCH(C9, C13:C19,0))" based on above excel information? Select one: A. #N/A B.5 C. Antibacterial Multi-Purpose Cleaner D. None of the above AB D H F G 9 Date Function First Day of Month End of Month 10 Dates 3/7/2019 3/7/2019 3/1/2019 3/31/2019 Which of the following formula can be used generate the date in G10 (3/31/2019) from D10? Select one: A. =DATE(YEAR(D10),MONTH(D10),DAY(D10)) B. EDATE(YEAR(D10),MONTH(D10)+1,0) C. =DATE(YEAR(D10), MONTH(D10),1) D. None of the above. 1 2 A B D 1 2 4 1 5 7 9 11 13 Excel for Models: INDEX + MATCH INDEX + MATCH INDEX + MATCH & Instruments of Choice Michael Jordan Individual Instrument Captain America Shield Edward Louis Severson III Baritone Vocals Michael Jordan Basketball Miles Davis Saxophone Mr. Clean Antibacterial Multi-Purpose Cleaner Terminator Time Machine Thor Hammer 14 15 16 17 18 19 What value will return using "=Index(D13:019,4)" based on above excel information? Select one: A. Baritone Vocals B. Shield C. Saxophone D. None of the above 1 2 12. E G 3 5 7 VLOOKUP & Numbers 9 3.60 11 Number Also Number (but Spelled) + 14 15 1.00 2.00 3.00 16 17 One Two Three Three Point Five Four Five 3.50 4.00 5.00 6.00 18 Six 19 20 21 30 31 What value will be filled in G9 using "=VLOOKUP(F9,F14:G20,2,1)" Select one: A. Four B. Three Point Five C. #N/A D. None of the above