Excel Quiz 15 Posted on July 4, 2015September 25, 2021 by Vijay A. Verma Quiz 15 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 The shortcut to display Format Cells dialog box CTRL+2 CTRL+0 CTRL+3 CTRL+1 2 / 10 To display Go To dialog box, CTRL+G shortcut is used. Another shortcut for the same is SHIFT+G ESC+G F5 ALT+G 3 / 10 You can create your own shortcuts in Excel No Yes 4 / 10 SHIFT+F2 is shortcut for Converts character into numeric Inserts comment in the active cell Put a $ sign in cell content Not a valid shortcut 5 / 10 Which function counts only numbers in a range? COUNTNUMBERS COUNTN COUNTA COUNT 6 / 10 Shortcut to edit active cell is F4 CTRL+Home F2 ALT+END 7 / 10 The shortcut to display Find and Replace dialog box is CTRL+F CTRL+H None CTRL+G 8 / 10 The shortcut for Autosum is ALT+= SHIFT++ CTRL++ ALT+- 9 / 10 The shortcut to display the list of macros SHIFT+F8 CTRL+F8 ALT+F8 ALT+SHIFT+F8 10 / 10 For below range, what is the answer for =COUNT(A1:A10) Pay attention to cells having green triangles in upper left corner. 0 6 10 4 Your score is LinkedIn Facebook Twitter Retake quiz Exit
