EXCEL CRASH COURSE EXAM WALLSTREET-
PREP QUESTIONS AND VERIFIED 100%
CORRECT ANSWERS LATEST UPDATE
2026/2027|GRADED A+
All of the following are keyboard shortcut that allow the user input to add more sheets to
aworkbook EXCEPT:
correct answers Alt h i w
What is a keyboard shortcut to open a file?
correct answers Ctrl o
What is the recommended workbook calculation setting for Excel?
correct answersAutomatic except for Data Tables
To add a cell reference from a different worksheet into an existing formula with yourkeyboard, you
should follow the following steps:
correct answers 1. Hit F2 to get into theexisting formula; delete any incorrect formulas or
operators 2. Hit F2 again to enable "Enter"mode on the bottom left corner of the Excel sheet 3.
Holding down Ctrl, use PageUp orPageDown to find the desired worksheet 4. Let go of the Ctrl and
PageUp/Down keys 5. Usethe arrow keys to locate the desired cell reference 6. Hit Enter
Alt h o i correct answers exact column width Alt h o w
correct answers identical column widths
, Alt h o h
correct answers identical column height
Control + Space
correct answers highlight column
Shift + Space
correct answers highlight row
Command + B
correct answers bold
Command + I
correct answers italicize
Alt e s / control command v
correct answers paste special
What is the keyboard shortcut to move sheets within a workbook?
correct answers Alt H OM
What is the keyboard shortcut to open the formatting cells dialog box?
correct answers Ctrl1
What are the keyboard shortcuts for auto fitting a range of columns?
correct answers
PREP QUESTIONS AND VERIFIED 100%
CORRECT ANSWERS LATEST UPDATE
2026/2027|GRADED A+
All of the following are keyboard shortcut that allow the user input to add more sheets to
aworkbook EXCEPT:
correct answers Alt h i w
What is a keyboard shortcut to open a file?
correct answers Ctrl o
What is the recommended workbook calculation setting for Excel?
correct answersAutomatic except for Data Tables
To add a cell reference from a different worksheet into an existing formula with yourkeyboard, you
should follow the following steps:
correct answers 1. Hit F2 to get into theexisting formula; delete any incorrect formulas or
operators 2. Hit F2 again to enable "Enter"mode on the bottom left corner of the Excel sheet 3.
Holding down Ctrl, use PageUp orPageDown to find the desired worksheet 4. Let go of the Ctrl and
PageUp/Down keys 5. Usethe arrow keys to locate the desired cell reference 6. Hit Enter
Alt h o i correct answers exact column width Alt h o w
correct answers identical column widths
, Alt h o h
correct answers identical column height
Control + Space
correct answers highlight column
Shift + Space
correct answers highlight row
Command + B
correct answers bold
Command + I
correct answers italicize
Alt e s / control command v
correct answers paste special
What is the keyboard shortcut to move sheets within a workbook?
correct answers Alt H OM
What is the keyboard shortcut to open the formatting cells dialog box?
correct answers Ctrl1
What are the keyboard shortcuts for auto fitting a range of columns?
correct answers
