XCEL CRASH COURSE EXAM FROM
WALL STREET PREP - WALL STREET
PREP QUESTIONS AND ANSWERS
UPDATED 2026 | 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
/.What are the keyboard shortcuts for auto-fitting a range of columns? - 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) - Answer-✅1) Ctrl Tab
2) Shift Tab
3) Spacebar
/.alt w f f - Answer-✅freeze pane
/.alt w s - Answer-✅split pane
/.F6 - Answer-✅jump between panes
/.Alt H E A - Answer-✅delete everything about a cell
/.Control Shift + - Answer-✅insert new row
/.Control Shift ! - Answer-✅number format; 2 decimals
/.Control Shift $ - Answer-✅currency format; 2 decimals
/.Control Shift % - Answer-✅percentage format with no decimal points
/.Control Shift _ - Answer-✅remove all borders
/.Alt H I S - Answer-✅new worksheet
/.Alt e l - Answer-✅delete worksheet
/.Alt h o r - Answer-✅rename worksheet
/.To Group Columns - Answer-✅1. Ctrl Space to select desired columns
WALL STREET PREP - WALL STREET
PREP QUESTIONS AND ANSWERS
UPDATED 2026 | 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
/.What are the keyboard shortcuts for auto-fitting a range of columns? - 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) - Answer-✅1) Ctrl Tab
2) Shift Tab
3) Spacebar
/.alt w f f - Answer-✅freeze pane
/.alt w s - Answer-✅split pane
/.F6 - Answer-✅jump between panes
/.Alt H E A - Answer-✅delete everything about a cell
/.Control Shift + - Answer-✅insert new row
/.Control Shift ! - Answer-✅number format; 2 decimals
/.Control Shift $ - Answer-✅currency format; 2 decimals
/.Control Shift % - Answer-✅percentage format with no decimal points
/.Control Shift _ - Answer-✅remove all borders
/.Alt H I S - Answer-✅new worksheet
/.Alt e l - Answer-✅delete worksheet
/.Alt h o r - Answer-✅rename worksheet
/.To Group Columns - Answer-✅1. Ctrl Space to select desired columns
