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