MS Excel Shortcut Keys
Practice MS Excel shortcut keys MCQs with answers. Test your knowledge of Microsoft Excel keyboard shortcuts for formulas, navigation, and data formatting.
1 2 3 … 26 Next All questions Full list of questions in this category for browsing. Newest 200 of 520 — older questions are linked from each MCQ (previous/next).
Select the correct shortcut key which is used to select the entire row in MS Excel. What shortcut key combination performs the action to undo the last action in MS Excel? The keyboard shortcut Ctrl + 4 in MS Excel performs which of the following actions? Which key combination should be pressed in MS Excel to start the spelling check? Select the correct shortcut key which is used to toggle AutoFilter on the selected range in MS Excel. In MS Excel, F4 is used for which purpose? What shortcut key combination performs the action to open the Print Preview window in MS Excel? In MS Excel, which shortcut key helps you open the Format Cells dialog box? What is the function of Ctrl + Shift + & in MS Excel? Identify the correct shortcut key used to insert new cells, rows, or columns in MS Excel. What shortcut key combination performs the action to create names from row and column labels in MS Excel? Which key combination should be pressed in MS Excel to insert a new worksheet? In MS Excel, which shortcut key helps you select the entire column? In MS Excel, which shortcut key helps you print the active worksheet? Ctrl + Z is the shortcut key for which of the following actions in MS Excel? Which key combination should be pressed in MS Excel to move to the next worksheet in the workbook? Which of the following key combinations allows you to apply the Scientific number format in MS Excel? Which of the following key combinations allows you to cut the selected cells or data in MS Excel? Which key combination should be pressed in MS Excel to open the Print Preview window? In MS Excel, the shortcut key Ctrl + Shift + @ is used to ________. What does the shortcut key F4 do in MS Excel? To insert the AutoSum formula in MS Excel, which key combination should be pressed? Which shortcut key is used to insert the AutoSum formula in MS Excel? To open the Format Cells dialog box in MS Excel, which key combination should be pressed? Which of the following key combinations allows you to insert the current time into the active cell in MS Excel... Ctrl + I is the shortcut key for which of the following actions in MS Excel? Identify the correct shortcut key used to open an existing workbook in MS Excel. Pressing Ctrl + O in MS Excel will ________. Which key combination should be pressed in MS Excel to start a new line within the same cell? Identify the correct shortcut key used to apply the Currency number format in MS Excel. Which of the following key combinations allows you to toggle AutoFilter on the selected range in MS Excel? Select the correct shortcut key which is used to open the Insert Function dialog box in MS Excel. Select the correct shortcut key which is used to apply or remove italic formatting in MS Excel. To start a new line within the same cell in MS Excel, which key combination should be pressed? To edit the active cell in MS Excel, which key combination should be pressed? In MS Excel, what is the keyboard shortcut to insert a new worksheet? To apply or remove bold formatting in MS Excel, which key combination should be pressed? To select the entire row in MS Excel, which key combination should be pressed? In MS Excel, which shortcut key helps you undo the last action? What does the shortcut key Ctrl + U do in MS Excel? Identify the correct shortcut key used to apply the Date number format in MS Excel. Identify the correct shortcut key used to create names from row and column labels in MS Excel. Identify the correct shortcut key used to unhide hidden rows within the selection in MS Excel. Which action is performed when you press Ctrl + ' in MS Excel? What shortcut key combination performs the action to open the Create Table dialog box in MS Excel? Which shortcut key is used to apply the Scientific number format in MS Excel? Which key combination should be pressed in MS Excel to unhide hidden columns within the selection? What is the function of Ctrl + Shift + 0 in MS Excel? If you want to move to the previous worksheet in the workbook in MS Excel, which shortcut key will you use? In MS Excel, Alt + F1 is used for which purpose? What is the function of Ctrl + Z in MS Excel? Which shortcut key is used to open the Home tab on the ribbon in MS Excel? In MS Excel, what is the keyboard shortcut to delete the selected cells, rows, or columns? Which of the following key combinations allows you to apply the General number format in MS Excel? In MS Excel, what is the keyboard shortcut to open the AutoFilter drop-down list? Pressing Ctrl + 2 in MS Excel will ________. Which key combination should be pressed in MS Excel to apply italic formatting to selected cells? In MS Excel, the shortcut key Ctrl + Shift + % is used to ________. Identify the correct shortcut key used to open the Go To dialog box in MS Excel. The keyboard shortcut F5 in MS Excel performs which of the following actions? Which key combination should be pressed in MS Excel to open the Insert tab on the ribbon? If you want to apply the Percentage number format in MS Excel, which shortcut key will you use? What does the shortcut key Ctrl + F10 do in MS Excel? Pressing Ctrl + F in MS Excel will ________. Identify the correct shortcut key used to create an embedded chart of the selected data in MS Excel. Ctrl + F is the shortcut key for which of the following actions in MS Excel? What does the shortcut key Ctrl + B do in MS Excel? Pressing Ctrl + Shift + ^ in MS Excel will ________. Select the correct shortcut key which is used to copy the formula from the cell above into the active cell in... Select the correct shortcut key which is used to remove the outline border from selected cells in MS Excel. What does the shortcut key Ctrl + Shift + $ do in MS Excel? What shortcut key combination performs the action to create a new workbook in MS Excel? To open the Go To dialog box using the function key shortcut in MS Excel, which key combination should be pres... Identify the correct shortcut key used to delete the selected cells, rows, or columns in MS Excel. Which shortcut key is used to redo the last undone action in MS Excel? Which action is performed when you press Ctrl + 5 in MS Excel? Which action is performed when you press Ctrl + W in MS Excel? What does the shortcut key Ctrl + Shift + % do in MS Excel? Which shortcut key is used to fill right the content of the leftmost cell in MS Excel? Pressing Ctrl + F2 in MS Excel will ________. Identify the correct shortcut key used to toggle the display of formulas in cells in MS Excel. Which shortcut key is used to apply or remove underline formatting in MS Excel? In MS Excel, Ctrl + V is used for which purpose? In MS Excel, Ctrl + F2 is used for which purpose? Identify the correct shortcut key used to open the Find and Replace dialog box in MS Excel. Identify the correct shortcut key used to copy the selected cells or data in MS Excel. In MS Excel, which shortcut key helps you insert the AutoSum formula? In MS Excel, which shortcut key helps you apply or remove bold formatting? Which of the following key combinations allows you to close the active workbook in MS Excel? In MS Excel, the shortcut key Ctrl + Shift + 9 is used to ________. Select the correct shortcut key which is used to open the Find dialog box in MS Excel. If you want to insert a new worksheet in MS Excel, which shortcut key will you use? What is the function of Alt + Down Arrow in MS Excel? The keyboard shortcut Ctrl + I in MS Excel performs which of the following actions? Which action is performed when you press Ctrl + Shift + & in MS Excel? In MS Excel, what is the keyboard shortcut to toggle the display of formulas in cells? In MS Excel, the shortcut key Ctrl + Shift + Space is used to ________. Which key combination should be pressed in MS Excel to select the entire row? Identify the correct shortcut key used to open the Print Preview window in MS Excel. In MS Excel, the shortcut key Alt + Down Arrow is used to ________. Which key combination should be pressed in MS Excel to toggle AutoFilter on the selected range? Which shortcut key is used to select the entire column in MS Excel? Select the correct shortcut key which is used to print the active worksheet in MS Excel. What shortcut key combination performs the action to insert the AutoSum formula in MS Excel? Which of the following key combinations allows you to remove the outline border from selected cells in MS Exce... Which shortcut key is used to toggle AutoFilter on the selected range in MS Excel? What is the function of Ctrl + 5 in MS Excel? Identify the correct shortcut key used to apply the Time number format in MS Excel. What is the function of Ctrl + I in MS Excel? The keyboard shortcut Ctrl + Shift + ~ in MS Excel performs which of the following actions? Which action is performed when you press Ctrl + ; in MS Excel? Which shortcut key is used to repeat the last action or toggle a cell reference type in MS Excel? In MS Excel, what is the keyboard shortcut to apply underline formatting to selected cells? To apply or remove strikethrough formatting in MS Excel, which key combination should be pressed? In MS Excel, Ctrl + 2 is used for which purpose? Which of the following key combinations allows you to open the AutoFilter drop-down list in MS Excel? Which shortcut key is used to create a new workbook in MS Excel? The keyboard shortcut Alt + N in MS Excel performs which of the following actions? Select the correct shortcut key which is used to insert a new worksheet in MS Excel. Which shortcut key is used to hide the selected rows in MS Excel? The keyboard shortcut Ctrl + Page Up in MS Excel performs which of the following actions? Which shortcut key is used to copy the selected cells or data in MS Excel? What is the function of Ctrl + Shift + 9 in MS Excel? In MS Excel, Ctrl + Shift + F3 is used for which purpose? Which of the following key combinations allows you to unhide hidden columns within the selection in MS Excel? Ctrl + W is the shortcut key for which of the following actions in MS Excel? What is the function of Ctrl + Shift + : in MS Excel? Ctrl + ' is the shortcut key for which of the following actions in MS Excel? To select the entire column in MS Excel, which key combination should be pressed? In MS Excel, Ctrl + Shift + U is used for which purpose? Which action is performed when you press Ctrl + U in MS Excel? If you want to select the entire column in MS Excel, which shortcut key will you use? In MS Excel, the shortcut key Ctrl + I is used to ________. If you want to cut the selected cells or data in MS Excel, which shortcut key will you use? In MS Excel, which shortcut key helps you maximize or restore the active workbook window? What is the function of Ctrl + Shift + # in MS Excel? Which of the following key combinations allows you to insert a table for the selected data in MS Excel? In MS Excel, the shortcut key Ctrl + G is used to ________. To apply the Percentage number format in MS Excel, which key combination should be pressed? Which key combination should be pressed in MS Excel to open the Go To dialog box using the function key shortc... To apply the Number format with two decimal places in MS Excel, which key combination should be pressed? Which key combination should be pressed in MS Excel to hide the selected rows? In MS Excel, what is the keyboard shortcut to undo the last action? Pressing Ctrl + S in MS Excel will ________. To maximize or restore the active workbook window in MS Excel, which key combination should be pressed? The keyboard shortcut F4 in MS Excel performs which of the following actions? What does the shortcut key Ctrl + 3 do in MS Excel? In MS Excel, what is the keyboard shortcut to apply or remove bold formatting? What does the shortcut key Ctrl + Enter do in MS Excel? What does the shortcut key Ctrl + W do in MS Excel? Which key combination should be pressed in MS Excel to expand or collapse the formula bar? The keyboard shortcut Ctrl + Shift + Space in MS Excel performs which of the following actions? Which shortcut key is used to apply or remove italic formatting in MS Excel? Which key combination should be pressed in MS Excel to close the active workbook? What does the shortcut key Ctrl + F2 do in MS Excel? Identify the correct shortcut key used to apply Flash Fill to the selected column in MS Excel. Pressing Ctrl + Shift + % in MS Excel will ________. If you want to open the Go To dialog box in MS Excel, which shortcut key will you use? In MS Excel, which shortcut key helps you apply bold formatting to selected cells? If you want to minimize the active workbook window in MS Excel, which shortcut key will you use? If you want to select the entire row in MS Excel, which shortcut key will you use? In MS Excel, Ctrl + T is used for which purpose? Select the correct shortcut key which is used to apply an outline border around selected cells in MS Excel. In MS Excel, what is the keyboard shortcut to open the Go To dialog box? Select the correct shortcut key which is used to apply bold formatting to selected cells in MS Excel. Which of the following key combinations allows you to create a new workbook in MS Excel? What does the shortcut key Alt + = do in MS Excel? Which shortcut key is used to delete the selected cells, rows, or columns in MS Excel? Which of the following key combinations allows you to create names from row and column labels in MS Excel? Ctrl + N is the shortcut key for which of the following actions in MS Excel? What is the function of Ctrl + Space in MS Excel? In MS Excel, the shortcut key Ctrl + Space is used to ________. Select the correct shortcut key which is used to open the Go To dialog box in MS Excel. Select the correct shortcut key which is used to apply Flash Fill to the selected column in MS Excel. In MS Excel, what is the keyboard shortcut to select the entire worksheet? In MS Excel, the shortcut key Ctrl + E is used to ________. If you want to fill down the content of the cell above in MS Excel, which shortcut key will you use? What is the function of Alt + F1 in MS Excel? Which action is performed when you press Ctrl + F2 in MS Excel? Which shortcut key is used to hide the selected columns in MS Excel? Which shortcut key is used to switch between open workbooks in MS Excel? What is the function of Ctrl + ` in MS Excel? Ctrl + 2 is the shortcut key for which of the following actions in MS Excel? Which of the following key combinations allows you to repeat the last action or toggle a cell reference type i... What shortcut key combination performs the action to apply the Scientific number format in MS Excel? In MS Excel, Ctrl + ; is used for which purpose? To select the entire worksheet or current data region in MS Excel, which key combination should be pressed? Which key combination should be pressed in MS Excel to select the entire column? What shortcut key combination performs the action to create a chart of the selected data in a new sheet in MS... In MS Excel, what is the keyboard shortcut to calculate all worksheets in all open workbooks? In MS Excel, which shortcut key helps you apply the Percentage number format? What is the function of Ctrl + F1 in MS Excel? Which shortcut key is used to unhide hidden columns within the selection in MS Excel? The keyboard shortcut Ctrl + Shift + ^ in MS Excel performs which of the following actions? In MS Excel, Ctrl + O is used for which purpose? What does the shortcut key Ctrl + 1 do in MS Excel? In MS Excel, what is the keyboard shortcut to create a chart of the selected data in a new sheet? Which action is performed when you press Ctrl + Shift + # in MS Excel? Identify the correct shortcut key used to switch between open workbooks in MS Excel. Which action is performed when you press F9 in MS Excel?