Home › Quizzes › Microsoft Excel Keyboard Shortcuts

Microsoft Excel Keyboard Shortcuts

Test your knowledge of keyboard shortcuts used in Microsoft Excel for formatting, navigation, and common tasks.

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of these function keys is used to create a chart from selected data in Microsoft Excel?

  1. F7
  2. F2
  3. F11
  4. F4
  5. F5
Question 2 Multiple Choice (Single Answer)

Which of the following keyboard short-cuts is used to open the Excel formula window?

  1. Shift+F3
  2. Shift+F5
  3. Alt+Shift+F1
  4. Ctrl+Shift+:
  5. F2
Question 3 Multiple Choice (Single Answer)

If one wants to enter the current date, which key combination may he use?

  1. Alt+Shift+F1
  2. Ctrl+Shif t+:
  3. Ctrl+;
  4. Alt+Enter
  5. Shift+F5
Question 4 Multiple Choice (Single Answer)

Which of the following is a keyboard option to open the Format Cells window?

  1. Ctrl+I
  2. Ctrl+B
  3. Ctrl+A
  4. Shift+F5
  5. Ctrl+1
Question 5 Multiple Choice (Single Answer)

Which of the following keyboard shortcuts is used to strike-through a highlighted selection?

  1. Ctrl + S
  2. Ctrl + Z
  3. Ctrl + 1
  4. Ctrl + 5
  5. Ctrl + P
Question 6 Multiple Choice (Single Answer)

Which of these keyboard options is used to open Excel Name Manager?

  1. Ctrl+F9
  2. Ctrl+F3
  3. Ctrl+F10
  4. Ctrl+F6
  5. Ctrl+Page up
Question 7 Multiple Choice (Single Answer)

Which of the following keyboard options is used to format numbers in a percentage format?

  1. Ctrl+Tab
  2. Ctrl+'
  3. Ctrl+Shift+1
  4. Ctrl+Shift+5
  5. Ctrl+Shift+4
Question 8 Multiple Choice (Single Answer)

Which of these shortcut combinations creates a formula to sum all of the cells above?

  1. Ctrl + '
  2. Alt + =
  3. Ctrl + Tab
  4. Ctrl + Shift + 1
  5. Ctrl + F6
Question 9 Multiple Choice (Single Answer)

Which of the following key-combinations is used to format numbers in a scientific format?

  1. Ctrl+Shift+6
  2. Ctrl+Shift+5
  3. Ctrl+Shift+3
  4. Ctrl+Shift+4
  5. Ctrl+Shift+1
Question 10 Multiple Choice (Single Answer)

Using which of the following keyboard options can one delete the selected column or row in MS-Excel?

  1. Shift+Space
  2. Ctrl+-
  3. Ctrl+Shift+=
  4. Ctrl+Home
  5. Ctrl+Space
Question 11 Multiple Choice (Single Answer)

Which of the following options is used to edit the selected cell?

  1. F2
  2. F3
  3. F5
  4. Alt+Shift+F1
  5. Ctrl+Z
Question 12 Multiple Choice (Single Answer)

Using which of the following short-cuts can, one switch between showing Excel formulas and their values in cells?

  1. Ctrl+Home
  2. Ctrl+Shift+2
  3. Ctrl+~
  4. Ctrl+'
  5. Ctrl+Shift+1
Question 13 Multiple Choice (Single Answer)

Which of the following short-cuts is used to switch between worksheet tabs, from right-to-left?

  1. Ctrl+PgDn
  2. Ctrl+PgUp
  3. Ctrl+Shift+(
  4. Ctrl+Shift+&
  5. Ctrl+Shift+~
Question 14 Multiple Choice (Single Answer)

Which of the following key combinations switches control to the next tab in dialog box in MS-Excel?

  1. Ctrl+Tab
  2. Ctrl+Shift+Tab
  3. Shift+Tab
  4. Alt+Spacebar
  5. Ctrl+Shift+Spacebar
Question 15 Multiple Choice (Single Answer)

Which of the following keyboard options displays or hides the outline symbols in MS-Excel?

  1. Ctrl+6
  2. Ctrl+8
  3. Ctrrl+9
  4. Ctrl+4
  5. Ctrl+3
← Back to Quizzes