EXCEL CRASH COURSE EXAM FROM WALL
STREET PREP LATEST VERSION EXAM WITH
ACTUAL 200 QUESTION AND CORRECT
DETAILED ANSWERS WITH RATIONALES
Practice questions for this set
Learn
Studied 7 terms
Nice work. You’re doing brilliantly.
Continue studying in Learn
Terms in this set (120)
move back and forth Ctrl PageUp or Ctrl PageDown
between the worksheets
in a workbook
alt f o
open a file
ctrl o
alt f s
save a file
ctrl s
, alt f p
print a file
ctrl p
hit Alt and the appropriate letter (or use the right/left
arrow keys) to get to the desired tab
navigating to the toolbars
without the mouse
once there, use the Tab and Shift Tab keys to navigate
around
File > Options (Alt f t)
accessing settings
Alt t o
click on 'Blank worksheet'
Disabling the Start Screen Hit Alt f t go go to Excel options (you can also get
and adding more there by clicking the file tab)
worksheets on startup
Under 'General' unselect "Show the Start screen when
this application starts"
File
Info
password protect files: "Encrypt with Password"
password protecting files
password protect individual worksheet (so that
people can't see or edit formulas): "Protect Current
Sheet"
highlighting columns and columns: Ctrl Spacebar
rows rows: Shift Spacebar
, highlight column by pressing Ctrl Spacebar
Alt h o i to auto-fit the column width
-if you want a column to have a certain width, press
Alt h o w and enter the desired width
widening columns and
rows
highlight row by pressing Shift Spacebar
Alt h o a to auto-fit the row height
-if you want a row to have a certain height, press Alt h
o h and enter the desired height
format cells Ctrl 1 pulls up the 'Format Cells' menu
after hitting Ctrl 1 to pull up the 'Format Cells' menu,
you can navigate around tabs by hitting Ctrl tab
each category within a tab can be accessed by
pressing Alt and the appropriate underlined letter, or
navigating the 'Format
by hitting tab to move clockwise and shift tab to
Cells' menu
move counter clockwise
when on the desired tab, horizontal alignment can be
accessed through Alt h and vertical alignment
through Alt v
paste special Alt v s t or Alt e s t
changing zoom size Alt w q or Alt v z
Move/copy a tab Alt h o m
click the cell BELOW the desired row and to the
RIGHT of the desired column where you want to
freezing panes freeze panes and hit Alt w f f
to unfreeze panes: press Alt w f f again
STREET PREP LATEST VERSION EXAM WITH
ACTUAL 200 QUESTION AND CORRECT
DETAILED ANSWERS WITH RATIONALES
Practice questions for this set
Learn
Studied 7 terms
Nice work. You’re doing brilliantly.
Continue studying in Learn
Terms in this set (120)
move back and forth Ctrl PageUp or Ctrl PageDown
between the worksheets
in a workbook
alt f o
open a file
ctrl o
alt f s
save a file
ctrl s
, alt f p
print a file
ctrl p
hit Alt and the appropriate letter (or use the right/left
arrow keys) to get to the desired tab
navigating to the toolbars
without the mouse
once there, use the Tab and Shift Tab keys to navigate
around
File > Options (Alt f t)
accessing settings
Alt t o
click on 'Blank worksheet'
Disabling the Start Screen Hit Alt f t go go to Excel options (you can also get
and adding more there by clicking the file tab)
worksheets on startup
Under 'General' unselect "Show the Start screen when
this application starts"
File
Info
password protect files: "Encrypt with Password"
password protecting files
password protect individual worksheet (so that
people can't see or edit formulas): "Protect Current
Sheet"
highlighting columns and columns: Ctrl Spacebar
rows rows: Shift Spacebar
, highlight column by pressing Ctrl Spacebar
Alt h o i to auto-fit the column width
-if you want a column to have a certain width, press
Alt h o w and enter the desired width
widening columns and
rows
highlight row by pressing Shift Spacebar
Alt h o a to auto-fit the row height
-if you want a row to have a certain height, press Alt h
o h and enter the desired height
format cells Ctrl 1 pulls up the 'Format Cells' menu
after hitting Ctrl 1 to pull up the 'Format Cells' menu,
you can navigate around tabs by hitting Ctrl tab
each category within a tab can be accessed by
pressing Alt and the appropriate underlined letter, or
navigating the 'Format
by hitting tab to move clockwise and shift tab to
Cells' menu
move counter clockwise
when on the desired tab, horizontal alignment can be
accessed through Alt h and vertical alignment
through Alt v
paste special Alt v s t or Alt e s t
changing zoom size Alt w q or Alt v z
Move/copy a tab Alt h o m
click the cell BELOW the desired row and to the
RIGHT of the desired column where you want to
freezing panes freeze panes and hit Alt w f f
to unfreeze panes: press Alt w f f again
