EXCEL CRASH COURSE TEST BANK BY WALL
STREET PREP WITH 100% CORRECT
SOLUTIONS
◉ 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*
to unfreeze panes: press *Alt w f f* again
◉ splitting panes. Answer: splitting panes allows users to scroll in
both areas of the worksheet, while rows and columns in the non-
scrolled area remain visible
to split 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 unspilt 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
STREET PREP WITH 100% CORRECT
SOLUTIONS
◉ 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*
to unfreeze panes: press *Alt w f f* again
◉ splitting panes. Answer: splitting panes allows users to scroll in
both areas of the worksheet, while rows and columns in the non-
scrolled area remain visible
to split 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 unspilt 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
