Excel Crash Course Exam Prep 2026–2027 | Practice
Questions, Solutions & Study Materials
move back and forth between the worksheets in a workbook - correct answers -*Ctrl PageUp* or *Ctrl
PageDown*
open a file - correct answers -*alt f o*
*ctrl o*
save a file - correct answers -*alt f s*
*ctrl s*
print a file - correct answers -*alt f p*
*ctrl p*
navigating to the toolbars without the mouse - correct answers -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 - correct answers -File > Options (*Alt f t*)
1
,*Alt t o*
Disabling the Start Screen and adding more worksheets on startup - correct answers -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 - correct answers -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 - correct answers -columns: *Ctrl Spacebar*
rows: *Shift Spacebar*
widening columns and rows - correct answers -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
2
, 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 - correct answers -*Ctrl 1* pulls up the 'Format Cells' menu
navigating the 'Format Cells' menu - correct answers -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 - correct answers -*Alt v s t* or *Alt e s t*
changing zoom size - correct answers -*Alt w q* or *Alt v z*
Move/copy a tab - correct answers -*Alt h o m*
freezing panes - correct answers -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*
3
Questions, Solutions & Study Materials
move back and forth between the worksheets in a workbook - correct answers -*Ctrl PageUp* or *Ctrl
PageDown*
open a file - correct answers -*alt f o*
*ctrl o*
save a file - correct answers -*alt f s*
*ctrl s*
print a file - correct answers -*alt f p*
*ctrl p*
navigating to the toolbars without the mouse - correct answers -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 - correct answers -File > Options (*Alt f t*)
1
,*Alt t o*
Disabling the Start Screen and adding more worksheets on startup - correct answers -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 - correct answers -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 - correct answers -columns: *Ctrl Spacebar*
rows: *Shift Spacebar*
widening columns and rows - correct answers -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
2
, 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 - correct answers -*Ctrl 1* pulls up the 'Format Cells' menu
navigating the 'Format Cells' menu - correct answers -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 - correct answers -*Alt v s t* or *Alt e s t*
changing zoom size - correct answers -*Alt w q* or *Alt v z*
Move/copy a tab - correct answers -*Alt h o m*
freezing panes - correct answers -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*
3
