EXCEL CRASH COURSE EXAM FROM WALL STREET
PREP - WALL STREET PREP QUESTIONS AND
ANSWERS UPDATED 2025 | ASSURED SUCCESS|
TOP SCORES MADE SIMPLE | TRUSTED TEST
SOLUTIONS!
QUALITY CONTENT YOU CAN RELY ON!
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
1
APPHIA - Crafted with Care and Precision for Academic Excellence.
, 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
2. Shift Alt Right Arrow Key to create the group
3. Alt A H to hide the columns
4. Alt A J will unhide the columns
5. Shift Alt Left Arrow Key to remove group
2
APPHIA - Crafted with Care and Precision for Academic Excellence.
PREP - WALL STREET PREP QUESTIONS AND
ANSWERS UPDATED 2025 | ASSURED SUCCESS|
TOP SCORES MADE SIMPLE | TRUSTED TEST
SOLUTIONS!
QUALITY CONTENT YOU CAN RELY ON!
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
1
APPHIA - Crafted with Care and Precision for Academic Excellence.
, 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
2. Shift Alt Right Arrow Key to create the group
3. Alt A H to hide the columns
4. Alt A J will unhide the columns
5. Shift Alt Left Arrow Key to remove group
2
APPHIA - Crafted with Care and Precision for Academic Excellence.
