1|Page
EXCEL CRASH COURSE EXAM LATEST WITH
ACTUAL QUESTIONS AND CORRECT VERIFIED
ANSWERS ALREADY GRADED A+ 100%
GUARANTEED PASS!
move back and forth between the worksheets in a
workbook - .....ANSWER ...✔✔ *Ctrl PageUp* or
*Ctrl PageDown*
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*
,2|Page
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"
,3|Page
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
, 4|Page
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*
EXCEL CRASH COURSE EXAM LATEST WITH
ACTUAL QUESTIONS AND CORRECT VERIFIED
ANSWERS ALREADY GRADED A+ 100%
GUARANTEED PASS!
move back and forth between the worksheets in a
workbook - .....ANSWER ...✔✔ *Ctrl PageUp* or
*Ctrl PageDown*
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*
,2|Page
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"
,3|Page
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
, 4|Page
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*
