Excel Training

What is the shortcut key to Jump to Right?

• Ctrl + Right arrow

• Ctrl + Shift + Right arrow

• Alt + Right arrow

What is the shortcut key to highlight an entire column?

• Shift + Space

• Ctrl + Space

What is the shortcut key to highlight an entire row?

• Shift + Space

• Ctrl + Space

What is the shortcut key to add an entire row?

• Shift + Space

  and

  Ctrl + Plus sign

• Shift + Space

  and

  Shift + Plus sign

What is the shortcut key to remove an entire column?

• Shift + Space

  and

  Shift +Minus Sign

• Ctrl + Space

  and

  Ctrl + Minus sign

What is the shortcut key to hide an entire column and entire row?

• Shift + 0

  and

  Shift + 9

• Ctrl + 0

  and

  Ctrl + 9

What is the shortcut key to auto-sum?

• Shift + Equal Sign

• Alt + Equal sign

• Ctrl + Equal Sign

Which symbol do we use to fix a cell reference in our formulas?

What is the shortcut key to insert this symbol?

Select two answers.

• $

• &

• #

• F4

• F2

What is the shortcut key to show/remove the filter button?

• Ctrl + Alt + L

• Ctrl + Shift + L

What is the shortcut key to clear all the filtered data?

• Alt + A + C

• Shift + A + C