1
EXCEL CRASH COURSE EXAM FROM WALL STREET
PREP - WALL STREET PREP QUESTIONS AND
ANSWERS NEWLY FORMATTED STUDY GUIDE WITH
ACTUAL 2025/26 EXAM TIPS
All of the following are Alt h i w
keyboard shortcut that
allow the user input to
add more sheets to a
workbook EXCEPT:
What is a keyboard Ctrl o
shortcut to open a file?
What is the Automatic except for Data Tables
recommended
workbook calculation
setting for Excel?
To add a cell reference 1. Hit F2 to get into the existing formula;
from a different delete any incorrect formulas or operators 2.
worksheet into an Hit F2 again to enable "Enter" mode on the
existing formula with bottom-left corner of the Excel sheet 3.
your Holding down Ctrl, use PageUp or
keyboard, you should PageDown to find the desired worksheet 4.
follow the following Let go of the Ctrl and PageUp/Down keys 5.
steps: Use the arrow keys to locate the desired
cell reference 6. Hit Enter
Alt h o i exact column width
Alt h o w identical column widths
, 2
Alt h o h identical column height
Control + Space highlight column
Shift + Space highlight row
Command + B bold
Command + I italicize
Alt e s / control paste special
command v
What is the keyboard Alt H O M
shortcut to move sheets
within a workbook?
What is the keyboard Ctrl 1
shortcut to open the
formatting cells
dialog box?
What are the keyboard 1) Select the columns by hitting Ctrl Spacebar.
shortcuts for auto- 2) Hold down the shift key and use left and
fitting a range of right arrow keys to highlight the range of
columns? columns. 3) Hit Alt H O I to auto fit the
columns.
When you are in 1) Ctrl Tab
the Format Cells 2) Shift Tab
3) Spacebar
dialog (Ctrl 1):
What is the keyboard
shortcut for moving
across tabs (Number,
Alignment, Font
Border, Fill,
Protection)?
How do you move
counter clockwise
across form
elements?
EXCEL CRASH COURSE EXAM FROM WALL STREET
PREP - WALL STREET PREP QUESTIONS AND
ANSWERS NEWLY FORMATTED STUDY GUIDE WITH
ACTUAL 2025/26 EXAM TIPS
All of the following are Alt h i w
keyboard shortcut that
allow the user input to
add more sheets to a
workbook EXCEPT:
What is a keyboard Ctrl o
shortcut to open a file?
What is the Automatic except for Data Tables
recommended
workbook calculation
setting for Excel?
To add a cell reference 1. Hit F2 to get into the existing formula;
from a different delete any incorrect formulas or operators 2.
worksheet into an Hit F2 again to enable "Enter" mode on the
existing formula with bottom-left corner of the Excel sheet 3.
your Holding down Ctrl, use PageUp or
keyboard, you should PageDown to find the desired worksheet 4.
follow the following Let go of the Ctrl and PageUp/Down keys 5.
steps: Use the arrow keys to locate the desired
cell reference 6. Hit Enter
Alt h o i exact column width
Alt h o w identical column widths
, 2
Alt h o h identical column height
Control + Space highlight column
Shift + Space highlight row
Command + B bold
Command + I italicize
Alt e s / control paste special
command v
What is the keyboard Alt H O M
shortcut to move sheets
within a workbook?
What is the keyboard Ctrl 1
shortcut to open the
formatting cells
dialog box?
What are the keyboard 1) Select the columns by hitting Ctrl Spacebar.
shortcuts for auto- 2) Hold down the shift key and use left and
fitting a range of right arrow keys to highlight the range of
columns? columns. 3) Hit Alt H O I to auto fit the
columns.
When you are in 1) Ctrl Tab
the Format Cells 2) Shift Tab
3) Spacebar
dialog (Ctrl 1):
What is the keyboard
shortcut for moving
across tabs (Number,
Alignment, Font
Border, Fill,
Protection)?
How do you move
counter clockwise
across form
elements?
