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