Excel Crash Course Exam from
Wall Street Prep-wall Street Prep
Complete Test , Practice
Questions, Verified Answer Key,
and Study Guide for (Latest 2026
Edition)
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
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 - CORRECT ANSWER-exact column width
Alt h o w - CORRECT ANSWER-identical column widths
Alt h o h - CORRECT ANSWER-identical column height
Control + Space - CORRECT ANSWER-highlight column
Shift + Space - CORRECT ANSWER-highlight row
Command + B - CORRECT ANSWER-bold
Command + I - CORRECT ANSWER-italicize
Alt e s / control command v - CORRECT ANSWER-paste special
What is the keyboard shortcut to move sheets within a workbook? -
CORRECT ANSWER-Alt H O M
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?
© 2026 Copyright. All Rights Reserved. This document is
protected by copyright law
Wall Street Prep-wall Street Prep
Complete Test , Practice
Questions, Verified Answer Key,
and Study Guide for (Latest 2026
Edition)
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
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 - CORRECT ANSWER-exact column width
Alt h o w - CORRECT ANSWER-identical column widths
Alt h o h - CORRECT ANSWER-identical column height
Control + Space - CORRECT ANSWER-highlight column
Shift + Space - CORRECT ANSWER-highlight row
Command + B - CORRECT ANSWER-bold
Command + I - CORRECT ANSWER-italicize
Alt e s / control command v - CORRECT ANSWER-paste special
What is the keyboard shortcut to move sheets within a workbook? -
CORRECT ANSWER-Alt H O M
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?
© 2026 Copyright. All Rights Reserved. This document is
protected by copyright law
