EXCEL CRASH COURSE EXAM FROM WALL STREET PREP - WALL STREET P
QUESTIONS AND ANSWERS UPDATED 2025 | ASSURED SUCCESS
Study online at https://quizlet.com/_gfsnrf
1. All of the following are key- Alt h i w
board shortcut that allow the
user input to add more sheets
to a workbook EXCEPT:
2. What is a keyboard shortcut to Ctrl o
open a file?
3. What is the recommended Automatic except for Data Tables
workbook calculation setting
for Excel?
4. To add a cell reference from 1. Hit F2 to get into the existing formula; delete any incorrect
a different worksheet into an formulas or operators 2. Hit F2 again to enable "Enter" mode
existing formula with your on the bottom-left corner of the Excel sheet 3. Holding down
keyboard, you should follow Ctrl, use PageUp or PageDown to find the desired worksheet 4.
the following steps: Let go of the Ctrl and PageUp/Down keys 5. Use the arrow keys
to locate the desired cell reference 6. Hit Enter
5. Alt h o i exact column width
6. Alt h o w identical column widths
7. Alt h o h identical column height
8. Control + Space highlight column
9. Shift + Space highlight row
10. Command + B bold
11. Command + I italicize
1/8
, EXCEL CRASH COURSE EXAM FROM WALL STREET PREP - WALL STREET P
QUESTIONS AND ANSWERS UPDATED 2025 | ASSURED SUCCESS
Study online at https://quizlet.com/_gfsnrf
12. Alt e s / control command v paste special
13. What is the keyboard shortcut Alt H O M
to move sheets within a work-
book?
14. What is the keyboard shortcut Ctrl 1
to open the formatting cells
dialog box?
15. What are the keyboard short- 1) Select the columns by hitting Ctrl Spacebar. 2) Hold down the
cuts for auto-fitting a range of shift key and use left and right arrow keys to highlight the range
columns? of columns. 3) Hit Alt H O I to auto fit the columns.
16. When you are in the Format 1) Ctrl Tab
Cells dialog (Ctrl 1): 2) Shift Tab
What is the keyboard shortcut 3) Spacebar
for moving across tabs (Num-
ber, Alignment, Font Border,
Fill, Protection)?
How do you move counter
clockwise across form ele-
ments?
How do you select a checkbox
(put a checkbox next to it)
17. alt w f f freeze pane
18. alt w s split pane
19. F6 jump between panes
20. Alt H E A delete everything about a cell
2/8
QUESTIONS AND ANSWERS UPDATED 2025 | ASSURED SUCCESS
Study online at https://quizlet.com/_gfsnrf
1. All of the following are key- Alt h i w
board shortcut that allow the
user input to add more sheets
to a workbook EXCEPT:
2. What is a keyboard shortcut to Ctrl o
open a file?
3. What is the recommended Automatic except for Data Tables
workbook calculation setting
for Excel?
4. To add a cell reference from 1. Hit F2 to get into the existing formula; delete any incorrect
a different worksheet into an formulas or operators 2. Hit F2 again to enable "Enter" mode
existing formula with your on the bottom-left corner of the Excel sheet 3. Holding down
keyboard, you should follow Ctrl, use PageUp or PageDown to find the desired worksheet 4.
the following steps: Let go of the Ctrl and PageUp/Down keys 5. Use the arrow keys
to locate the desired cell reference 6. Hit Enter
5. Alt h o i exact column width
6. Alt h o w identical column widths
7. Alt h o h identical column height
8. Control + Space highlight column
9. Shift + Space highlight row
10. Command + B bold
11. Command + I italicize
1/8
, EXCEL CRASH COURSE EXAM FROM WALL STREET PREP - WALL STREET P
QUESTIONS AND ANSWERS UPDATED 2025 | ASSURED SUCCESS
Study online at https://quizlet.com/_gfsnrf
12. Alt e s / control command v paste special
13. What is the keyboard shortcut Alt H O M
to move sheets within a work-
book?
14. What is the keyboard shortcut Ctrl 1
to open the formatting cells
dialog box?
15. What are the keyboard short- 1) Select the columns by hitting Ctrl Spacebar. 2) Hold down the
cuts for auto-fitting a range of shift key and use left and right arrow keys to highlight the range
columns? of columns. 3) Hit Alt H O I to auto fit the columns.
16. When you are in the Format 1) Ctrl Tab
Cells dialog (Ctrl 1): 2) Shift Tab
What is the keyboard shortcut 3) Spacebar
for moving across tabs (Num-
ber, Alignment, Font Border,
Fill, Protection)?
How do you move counter
clockwise across form ele-
ments?
How do you select a checkbox
(put a checkbox next to it)
17. alt w f f freeze pane
18. alt w s split pane
19. F6 jump between panes
20. Alt H E A delete everything about a cell
2/8
