Excel Crash Course from Wall Street 2025/2026 Newest Exam With Questions And 100% Detailed Answers

1|Page


Excel Crash Course from Wall Street 2025/2026

Newest Exam With Questions And 100% Detailed

Answers

What is the keyboard sequence to

1) Group highlighted columns (but not to hide group)

2) Hide the group (will show a + sign above the column)

3) Show the group (will show a + sign above the column) -

ANSWER-1. Shift Alt Right Arrow 2. Alt a h 3. Alt a j




Jumping from One Formula Element to the Next -

ANSWER-Ctrl+Arrows

(Cmnd+Arrows)

,2|Page


Highlight Formula Elements & Maintain Contiguous

Elements - ANSWER-Ctrl+Shift+Arrows

(Cmnd+Shift+Arrows)




Highlight the Whole Formula of an Active Cell - ANSWER-

Shift+DownArrow

(Shift+Up/DownArrow)




How to Revert Back to Original Formula after Editing an

Active Cell - ANSWER-Esc




How to Exit Cell Edit Mode in an Active Cell - ANSWER-F2

(Fn+F2)

,3|Page


Clearing a Cell - ANSWER-Alt+H+E (Home>Clear)

Clear All: Alt+H+E+A

Clear Format: Alt+H+E+F

Clear Comments: Alt+H+E+M




Add Comment - ANSWER-Shift+F2 (Shift+Fn+F2)

Esc twice to exit




Right Fill from Cell Left - ANSWER-Highlight the cell you

want to copy

Shift+RightArrow to the cells that you want to be filled

Hit Ctrl+R

, 4|Page


Down Fill from Cell Up - ANSWER-Highlight the cell you

want to copy

Shift+DownArrow to the cells that you want to be filled

Hit Ctrl+D




Inserting Rows - ANSWER-(1) Go to any cell in the row

below the desired row

(2) Press Alt+I+R

OR

(1) Highlight the row below the desired row with

Shift+Space

(2) Press Ctrl Shift + to insert the new row