Wall Street Prep Excel -Exam Questions and
Answers
Add/delete worksheets
alt i w
Move back and forth to different worksheets
ctrl page up and down
Open a new file
alt f n, ctrl n
open a file
alt f o, ctrl o
save a file
alt f s, ctrl s, alt f a(save as)
print a file
alt f p, ctrl p
Navigating to the toolbars without the mouse
Hit alt and the corresponding letter and then use tab and shift-tab to navigate
Access Excel options
alt f t, alt t o
Bold
Ctrl B
Highlight Column
ctrl spacebar
Auto fit column width
alt h o i, alt o c a
Enter column width
alt h o w, alt o c w
Highlight Row
Shift Spacebar
auto fit row height
alt h o a, alt o r a
, Enter row height
alt h o h, alt o r e
Format cells menu
ctrl 1. has six tabs that include number, alignment, font, border, fill, protection. you can navigate
around the tabs with ctrl-tab. each category within a tab can be accessed by pressing Alt and the
appropriate underlined letter, or by hitting tab.
Paste Special
alt h v s , alt e s
Move to different sheet
ctrl tab
move the location of sheets
alt h o m
change zoom
alt w q, alt v z
Freeze Panes
Click the cell below the desired row and to the right of the desired column where you want to freeze
panes and hit alt w f f. To unfreeze panes, press alt w f f again.
Splitting Panes
Click the cell below the desired row and to the right of the desired column where you want to split
panes and hit alt w s. To un-split panes, click alt w s again. Press F6 to move from pane to pane in a
clockwise direction; press Shift F6 to move from pane to pane in a counter-clockwise direction.
undo/redo
ctrl z/ctrl y
highlight characters one at a time in a cell
Shift arrow-keys
highlight a continuous range in a cell
Shift Ctrl arrow-keys
Clears a cell
alt h e (a=all,f=format,c=content,m=comments)
paste to columns
ctrl r
Answers
Add/delete worksheets
alt i w
Move back and forth to different worksheets
ctrl page up and down
Open a new file
alt f n, ctrl n
open a file
alt f o, ctrl o
save a file
alt f s, ctrl s, alt f a(save as)
print a file
alt f p, ctrl p
Navigating to the toolbars without the mouse
Hit alt and the corresponding letter and then use tab and shift-tab to navigate
Access Excel options
alt f t, alt t o
Bold
Ctrl B
Highlight Column
ctrl spacebar
Auto fit column width
alt h o i, alt o c a
Enter column width
alt h o w, alt o c w
Highlight Row
Shift Spacebar
auto fit row height
alt h o a, alt o r a
, Enter row height
alt h o h, alt o r e
Format cells menu
ctrl 1. has six tabs that include number, alignment, font, border, fill, protection. you can navigate
around the tabs with ctrl-tab. each category within a tab can be accessed by pressing Alt and the
appropriate underlined letter, or by hitting tab.
Paste Special
alt h v s , alt e s
Move to different sheet
ctrl tab
move the location of sheets
alt h o m
change zoom
alt w q, alt v z
Freeze Panes
Click the cell below the desired row and to the right of the desired column where you want to freeze
panes and hit alt w f f. To unfreeze panes, press alt w f f again.
Splitting Panes
Click the cell below the desired row and to the right of the desired column where you want to split
panes and hit alt w s. To un-split panes, click alt w s again. Press F6 to move from pane to pane in a
clockwise direction; press Shift F6 to move from pane to pane in a counter-clockwise direction.
undo/redo
ctrl z/ctrl y
highlight characters one at a time in a cell
Shift arrow-keys
highlight a continuous range in a cell
Shift Ctrl arrow-keys
Clears a cell
alt h e (a=all,f=format,c=content,m=comments)
paste to columns
ctrl r
