Excel Crash course Exam from Wall Street Updated
2026/2027 Questions with Answers
Create new sheet ......ANSWER......ctrl i w
switch between sheets ......ANSWER......ctrl page up / ctrl page down
access anything on the ribbon ......ANSWER......atl
toggle between excel books ......ANSWER......ctrl tab
open new file ......ANSWER......ctrl o
bold ......ANSWER......ctrl b
options ......ANSWER......alt f t
auto size cell ......ANSWER......alt h o i
designate width of box ......ANSWER......alt h o w
highlight column ......ANSWER......ctrl space
pg. 1
, highlight row ......ANSWER......shift space
undo ......ANSWER......ctrl z
redo ......ANSWER......ctrl y
formatting ......ANSWER......ctrl 1
highlight all columns next ......ANSWER......ctrl shift > / <
paste special ......ANSWER......alt e s
zoom in / out ......ANSWER......alt v z
freeze pane ......ANSWER......alt w f f
To keep selected rows and/or columns of the worksheet visible on the
screen as the rest of the worksheet scrolls.
split pane ......ANSWER......alt w s
hop between panes ......ANSWER......F6
pg. 2
2026/2027 Questions with Answers
Create new sheet ......ANSWER......ctrl i w
switch between sheets ......ANSWER......ctrl page up / ctrl page down
access anything on the ribbon ......ANSWER......atl
toggle between excel books ......ANSWER......ctrl tab
open new file ......ANSWER......ctrl o
bold ......ANSWER......ctrl b
options ......ANSWER......alt f t
auto size cell ......ANSWER......alt h o i
designate width of box ......ANSWER......alt h o w
highlight column ......ANSWER......ctrl space
pg. 1
, highlight row ......ANSWER......shift space
undo ......ANSWER......ctrl z
redo ......ANSWER......ctrl y
formatting ......ANSWER......ctrl 1
highlight all columns next ......ANSWER......ctrl shift > / <
paste special ......ANSWER......alt e s
zoom in / out ......ANSWER......alt v z
freeze pane ......ANSWER......alt w f f
To keep selected rows and/or columns of the worksheet visible on the
screen as the rest of the worksheet scrolls.
split pane ......ANSWER......alt w s
hop between panes ......ANSWER......F6
pg. 2
