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