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