EXCEL CRASH Course WALL Street
Certification Assessment Questions and
Answers
Verified Solutions Latest Update
Question:
open a file.
Answer:
*alt f o* *ctrl o*
Question:
save a file.
Answer:
*alt f s* *ctrl s*
Question:
print a file.
Answer:
*alt f p* *ctrl p*
Question:
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
Question:
accessing settings.
Answer:
File > Options (*Alt f t*) *Alt t o*
,Question:
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"
Question:
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"
Question:
highlighting columns and rows.
Answer:
columns: *Ctrl Spacebar* rows: *Shift Spacebar*
Question:
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
Question:
format cells.
Answer:
*Ctrl 1* pulls up the 'Format Cells' menu
, Question:
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*
Question:
paste special.
Answer:
*Alt v s t* or *Alt e s t*
Question:
changing zoom size.
Answer:
*Alt w q* or *Alt v z*
Question:
Move/copy a tab.
Answer:
*Alt h o m*
Question:
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* to unfreeze panes: press *Alt w f f* again
Certification Assessment Questions and
Answers
Verified Solutions Latest Update
Question:
open a file.
Answer:
*alt f o* *ctrl o*
Question:
save a file.
Answer:
*alt f s* *ctrl s*
Question:
print a file.
Answer:
*alt f p* *ctrl p*
Question:
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
Question:
accessing settings.
Answer:
File > Options (*Alt f t*) *Alt t o*
,Question:
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"
Question:
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"
Question:
highlighting columns and rows.
Answer:
columns: *Ctrl Spacebar* rows: *Shift Spacebar*
Question:
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
Question:
format cells.
Answer:
*Ctrl 1* pulls up the 'Format Cells' menu
, Question:
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*
Question:
paste special.
Answer:
*Alt v s t* or *Alt e s t*
Question:
changing zoom size.
Answer:
*Alt w q* or *Alt v z*
Question:
Move/copy a tab.
Answer:
*Alt h o m*
Question:
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* to unfreeze panes: press *Alt w f f* again
