Excel crash course exam questions and verified answers.
1.move back and forth between the worksheets in a workbook -
ANSWER;*Ctrl PageUp* or *Ctrl PageDown*
2. open a file -
ANSWER;*alt f o*
*ctrl o*
3. save a file -
ANSWER;*alt f s*
*ctrl s*
4. print a file -
ANSWER;*alt f p*
*ctrl p*
5. 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
6. once there, use the Tab and Shift Tab keys to navigate around
,accessing settings -
ANSWER;File > Options (*Alt f t*)
*Alt t o*
7. Disabling the Start Screen and adding more worksheets on startup -
ANSWER;click on 'Blank worksheet'
8. 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"
9. highlighting columns and rows -
ANSWER;columns: *Ctrl Spacebar*
rows: *Shift Spacebar*
10. 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
11. format cells -
ANSWER;*Ctrl 1* pulls up the 'Format Cells' menu
12. 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*
13. paste special -
ANSWER;*Alt v s t* or *Alt e s t*
14. changing zoom size -
ANSWER;*Alt w q* or *Alt v z*
15. Move/copy a tab -
ANSWER;*Alt h o m*
16. 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*
1.move back and forth between the worksheets in a workbook -
ANSWER;*Ctrl PageUp* or *Ctrl PageDown*
2. open a file -
ANSWER;*alt f o*
*ctrl o*
3. save a file -
ANSWER;*alt f s*
*ctrl s*
4. print a file -
ANSWER;*alt f p*
*ctrl p*
5. 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
6. once there, use the Tab and Shift Tab keys to navigate around
,accessing settings -
ANSWER;File > Options (*Alt f t*)
*Alt t o*
7. Disabling the Start Screen and adding more worksheets on startup -
ANSWER;click on 'Blank worksheet'
8. 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"
9. highlighting columns and rows -
ANSWER;columns: *Ctrl Spacebar*
rows: *Shift Spacebar*
10. 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
11. format cells -
ANSWER;*Ctrl 1* pulls up the 'Format Cells' menu
12. 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*
13. paste special -
ANSWER;*Alt v s t* or *Alt e s t*
14. changing zoom size -
ANSWER;*Alt w q* or *Alt v z*
15. Move/copy a tab -
ANSWER;*Alt h o m*
16. 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*
