EXCEL CRASH COURSE 2026 STUDY
GUIDE PRACTICE QUESTIONS
DETAILED SOLUTIONS
◉ 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
, ◉ 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
◉ go inside cell to see functions. Answer: F2
GUIDE PRACTICE QUESTIONS
DETAILED SOLUTIONS
◉ 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
, ◉ 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
◉ go inside cell to see functions. Answer: F2