EXCEL CRASH COURSE WALL STREET PREP
END OF COURSE STUDY GUIDE LATEST
UPDATED ACTUAL TESTED QUESTIONS
AND CORRECT ANSWERS
⩥ open a file.
Answer: *alt f o*
*ctrl o*
⩥ save a file.
Answer: *alt f s*
*ctrl s*
⩥ print a file.
Answer: *alt f p*
*ctrl p*
⩥ navigating to the toolbars without the mouse.
,Answer: hit *Alt and the appropriate letter* (or use the right/left arrow
keys) to get to the desired tab
once there, use the Tab and Shift Tab keys to navigate around
⩥ accessing settings.
Answer: File > Options (*Alt f t*)
*Alt t o*
⩥ Disabling the Start Screen and adding more worksheets on startup.
Answer: click on 'Blank worksheet'
Hit *Alt f t* go go to Excel options (you can also get there by clicking
the file tab)
Under 'General' unselect "Show the Start screen when this application
starts"
⩥ password protecting files.
Answer: File
Info
,password protect files: "Encrypt with Password"
password protect individual worksheet (so that people can't see or edit
formulas): "Protect Current Sheet"
⩥ highlighting columns and rows.
Answer: columns: *Ctrl Spacebar*
rows: *Shift Spacebar*
⩥ widening columns and rows.
Answer: 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
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.
Answer: *Ctrl 1* pulls up the 'Format Cells' menu
, ⩥ navigating the 'Format Cells' menu.
Answer: 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 by hitting *tab* to move clockwise and
*shift tab* to move counter clockwise
when on the desired tab, horizontal alignment can be accessed through
*Alt h* and vertical alignment through *Alt v*
⩥ paste special.
Answer: *Alt v s t* or *Alt e s t*
⩥ changing zoom size.
Answer: *Alt w q* or *Alt v z*
⩥ Move/copy a tab.
Answer: *Alt h o m*
⩥ freezing 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*
END OF COURSE STUDY GUIDE LATEST
UPDATED ACTUAL TESTED QUESTIONS
AND CORRECT ANSWERS
⩥ open a file.
Answer: *alt f o*
*ctrl o*
⩥ save a file.
Answer: *alt f s*
*ctrl s*
⩥ print a file.
Answer: *alt f p*
*ctrl p*
⩥ navigating to the toolbars without the mouse.
,Answer: hit *Alt and the appropriate letter* (or use the right/left arrow
keys) to get to the desired tab
once there, use the Tab and Shift Tab keys to navigate around
⩥ accessing settings.
Answer: File > Options (*Alt f t*)
*Alt t o*
⩥ Disabling the Start Screen and adding more worksheets on startup.
Answer: click on 'Blank worksheet'
Hit *Alt f t* go go to Excel options (you can also get there by clicking
the file tab)
Under 'General' unselect "Show the Start screen when this application
starts"
⩥ password protecting files.
Answer: File
Info
,password protect files: "Encrypt with Password"
password protect individual worksheet (so that people can't see or edit
formulas): "Protect Current Sheet"
⩥ highlighting columns and rows.
Answer: columns: *Ctrl Spacebar*
rows: *Shift Spacebar*
⩥ widening columns and rows.
Answer: 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
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.
Answer: *Ctrl 1* pulls up the 'Format Cells' menu
, ⩥ navigating the 'Format Cells' menu.
Answer: 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 by hitting *tab* to move clockwise and
*shift tab* to move counter clockwise
when on the desired tab, horizontal alignment can be accessed through
*Alt h* and vertical alignment through *Alt v*
⩥ paste special.
Answer: *Alt v s t* or *Alt e s t*
⩥ changing zoom size.
Answer: *Alt w q* or *Alt v z*
⩥ Move/copy a tab.
Answer: *Alt h o m*
⩥ freezing 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*
