EXCEL CRASH COURSE EXAM FROM WALL
STREET PREP - WALL STREET PREP
QUESTIONS AND ANSWERS UPDATED 2025
| ASSURED SUCCESS
All of the following are keyboard shortcut that allow the user input to
add more sheets to a workbook EXCEPT: - answer Alt h i w
What is a keyboard shortcut to open a file? - answer Ctrl o
What is the recommended workbook calculation setting for Excel? -
answer Automatic except for Data Tables
To add a cell reference from a different worksheet into an existing
formula with your keyboard, you should follow the following steps: -
answer 1. Hit F2 to get into the existing 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
or PageDown to find the desired worksheet 4. Let go of the Ctrl and
PageUp/Down keys 5. Use the arrow keys to locate the desired cell
reference 6. Hit Enter
Alt h o i - answer exact column width
, Alt h o w - answer identical column widths
Alt h o h - answer identical column height
Control + Space - answer highlight column
Shift + Space - answer highlight row
Command + B - answer bold
Command + I - answer italicize
Alt e s / control command v - answer paste special
What is the keyboard shortcut to move sheets within a workbook? -
answer Alt H O M
What is the keyboard shortcut to open the formatting cells dialog box? -
answer Ctrl 1
STREET PREP - WALL STREET PREP
QUESTIONS AND ANSWERS UPDATED 2025
| ASSURED SUCCESS
All of the following are keyboard shortcut that allow the user input to
add more sheets to a workbook EXCEPT: - answer Alt h i w
What is a keyboard shortcut to open a file? - answer Ctrl o
What is the recommended workbook calculation setting for Excel? -
answer Automatic except for Data Tables
To add a cell reference from a different worksheet into an existing
formula with your keyboard, you should follow the following steps: -
answer 1. Hit F2 to get into the existing 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
or PageDown to find the desired worksheet 4. Let go of the Ctrl and
PageUp/Down keys 5. Use the arrow keys to locate the desired cell
reference 6. Hit Enter
Alt h o i - answer exact column width
, Alt h o w - answer identical column widths
Alt h o h - answer identical column height
Control + Space - answer highlight column
Shift + Space - answer highlight row
Command + B - answer bold
Command + I - answer italicize
Alt e s / control command v - answer paste special
What is the keyboard shortcut to move sheets within a workbook? -
answer Alt H O M
What is the keyboard shortcut to open the formatting cells dialog box? -
answer Ctrl 1
