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