Excel Quiz 11 Posted on May 2, 2015September 25, 2021 by Vijay A. Verma Quiz 11 This is a general quiz to test your Excel knowledge. There are a total of 10 questions to answer. To pass, you need to answer at least 6 questions correctly. Please fill in your Name & Email to take the Quiz (Name and E Mail are not shared with anybody else. E Mail is used to mail the pdf certificate to you when you pass) 1 / 10 The syntax of VLOOKUP is VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). If range_lookup is either TRUE or omitted, the first column of table_array must be sorted in ascending order. FALSE TRUE 2 / 10 Referring to below picture, what would be the answer for =A4:F4 D1:D6 0 28 17 15 3 / 10 What would be the answer for =CHOOSE(3,0,8,11,3,12,56,9) 9 3 0 11 4 / 10 What would be the answer for =LOOKUP(1000,{0,40,70,80,90},{"F","D","C","B","A"}) B A F 0 5 / 10 Name Manager is found in which tab? Home Data Tools Formulas 6 / 10 With reference to below picture, what would be the answer for =INDEX($B$2:$F$6,3,4) 10 12 99 15 7 / 10 With reference to below picture, what would be the answer for =VLOOKUP("A1241",$A$1:$B$8,2,0) Blanks B A #N/A 8 / 10 The below formula does what? =EOMONTH(TODAY(),0) Gives Error Gives the first date of the current month Gives the first date of the next month Gives the last date of the current month 9 / 10 What would be the answer for =LOOKUP(48,{0,40,70,80,90},{"F","D","C","B","A"}) F D B C 10 / 10 Referring to below picture, what would be answer to =VLOOKUP("A125.1",$A$2:$B$8,2) #N/A B C A Your score is LinkedIn Facebook Twitter Retake quiz Exit
