Excel Basics - Wall Street Prep
Exam Questions and Answers
100% PASS
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 worksheet 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
deleting columns / rows - CORRECT ANSWER-ALT H D R / ALT H D C
Paste Special Formatting - CORRECT ANSWER-ALT E S T
Trace Precedents - CORRECT ANSWER-ATL M P / (delete it ALT M A A)
allows you to see which cells are referenced in a particular formula or
function
© 2026 Copyright. All Rights Reserved. This document is
protected by copyright law
Exam Questions and Answers
100% PASS
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 worksheet 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
deleting columns / rows - CORRECT ANSWER-ALT H D R / ALT H D C
Paste Special Formatting - CORRECT ANSWER-ALT E S T
Trace Precedents - CORRECT ANSWER-ATL M P / (delete it ALT M A A)
allows you to see which cells are referenced in a particular formula or
function
© 2026 Copyright. All Rights Reserved. This document is
protected by copyright law
