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: - (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
, 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)
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
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: - (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
, 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)
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
