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