Excel Crash Course Exam Questions
and Answers24
move to cell "A1" - ANSWERS-*Ctrl Home*
move to cell above - ANSWERS-*Shift Enter*
move to cell to the right - ANSWERS-*tab*
move to cell to the left - ANSWERS-*Shift Tab*
show formulas/values - ANSWERS-*Ctrl ~*
fill selection with entry - ANSWERS-*Ctrl enter*
recalculate all workbooks - ANSWERS-*F9*
get inside a drop-down list - ANSWERS-*Alt + up/down arrow key*
display "Insert Function" box - ANSWERS-*Alt I F (Shift F3)*
display "Name" box - ANSWERS-*Ctrl F3*
Enter array formula - ANSWERS-*Shift Ctrl Enter*
,replace - ANSWERS-*Ctrl H*
insert AutoSum formula - ANSWERS-*Alt +" (hold down Alt)
start a new line in same cell - ANSWERS-*Alt Enter*
move back and forth between the worksheets in a workbook - ANSWERS-*Ctrl PageUp* or *Ctrl
PageDown*
open a file - ANSWERS-*alt f o*
*ctrl o*
save a file - ANSWERS-*alt f s*
*ctrl s*
print a file - ANSWERS-*alt f p*
*ctrl p*
navigating to the toolbars without the mouse - 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 - ANSWERS-File > Options (*Alt f t*)
, *Alt t o*
Disabling the Start Screen and adding more worksheets on startup - 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 - 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 - ANSWERS-columns: *Ctrl Spacebar*
rows: *Shift Spacebar*
widening columns and rows - 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
highlight row by pressing Shift Spacebar
*Alt h o a* to auto-fit the row height
and Answers24
move to cell "A1" - ANSWERS-*Ctrl Home*
move to cell above - ANSWERS-*Shift Enter*
move to cell to the right - ANSWERS-*tab*
move to cell to the left - ANSWERS-*Shift Tab*
show formulas/values - ANSWERS-*Ctrl ~*
fill selection with entry - ANSWERS-*Ctrl enter*
recalculate all workbooks - ANSWERS-*F9*
get inside a drop-down list - ANSWERS-*Alt + up/down arrow key*
display "Insert Function" box - ANSWERS-*Alt I F (Shift F3)*
display "Name" box - ANSWERS-*Ctrl F3*
Enter array formula - ANSWERS-*Shift Ctrl Enter*
,replace - ANSWERS-*Ctrl H*
insert AutoSum formula - ANSWERS-*Alt +" (hold down Alt)
start a new line in same cell - ANSWERS-*Alt Enter*
move back and forth between the worksheets in a workbook - ANSWERS-*Ctrl PageUp* or *Ctrl
PageDown*
open a file - ANSWERS-*alt f o*
*ctrl o*
save a file - ANSWERS-*alt f s*
*ctrl s*
print a file - ANSWERS-*alt f p*
*ctrl p*
navigating to the toolbars without the mouse - 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 - ANSWERS-File > Options (*Alt f t*)
, *Alt t o*
Disabling the Start Screen and adding more worksheets on startup - 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 - 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 - ANSWERS-columns: *Ctrl Spacebar*
rows: *Shift Spacebar*
widening columns and rows - 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
highlight row by pressing Shift Spacebar
*Alt h o a* to auto-fit the row height
