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. TRUE FALSE 2 / 10 With reference to below picture, what would be the answer for =VLOOKUP("A1241",$A$1:$B$8,2,0) B #N/A A Blanks 3 / 10 What would be the answer for =LOOKUP(48,{0,40,70,80,90},{"F","D","C","B","A"}) C B F D 4 / 10 The below formula does what? =EOMONTH(TODAY(),0) Gives the last date of the current month Gives the first date of the current month Gives the first date of the next month Gives Error 5 / 10 Referring to below picture, what would be the answer for =A4:F4 D1:D6 15 0 28 17 6 / 10 With reference to below picture, what would be the answer for =INDEX($B$2:$F$6,3,4) 15 12 99 10 7 / 10 What would be the answer for =CHOOSE(3,0,8,11,3,12,56,9) 11 3 0 9 8 / 10 Name Manager is found in which tab? Data Tools Formulas Home 9 / 10 Referring to below picture, what would be answer to =VLOOKUP("A125.1",$A$2:$B$8,2) #N/A B C A 10 / 10 What would be the answer for =LOOKUP(1000,{0,40,70,80,90},{"F","D","C","B","A"}) A 0 B F Your score is LinkedIn Facebook Twitter Retake quiz Exit
