Microsoft Excel

Question 1 Multiple Choice (Single Answer)

Which of these keyboard shortcuts may be used to display the windows start menu when using the excel utility?

Alt + Tab
Alt + Shift + Tab
Ctrl + Esc
Ctrl + F5
Ctrl + W or Ctrl + F4

Question 2 Multiple Choice (Single Answer)

Which of these options can be used to copy a picture of the selected window to the clipboard?

Prtscr
Alt + Print Screen
Ctrl + F10
Ctrl + Shift + F6
Ctrl + F6

Question 3 Multiple Choice (Single Answer)

Which of these keyboard key combinations is used to display the Control menu for the Excel window?

Down Arrow or Up Arrow
F10 or Alt
Ctrl + Tab or Ctrl + Shift + Tab
Alt + Spacebar
Shift + F10

Question 4 Multiple Choice (Single Answer)

When working with dialog boxes in Excel, how can we switch to the previous tab in a dialog box using keyboard?

Ctrl + Shift + Tab or Ctrl + Page Up
Arrow keys
Spacebar
Alt + Down Arrow
Enter

Question 5 Multiple Choice (Single Answer)

Which of the following keyboard shortcuts is used to insert a new worksheet?

Ctrl + Page Down
Shift + F11 or Alt + Shift + F1
Ctrl + Page Up
Shift + Ctrl + Page Up
Alt + E, L

Question 6 Multiple Choice (Single Answer)

The use of which of the following key combinations displays formula palette given a function name?

Ctrl + A
Ctrl + B
Ctrl + C
Ctrl + D
Ctrl + F

Question 7 Multiple Choice (Single Answer)

Which of the following key combination, when used in MS-Excel, displays the Replace dialog box?

Ctrl + G
Ctrl + H
Ctrl + I
Ctrl + K
Ctrl + L

Question 8 Multiple Choice (Single Answer)

Which of the following options is used to repeat the last workbook action?

Ctrl + V
Ctrl + W
Ctrl + X
Ctrl + Y
Ctrl + Z

Question 9 Multiple Choice (Single Answer)

Which of the following key combinations is used to enter the current date into the active cell?

Ctrl + '
Ctrl + Shift + 2
Ctrl + ;
Ctrl + Shift + ;
Ctrl + Shift + Enter

Question 10 Multiple Choice (Single Answer)

Which of the following options is used to select the current column in a worksheet?

Ctrl + Spacebar
Ctrl + Shift + Spacebar
Shift + Arrow keys
Shift + Backspace
Shift + Spacebar

Question 11 Multiple Choice (Single Answer)

We know that Ctrl + P is used to display the Print dialog box.

Which of the following options may also be used to display the Print dialog box?

Ctrl + Up Arrow or Ctrl + Left Arrow
Ctrl + Down Arrow or Ctrl + Right Arrow
F1
Enter
Ctrl + Shift + F12

Question 12 Multiple Choice (Single Answer)

Which of the following key combinations is used to toggle the strikethrough of text on the current selection?

Ctrl + 1
Ctrl + 2
Ctrl + 5
Ctrl + 4
Ctrl + 6

Question 13 Multiple Choice (Single Answer)

What is the key combination used in Excel to select the current region (surrounded by blank rows and columns)?

Ctrl + 8
Ctrl + Shift + 0
Ctrl + Shift + 2
Ctrl + Shift + 8
Ctrl + Shift + 9

Question 14 Multiple Choice (Single Answer)

Which of the following key combinations is used to display the Cells dialog box?

Ctrl + Shift + =
Ctrl + Delete
Ctrl + Shift +
Ctrl +
Alt + ;

Question 15 Multiple Choice (Single Answer)

Which of the following options, when used in MS-Excel, selects the current region ?

Ctrl + [
Ctrl + *
Ctrl + ]
Ctrl + Shift + Page Down
Ctrl + Shift + Page Up

Question 16 Multiple Choice (Single Answer)

Which key combination is used to select all the cells with comments in MS-Excel?

Ctrl + Shift + F
Ctrl + Shift + O
Ctrl + Shift + P
Shift + Enter
Shift + Tab

Question 17 Multiple Choice (Single Answer)

Which of the following shortcut key combinations copies the leftmost cell in the selection to the right?

Ctrl + N
Ctrl + O
Ctrl + P
Ctrl + R
Ctrl + S

Question 18 Multiple Choice (Single Answer)

Which of these keyboard shortcuts is used to show or hide the standard toolbar?

Down Arrow or Up Arrow
Home or End
Esc
Ctrl + Down Arrow
Ctrl + 7

Questions