A B 1 Study Hours Aids 2 3 4 Association Maps 6 Que Cards 8 Check Lists Prediction 4 5 5 Association Maps 6 072 point 10 Que Cards Pick the IF statement for column C (located in C2) that enters "Successful" if study hours are at least 5 hours and Association Maps are used as study aids. -IF(AND(A2 Which of the following is NOT a valid range scope? Workbook Single Worksheet Multiple Worksheets All of the above 3 Product 2 $ 64.16 $ 85.33 4 Wholesale Price Product 3 $ 76.87 $ 102.24 5 Product 4 $ 41.61 $ 55.34 6 Product 5 $ 34.15 $ 45.42 7 Retail Price Product 6 $ 37.15 $ 49.41 8 Product 7 $ 81.72 $ 108.69 9 Product 8 $ 32.41 $ 43.11 10 Product 9 $ 77.81 $ 103.49 11 Product 10 $ 62.82 $ 83.55 Product 11 $ 28.13 $ 37.41 Product 12) $ 31.82 $ 42.32 121 13 Which VLOOKUP formula in cell A5 will find a wholesale price based on a Product selected in cell A2? =VLOOKUP($A$2,$A$2:$E$13,2,FALSE) -VLOOKUP($A$2,$C$2:$E$13,2.FALSE) O-VLOOKUP($A$2,$B$2:$E$13,3,FALSE) All the above None of the above A B C D E F G H K 1 Choose a Color Table of Winning Numbers 2 Bleu Color 9-Jan 16-Jan 23-Jan 30-Jan 6-Feb 13-Feb 20-Feb 27-Feb 3 Aqua 33 5 41 20 42 13 35 47 4 Blue 31 2 13 13 38 23 40 46 5 Winning Number on Feb 13 Gray 37 34 21 6 10 15 20 35 6 Green 45 47 37 12 43 18 37 23 7 Orange 19 16 5 6 10 21 31 37 8 Pink 8 28 47 32 25 44 2 39 9 Purple 17 3 5 24 30 20 43 12 10 Red 16 40 35 37 7 20 14 3 11 12 Yellow 15 23 30 22 33 14 45 37 =VLOOKUP(A2,$C$2:$K$12,7,FALSE) The formula in cell A6 is shown. What will we see in A6? #NA (error) 23 40 40 44