Excel Quiz 10 Posted on April 18, 2015September 25, 2021 by Vijay A. Verma Quiz 10 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 Select the cell E6 and press SHIFT+SPACEBAR, what would happen - Row 6 is selected Nothing happens Both column E and row 6 are selected Column E is selected 2 / 10 Maximum number of columns in a worksheet 16384 32 256 16000 3 / 10 What is the answer for following formula =CHOOSE(8,"Sun","Mon","Tue","Wed","Thu","Fri","Sat") Sat 0 Gives error Sun 4 / 10 Referring to below picture, what is the answer for =COUNTIF(A1:A10,"???") 5 4 3 1 5 / 10 A1=5, what would be the answer for =A1<5 1 FALSE 0 TRUE 6 / 10 CTRL+B is shortcut for what? Makes the font bold This is an invalid shortcut Makes cell corners bold Makes the cell black 7 / 10 The charts built from PivotTables - Pivot chart Normal Chart P Chart Pi Chart 8 / 10 Fill in the blanks - Add cells to the _ _ _ _ _ _ _ _ _ _ _ list to keep an eye on their values as you update other parts of the sheet. Fills Blanks Forms Correl Watch Window Forms Window 9 / 10 Personal.xlsb file doesn’t exist until you record a macro to it. FALSE TRUE 10 / 10 Referring to below picture, what is the answer for this famous formula =SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10)) 7 8 Error Your score is LinkedIn Facebook Twitter Retake quiz Exit
