WSP EXCEL CRASH COURSE EXAM 2026 – 200+ PRACTICE QUESTIONS & ANSWERS WITH RATIONALES

Page 1 of 55



WSP EXCEL CRASH COURSE EXAM |ACTUAL

EXAM WITH CORRECT DETAILED AND

VERIFIED ANSWERS|GRADED A+|WALL

STREET PREP EXCEL CRASH COURSE EXAM

|NEW UPDATE

Question 1

What keyboard shortcut is used to jump to the last cell of a data

range (contiguous block) in Excel?

A) Ctrl + Home

B) Ctrl + End ✅

C) Ctrl + Shift + End

D) Ctrl + Page Down

,Page 2 of 55


Rationale: Ctrl + End moves the active cell to the last cell of the

worksheet that contains data (or formatting). Ctrl + Home goes

to cell A1.




Question 2

To select all cells in a contiguous range that contain data (starting

from the active cell), you press:

A) Ctrl + Shift + 8

B) Ctrl + A ✅

C) Ctrl + Shift + Space

D) Ctrl + *

Rationale: Ctrl + A selects the entire current region (contiguous

data block). Pressing again selects entire sheet.

,Page 3 of 55


Question 3

What happens when you double-click the fill handle (small

square at bottom-right of a selected cell)?

A) Copies the formula down only one row

B) Copies the formula down to the last adjacent non-empty cell in

the column to the left ✅

C) Opens the Format Cells dialog

D) Inserts a comment

Rationale: Double-clicking the fill handle autofills down to the

last row where the adjacent column (usually left) has data. A

huge time-saver.




Question 4

The shortcut to insert a new worksheet is:

, Page 4 of 55



A) Shift + F11 ✅

B) Ctrl + N

C) Alt + Insert

D) F12

Rationale: Shift + F11 inserts a new worksheet. Ctrl + N creates

a new workbook.




Question 5

Which shortcut displays the “Go To” dialog box?

A) F5 ✅

B) Ctrl + G

C) Both A and B ✅

D) Alt + G

Rationale: Both F5 and Ctrl + G open the Go To dialog,

allowing you to jump to a named range or cell reference.