EXCEL CRASH COURSE EXAM FROM WALL
STREET PREP LATEST VERSION EXAM WITH
ACTUAL 48 QUESTION AND ANSWERS WITH
RATIONALES 2026/2027
What is the keyboard shortcut to open the formatting cells dialog box? -
CORRECT ANSWER-Ctrl 1
What are the keyboard shortcuts for auto-fitting a range of columns? -
CORRECT ANSWER-1) Select the columns by hitting Ctrl Spacebar. 2)
Hold down the shift key and use left and right arrow keys to highlight the
range of columns. 3) Hit Alt H O I to auto fit the columns.
When you are in the Format Cells 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?
How do you select a checkbox (put a checkbox next to it) -
CORRECT ANSWER-1) Ctrl Tab 2) Shift Tab 3) Spacebar alt w f f -
1
, CORRECT ANSWER-freeze pane alt w s - CORRECT ANSWER-
split pane
F6 - CORRECT ANSWER-jump between panes
Alt H E A - CORRECT ANSWER-delete everything about a cell
Control Shift + - CORRECT ANSWER-insert new row
Control Shift ! - CORRECT ANSWER-number format; 2 decimals
Control Shift $ - CORRECT ANSWER-currency format; 2 decimals
Control Shift % - CORRECT ANSWER-percentage format with no decimal
points
Control Shift _ - CORRECT ANSWER-remove all borders
All of the following are keyboard shortcut that allow the user input to add
more sheets to a workbook EXCEPT: - CORRECT ANSWER-Alt h i w
What is a keyboard shortcut to open a file? - CORRECT ANSWER-Ctrl o
What is the recommended workbook calculation setting for Excel? -
CORRECT 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: - CORRECT
2
STREET PREP LATEST VERSION EXAM WITH
ACTUAL 48 QUESTION AND ANSWERS WITH
RATIONALES 2026/2027
What is the keyboard shortcut to open the formatting cells dialog box? -
CORRECT ANSWER-Ctrl 1
What are the keyboard shortcuts for auto-fitting a range of columns? -
CORRECT ANSWER-1) Select the columns by hitting Ctrl Spacebar. 2)
Hold down the shift key and use left and right arrow keys to highlight the
range of columns. 3) Hit Alt H O I to auto fit the columns.
When you are in the Format Cells 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?
How do you select a checkbox (put a checkbox next to it) -
CORRECT ANSWER-1) Ctrl Tab 2) Shift Tab 3) Spacebar alt w f f -
1
, CORRECT ANSWER-freeze pane alt w s - CORRECT ANSWER-
split pane
F6 - CORRECT ANSWER-jump between panes
Alt H E A - CORRECT ANSWER-delete everything about a cell
Control Shift + - CORRECT ANSWER-insert new row
Control Shift ! - CORRECT ANSWER-number format; 2 decimals
Control Shift $ - CORRECT ANSWER-currency format; 2 decimals
Control Shift % - CORRECT ANSWER-percentage format with no decimal
points
Control Shift _ - CORRECT ANSWER-remove all borders
All of the following are keyboard shortcut that allow the user input to add
more sheets to a workbook EXCEPT: - CORRECT ANSWER-Alt h i w
What is a keyboard shortcut to open a file? - CORRECT ANSWER-Ctrl o
What is the recommended workbook calculation setting for Excel? -
CORRECT 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: - CORRECT
2
