Excel Quiz 32 Posted on May 20, 2016September 26, 2021 by Vijay A. Verma Quiz 32 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 To insert a new worksheet, shortcut is CTRL+SHIFT+F11 ALT+I SHIFT+F11 CTRL+F11 2 / 10 The shortcut for applying the filter is CTRL+SHIFT+F CTRL+F CTRL+SHIFT+L ALT+F+L 3 / 10 CTRL+1 is shorrcut for Formatting a cell with general format Opening format cells dialog box To put a $ sign in the cell Formatting a cell with bold format 4 / 10 ALT+= is shortcut for Averages the cells selected Not a valid shortcut Autosum Insert an array formula 5 / 10 Which one is not a Microsoft supplied Add-in? Fuzzy Lookup Inquire Power Query Compare Excel 6 / 10 CTRL+~ is shortcut for Opens name manager box To toggle between values and show formulas Converts to time format Converts to date format 7 / 10 To add or edit cell comments, shortcut is CTRL+F2 SHIFT+F2 ALT+F2 ALT+SHIFT+F2 8 / 10 CTRL+; is shortcut for Inserts current date and time Applies thousand separator Inserts current time Inserts current date 9 / 10 To enter a new line in a cell, the shortcut is CTRL+ENTER ALT+ENTER F2 SHIFT+ENTER 10 / 10 ALT+D+P is shortcut for Fill in the bottom cells with top cell within the range selected Opening print dialog box Opening pivot table wizard Opening page layout dialog box Your score is LinkedIn Facebook Twitter Retake quiz Exit
