0

Microsoft Excel

Description: This test covers short-cut key options used in Microsoft Excel.
Number of Questions: 15
Created by:
Tags: Microsoft Excel Office Short-cuts
Attempted 0/15 Correct 0 Score 0

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


Correct Option: C
Explanation:

F11 may be used to create a chart from selected data.

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


Correct Option: A
Explanation:

This key is used to open the Excel formula window.

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


Correct Option: C
Explanation:

This key combination is used to enter the current date.

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


Correct Option: E
Explanation:

This option is used to open the Format Cells window.

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


Correct Option: D
Explanation:

This option is used to strike-through a highlighted selection.

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


Correct Option: B
Explanation:

This key combination is used to open Excel Name Manager.

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


Correct Option: D
Explanation:

This option is used to format numbers in a percentage format

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


Correct Option: B
Explanation:

This key combination is used to create a formula to sum all of the cells above.

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


Correct Option: A
Explanation:

This option is used to format numbers in a scientific format.

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


Correct Option: B
Explanation:

This key combination is used to delete the selected column or row.

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


Correct Option: A
Explanation:

This function key is used to edit the selected cell.

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


Correct Option: C
Explanation:

This option is used to switch between showing Excel formulas or their values in cells.

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+~


Correct Option: A
Explanation:

This option switches between worksheet tabs, from right-to-left.

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


Correct Option: A
Explanation:

Ctrl+Tab switches to the next tab in dialog box.

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


Correct Option: B
Explanation:

This option displays or hides the outline symbols.

- Hide questions