Excel Quiz 52 Posted on May 27, 2021September 26, 2021 by Vijay A. Verma Quiz 52 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 What will be the result of following function? =SUMPRODUCT((ROW(A1:A10))) 55 1 10 100 2 / 10 Which of the following is an upcoming Excel function (as on 19-Jan-20, it is part of Insider only not rolled out to general public versions)? YLOOKUP XLOOKUP IFS XOR 3 / 10 What shortcut is used to confirm Array formulas? CTRL+SHIFT+ESC CTRL+SHIFT+ENTER CTRL+ENTER CTRL+ALT+ENTER 4 / 10 Which is not an Excel function? OR NOR AND NOT 5 / 10 Which Excel tool can be used to solve equations? Inquire Spreadsheet Compare Solver Analysis Toolpak 6 / 10 Which function can be used to calculate Principal + Compound Interest? FV CMP PV CRETURN 7 / 10 Which formula will display 10.54 as 10 (assume 10.54 is in A2)? =FLOOR(A2,10) =ROUNDDOWN(A2,0) =INT(A2) All of the above 8 / 10 What would be the answer for following formula =1+x 1 #VALUE 0 #NAME? 9 / 10 Which is not part of Excel? Power Chart Power Query Power Pivot Power Map 10 / 10 Which of the following is part of Home tab? Sort & Filter Conditional Formatting Wrap Text All of the above Your score is LinkedIn Facebook Twitter Retake quiz Exit
