EMILLECT 2024/2025 ACADEMIC YEAR ©2024 EMILLECT. ALL RIGHTS RESERVED. FIRST PUBLISH OCTOBER 2024.
Wall Street Prep Excel Exam Study
Guide
Add/delete worksheets - Answer✔✔-alt i w
Move back and forth to different worksheets - Answer✔✔-ctrl page up and down
Open a new file - Answer✔✔-alt f n, ctrl n
open a file - Answer✔✔-alt f o, ctrl o
save a file - Answer✔✔-alt f s, ctrl s, alt f a(save as)
print a file - Answer✔✔-alt f p, ctrl p
Navigating to the toolbars without the mouse - Answer✔✔-Hit alt and the corresponding letter
and then use tab and shift-tab to navigate
Access Excel options - Answer✔✔-alt f t, alt t o
Bold - Answer✔✔-Ctrl B
Highlight Column - Answer✔✔-ctrl spacebar
Auto fit column width - Answer✔✔-alt h o i, alt o c a
Enter column width - Answer✔✔-alt h o w, alt o c w
Page 1/7
, EMILLECT 2024/2025 ACADEMIC YEAR ©2024 EMILLECT. ALL RIGHTS RESERVED. FIRST PUBLISH OCTOBER 2024.
Highlight Row - Answer✔✔-Shift Spacebar
auto fit row height - Answer✔✔-alt h o a, alt o r a
Enter row height - Answer✔✔-alt h o h, alt o r e
Format cells menu - Answer✔✔-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 - Answer✔✔-alt h v s , alt e s
Move to different sheet - Answer✔✔-ctrl tab
move the location of sheets - Answer✔✔-alt h o m
change zoom - Answer✔✔-alt w q, alt v z
Freeze Panes - Answer✔✔-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 - Answer✔✔-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 - Answer✔✔-ctrl z/ctrl y
highlight characters one at a time in a cell - Answer✔✔-Shift arrow-keys
Page 2/7
Wall Street Prep Excel Exam Study
Guide
Add/delete worksheets - Answer✔✔-alt i w
Move back and forth to different worksheets - Answer✔✔-ctrl page up and down
Open a new file - Answer✔✔-alt f n, ctrl n
open a file - Answer✔✔-alt f o, ctrl o
save a file - Answer✔✔-alt f s, ctrl s, alt f a(save as)
print a file - Answer✔✔-alt f p, ctrl p
Navigating to the toolbars without the mouse - Answer✔✔-Hit alt and the corresponding letter
and then use tab and shift-tab to navigate
Access Excel options - Answer✔✔-alt f t, alt t o
Bold - Answer✔✔-Ctrl B
Highlight Column - Answer✔✔-ctrl spacebar
Auto fit column width - Answer✔✔-alt h o i, alt o c a
Enter column width - Answer✔✔-alt h o w, alt o c w
Page 1/7
, EMILLECT 2024/2025 ACADEMIC YEAR ©2024 EMILLECT. ALL RIGHTS RESERVED. FIRST PUBLISH OCTOBER 2024.
Highlight Row - Answer✔✔-Shift Spacebar
auto fit row height - Answer✔✔-alt h o a, alt o r a
Enter row height - Answer✔✔-alt h o h, alt o r e
Format cells menu - Answer✔✔-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 - Answer✔✔-alt h v s , alt e s
Move to different sheet - Answer✔✔-ctrl tab
move the location of sheets - Answer✔✔-alt h o m
change zoom - Answer✔✔-alt w q, alt v z
Freeze Panes - Answer✔✔-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 - Answer✔✔-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 - Answer✔✔-ctrl z/ctrl y
highlight characters one at a time in a cell - Answer✔✔-Shift arrow-keys
Page 2/7
