0

Microsoft Excel

Description: This test covers questions related to Microsoft Excel.
Number of Questions: 18
Created by:
Tags: Microsoft Excel
Attempted 0/18 Correct 0 Score 0

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

  1. Alt + Tab

  2. Alt + Shift + Tab

  3. Ctrl + Esc

  4. Ctrl + F5

  5. Ctrl + W or Ctrl + F4


Correct Option: C
Explanation:

This is used to display the windows start menu.

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

  1. Prtscr

  2. Alt + Print Screen

  3. Ctrl + F10

  4. Ctrl + Shift + F6

  5. Ctrl + F6


Correct Option: B
Explanation:

This key combination is used to copy a picture of the selected window to the clipboard.

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

  1. Down Arrow or Up Arrow

  2. F10 or Alt

  3. Ctrl + Tab or Ctrl + Shift + Tab

  4. Alt + Spacebar

  5. Shift + F10


Correct Option: D
Explanation:

This key combination is used to display the Control menu for the Excel window.

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

  1. Ctrl + Shift + Tab or Ctrl + Page Up

  2. Arrow keys

  3. Spacebar

  4. Alt + Down Arrow

  5. Enter


Correct Option: A
Explanation:

This key combination is used to switch to the previous tab in a dialog box.

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

  1. Ctrl + Page Down

  2. Shift + F11 or Alt + Shift + F1

  3. Ctrl + Page Up

  4. Shift + Ctrl + Page Up

  5. Alt + E, L


Correct Option: B
Explanation:

This key combination is used to insert a new worksheet into the active workbook.

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

  1. Ctrl + A

  2. Ctrl + B

  3. Ctrl + C

  4. Ctrl + D

  5. Ctrl + F


Correct Option: A
Explanation:

This key combination displays formula palette given a function name or selects the whole worksheet or current date.

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

  1. Ctrl + G

  2. Ctrl + H

  3. Ctrl + I

  4. Ctrl + K

  5. Ctrl + L


Correct Option: B
Explanation:

This key combination displays the Replace dialog box.

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

  1. Ctrl + V

  2. Ctrl + W

  3. Ctrl + X

  4. Ctrl + Y

  5. Ctrl + Z


Correct Option: D
Explanation:

This key combination is used to repeat the last workbook action.

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

  1. Ctrl + '

  2. Ctrl + Shift + 2

  3. Ctrl + ;

  4. Ctrl + Shift + ;

  5. Ctrl + Shift + Enter


Correct Option: C
Explanation:

This key combination is used to enter the current date into the active cell.

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

  1. Ctrl + Spacebar

  2. Ctrl + Shift + Spacebar

  3. Shift + Arrow keys

  4. Shift + Backspace

  5. Shift + Spacebar


Correct Option: A
Explanation:

This key combination selects the current column.

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?

  1. Ctrl + Up Arrow or Ctrl + Left Arrow

  2. Ctrl + Down Arrow or Ctrl + Right Arrow

  3. F1

  4. Enter

  5. Ctrl + Shift + F12


Correct Option: E
Explanation:

This key combination may be used to display the Print dialog box

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

  1. Ctrl + 1

  2. Ctrl + 2

  3. Ctrl + 5

  4. Ctrl + 4

  5. Ctrl + 6


Correct Option: C
Explanation:

This key combination toggles the strikethrough of text on the current selection.

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

  1. Ctrl + 8

  2. Ctrl + Shift + 0

  3. Ctrl + Shift + 2

  4. Ctrl + Shift + 8

  5. Ctrl + Shift + 9


Correct Option: D
Explanation:

This key combination selects the current region (surrounded by blank rows and columns).

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

  1. Ctrl + Shift + =

  2. Ctrl + Delete

  3. Ctrl + Shift +

  4. Ctrl +

  5. Alt + ;


Correct Option: A
Explanation:

This option displays the Cells dialog box.

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

  1. Ctrl + [

  2. Ctrl + *

  3. Ctrl + ]

  4. Ctrl + Shift + Page Down

  5. Ctrl + Shift + Page Up


Correct Option: B
Explanation:

This option selects the current region (using the * on the number keyboard).

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

  1. Ctrl + Shift + F

  2. Ctrl + Shift + O

  3. Ctrl + Shift + P

  4. Shift + Enter

  5. Shift + Tab


Correct Option: B
Explanation:

This key combination selects all the cells with comments.

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

  1. Ctrl + N

  2. Ctrl + O

  3. Ctrl + P

  4. Ctrl + R

  5. Ctrl + S


Correct Option: D
Explanation:

This key combination copies the leftmost cell in the selection to the right.

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

  1. Down Arrow or Up Arrow

  2. Home or End

  3. Esc

  4. Ctrl + Down Arrow

  5. Ctrl + 7


Correct Option: E
Explanation:

This key combination is used to show or hide the standard toolbar.

- Hide questions