EXCEL BASICS - WALL STREET PREP
QUESTIONS WITH CORRECT ANSWERS
2026-2027
Create new sheet - correct answer-ctrl i w
switch between sheets - correct answer-ctrl page up / ctrl page down
access anything on the ribbon - correct answer-atl
toggle between excel books - correct answer-ctrl tab
open new file - correct answer-ctrl o
bold - correct answer-ctrl b
options - correct answer-alt f t
auto size cell - correct answer-alt h o i
designate width of box - correct answer-alt h o w
highlight column - correct answer-ctrl space
highlight row - correct answer-shift space
undo - correct answer-ctrl z
redo - correct answer-ctrl y
, formatting - correct answer-ctrl 1
highlight all columns next - correct answer-ctrl shift > / <
paste special - correct answer-alt e s
zoom in / out - correct answer-alt v z
freeze pane - correct answer-alt w f f
To keep selected rows and/or columns of the worksheet visible on the screen as the rest of the w
orksheet scrolls.
split pane - correct answer-alt w s
hop between panes - correct answer-F6
go inside cell to see functions - correct answer-F2
go inside cell to clear specific info - correct answer-ALT h e
input comment - correct answer-Shift F2
Fill Highlighted Area Right / Down - correct answer-ctrl r / ctrl d
Input New Row - correct answer-ALT i r
input new column - correct answer-alt i c
QUESTIONS WITH CORRECT ANSWERS
2026-2027
Create new sheet - correct answer-ctrl i w
switch between sheets - correct answer-ctrl page up / ctrl page down
access anything on the ribbon - correct answer-atl
toggle between excel books - correct answer-ctrl tab
open new file - correct answer-ctrl o
bold - correct answer-ctrl b
options - correct answer-alt f t
auto size cell - correct answer-alt h o i
designate width of box - correct answer-alt h o w
highlight column - correct answer-ctrl space
highlight row - correct answer-shift space
undo - correct answer-ctrl z
redo - correct answer-ctrl y
, formatting - correct answer-ctrl 1
highlight all columns next - correct answer-ctrl shift > / <
paste special - correct answer-alt e s
zoom in / out - correct answer-alt v z
freeze pane - correct answer-alt w f f
To keep selected rows and/or columns of the worksheet visible on the screen as the rest of the w
orksheet scrolls.
split pane - correct answer-alt w s
hop between panes - correct answer-F6
go inside cell to see functions - correct answer-F2
go inside cell to clear specific info - correct answer-ALT h e
input comment - correct answer-Shift F2
Fill Highlighted Area Right / Down - correct answer-ctrl r / ctrl d
Input New Row - correct answer-ALT i r
input new column - correct answer-alt i c
