only answer if knowledgeable on excel!

Partial Question 2 0.67 / 1 pts Which of the following statements are true about VLOOKUP: Lookup Values must be in the furthest left column of the Lookup Range Lookup Values for an Approximate Match must be in ascending order. Lookup Values for an Exact Match can be in any order. The Lookup Values cannot be negative values. Incorrect Question 3 0/1 pts What formula is entered into cell D3 in order to achieve this result (0%)? Dom UR Trade Sports Gradec ON de Trade 300.00 . 77.00 antes NIS INS INS 000 100 100 1943 IN . 13.00 100 6 30 De ms DOS OTS worament MS SI mens s os NIS INS 15.00 . U IN 3 11 14 9.00 6 NE NE =VLOOKUP(A3,$G$3:$H$8,2) =VLOOKUP(A3,$G$3:$H$8,2,FALSE) =VLOOKUP(B3,$G$3:$H$8,2) =VLOOKUP( G4,$G$3:$H$8,1) 27/2.. Incorrect Question 4 0/1 pts ents I just entered 622 into cell 04 and j.adder@ace.com appeared in cell E4. What is the formula in cell E4? E4 A B D 1 2 3 4 5 6 7 ID 622 Email Ladderace.com 9 10 11 12 13 14 15 16 17 ID First 610 Janet 798 Steven 841 Evelyn 886 Marilyn 622 Jonathan 601 Adrian 869 Julle 867 Erica 785 Harold 648 Sharyn Last Farley Batista Monet Bradley Adder Birt Irons Email Jofarley@ace.com s batistance.com e monetace.com m bradley@ace.com Ladderace.com birtace.com rons@ace.com etan@ace.com h.clayton@ace.com castor@ace.com Department Fulfillment Sales Fulfillment Fulfillment Marketing Engineering Marketing Fulfillment Fulfillment Support rse Tan Clayton Castor ry ting =VLOOKUP(D4,88:F174,FALSE) =VLOOKUP(E4,38:F17,4,FALSE) =VLOOKUP(D4,88:F17,4 TRUE) =VLOOKUP(D4,A8:B17.4.FALSE)