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: - 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 Answers-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 Answers-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 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 O M
What is the keyboard shortcut to open the formatting cells dialog box? - Correct Answers-Ctrl 1
, What are the keyboard shortcuts for auto-fitting a range of columns? - Correct Answers-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 Answers-1) Ctrl Tab
2) Shift Tab
3) Spacebar
alt w f f - Correct Answers-freeze pane
alt w s - Correct Answers-split pane
F6 - Correct Answers-jump between panes
Alt H E A - Correct Answers-delete everything about a cell
Control Shift + - Correct Answers-insert new row
Control Shift ! - Correct Answers-number format; 2 decimals
Control Shift $ - Correct Answers-currency format; 2 decimals
Control Shift % - Correct Answers-percentage format with no decimal points
Control Shift _ - Correct Answers-remove all borders
Alt H I S - Correct Answers-new worksheet
Alt e l - Correct Answers-delete worksheet
Alt h o r - Correct Answers-rename worksheet
To Group Columns - Correct Answers-1. Ctrl Space to select desired columns
2. Shift Alt Right Arrow Key to create the group
3. Alt A H to hide the columns
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: - 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 Answers-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 Answers-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 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 O M
What is the keyboard shortcut to open the formatting cells dialog box? - Correct Answers-Ctrl 1
, What are the keyboard shortcuts for auto-fitting a range of columns? - Correct Answers-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 Answers-1) Ctrl Tab
2) Shift Tab
3) Spacebar
alt w f f - Correct Answers-freeze pane
alt w s - Correct Answers-split pane
F6 - Correct Answers-jump between panes
Alt H E A - Correct Answers-delete everything about a cell
Control Shift + - Correct Answers-insert new row
Control Shift ! - Correct Answers-number format; 2 decimals
Control Shift $ - Correct Answers-currency format; 2 decimals
Control Shift % - Correct Answers-percentage format with no decimal points
Control Shift _ - Correct Answers-remove all borders
Alt H I S - Correct Answers-new worksheet
Alt e l - Correct Answers-delete worksheet
Alt h o r - Correct Answers-rename worksheet
To Group Columns - Correct Answers-1. Ctrl Space to select desired columns
2. Shift Alt Right Arrow Key to create the group
3. Alt A H to hide the columns
