EXCEL CRASH COURSE EXAM 2025 LATEST VERSION FROM
WALL STREET QUESTIONS AND 100% CORRECT ANSWERS
(BRAND NEW!!)/WSP EXCEL CRASH COURSE
Question 1
All of the following are keyboard shortcuts that allow the user to add more
sheets to a workbook EXCEPT:
A) Alt i w
B) Alt h i s
C) Shift F11
D) Alt Shift F1
E) Alt h i w
Correct Answer: E) Alt h i w
Rationale: Alt i w, Alt h i s, Shift F11, and Alt Shift F1 are all valid
keyboard shortcuts for adding new sheets. Alt h i w is not a valid
shortcut for this action.
Question 2
What is a keyboard shortcut to open an existing file in Excel?
A) Ctrl + O
B) Ctrl + F
C) Alt + O
D) Ctrl + N
E) Ctrl + S
Correct Answer: A) Ctrl + O
Rationale: Ctrl + O is the standard keyboard shortcut to open an
existing file. Ctrl + F is for find, Ctrl + N is for a new workbook, and
Ctrl + S is to save.
Question 3
What is the recommended workbook calculation setting for Excel, especially
when dealing with complex models?
A) Automatic
B) Manual
C) Automatic except for Data Tables
,D) Iterate
E) Semi-Automatic
Correct Answer: C) Automatic except for Data Tables
Rationale: "Automatic except for Data Tables" is recommended
because data tables can be very resource-intensive, and
recalculating them automatically with every change can significantly
slow down the workbook. This setting allows other parts of the
workbook to update automatically while giving the user control over
when data tables recalculate.
Question 4
To add a cell reference from a different worksheet into an existing formula
with your keyboard, you should follow the following steps:
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.
A) These are the correct steps.
B) In step 3, you should hold down Alt instead of Ctrl.
C) In step 6, you should hit Escape to save the reference.
D) In step 2, hitting F2 again is incorrect; you should just directly
navigate.
E) In step 3, you should use arrow keys to navigate between sheets.
Correct Answer: A) These are the correct steps.
, Rationale: The described sequence correctly outlines the
keyboard-only method to select a cell reference from another
worksheet while editing a formula. Ctrl + PageUp/PageDown is
the shortcut for navigating between worksheets.
Question 5
What is the keyboard command sequence to autofit the row height of a
selected row or range of rows?
A) Alt + O + C + A
B) Alt + O + C + W
C) Alt + H + O + H
D) Alt + H + O + A
E) Alt + R + H + A
Correct Answer: D) Alt + H + O + A
Rationale: The sequence Alt + H (Home tab) + O (Format dropdown)
+ A (AutoFit Row Height) is the correct shortcut. Alt + O + C + A is
for autofit column width, Alt + H + O + H is for setting row height
manually.
Question 6
What is the command to change the zoom size within an Excel worksheet?
A) Alt + V + Z
B) Alt + T + O + V
C) Alt + H + O + I
D) Alt + H + V + T
E) Ctrl + Scroll Wheel
Correct Answer: A) Alt + V + Z
Rationale: The sequence Alt + V (View tab) + Z (Zoom) opens the
Zoom dialog box. Ctrl + Scroll Wheel also changes zoom but the
question asks for a command sequence. Other options are incorrect.
Question 7
What is the keyboard shortcut to open the "Format Cells" dialog box?
, A) Ctrl + 1
B) Ctrl + 2
C) Ctrl + Shift + 1
D) Ctrl + Shift + 2
E) Ctrl + F1
Correct Answer: A) Ctrl + 1
Rationale: Ctrl + 1 is the universal keyboard shortcut to open the
Format Cells dialog box in Excel. Ctrl + Shift + 1 cycles number
formats, and other options are incorrect for this specific action.
Question 8
What are the keyboard shortcuts for auto-fitting a range of columns?
A) 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.
B) 1) Hold down the Shift key and use left and right arrow keys to select
columns desired. 2) Hit Alt + H + O + I to auto fit the columns.
C) 1) Select the columns by hitting Shift + Spacebar. 2) Hold down the Ctrl
key and use left and right arrow keys to highlight the range of columns. 3)
Hit Alt + H + O + W to auto fit the columns.
D) 1) Select the columns by hitting Shift + 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 + W to auto fit the columns.
E) 1) Select the columns by hitting Ctrl + A. 2) Hit Alt + H + O + A to auto fit
the columns.
Correct Answer: A) 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.
Rationale: Ctrl + Spacebar selects the entire column. Then, Shift +
arrow keys extends the selection to a range of columns. Finally, Alt
WALL STREET QUESTIONS AND 100% CORRECT ANSWERS
(BRAND NEW!!)/WSP EXCEL CRASH COURSE
Question 1
All of the following are keyboard shortcuts that allow the user to add more
sheets to a workbook EXCEPT:
A) Alt i w
B) Alt h i s
C) Shift F11
D) Alt Shift F1
E) Alt h i w
Correct Answer: E) Alt h i w
Rationale: Alt i w, Alt h i s, Shift F11, and Alt Shift F1 are all valid
keyboard shortcuts for adding new sheets. Alt h i w is not a valid
shortcut for this action.
Question 2
What is a keyboard shortcut to open an existing file in Excel?
A) Ctrl + O
B) Ctrl + F
C) Alt + O
D) Ctrl + N
E) Ctrl + S
Correct Answer: A) Ctrl + O
Rationale: Ctrl + O is the standard keyboard shortcut to open an
existing file. Ctrl + F is for find, Ctrl + N is for a new workbook, and
Ctrl + S is to save.
Question 3
What is the recommended workbook calculation setting for Excel, especially
when dealing with complex models?
A) Automatic
B) Manual
C) Automatic except for Data Tables
,D) Iterate
E) Semi-Automatic
Correct Answer: C) Automatic except for Data Tables
Rationale: "Automatic except for Data Tables" is recommended
because data tables can be very resource-intensive, and
recalculating them automatically with every change can significantly
slow down the workbook. This setting allows other parts of the
workbook to update automatically while giving the user control over
when data tables recalculate.
Question 4
To add a cell reference from a different worksheet into an existing formula
with your keyboard, you should follow the following steps:
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.
A) These are the correct steps.
B) In step 3, you should hold down Alt instead of Ctrl.
C) In step 6, you should hit Escape to save the reference.
D) In step 2, hitting F2 again is incorrect; you should just directly
navigate.
E) In step 3, you should use arrow keys to navigate between sheets.
Correct Answer: A) These are the correct steps.
, Rationale: The described sequence correctly outlines the
keyboard-only method to select a cell reference from another
worksheet while editing a formula. Ctrl + PageUp/PageDown is
the shortcut for navigating between worksheets.
Question 5
What is the keyboard command sequence to autofit the row height of a
selected row or range of rows?
A) Alt + O + C + A
B) Alt + O + C + W
C) Alt + H + O + H
D) Alt + H + O + A
E) Alt + R + H + A
Correct Answer: D) Alt + H + O + A
Rationale: The sequence Alt + H (Home tab) + O (Format dropdown)
+ A (AutoFit Row Height) is the correct shortcut. Alt + O + C + A is
for autofit column width, Alt + H + O + H is for setting row height
manually.
Question 6
What is the command to change the zoom size within an Excel worksheet?
A) Alt + V + Z
B) Alt + T + O + V
C) Alt + H + O + I
D) Alt + H + V + T
E) Ctrl + Scroll Wheel
Correct Answer: A) Alt + V + Z
Rationale: The sequence Alt + V (View tab) + Z (Zoom) opens the
Zoom dialog box. Ctrl + Scroll Wheel also changes zoom but the
question asks for a command sequence. Other options are incorrect.
Question 7
What is the keyboard shortcut to open the "Format Cells" dialog box?
, A) Ctrl + 1
B) Ctrl + 2
C) Ctrl + Shift + 1
D) Ctrl + Shift + 2
E) Ctrl + F1
Correct Answer: A) Ctrl + 1
Rationale: Ctrl + 1 is the universal keyboard shortcut to open the
Format Cells dialog box in Excel. Ctrl + Shift + 1 cycles number
formats, and other options are incorrect for this specific action.
Question 8
What are the keyboard shortcuts for auto-fitting a range of columns?
A) 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.
B) 1) Hold down the Shift key and use left and right arrow keys to select
columns desired. 2) Hit Alt + H + O + I to auto fit the columns.
C) 1) Select the columns by hitting Shift + Spacebar. 2) Hold down the Ctrl
key and use left and right arrow keys to highlight the range of columns. 3)
Hit Alt + H + O + W to auto fit the columns.
D) 1) Select the columns by hitting Shift + 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 + W to auto fit the columns.
E) 1) Select the columns by hitting Ctrl + A. 2) Hit Alt + H + O + A to auto fit
the columns.
Correct Answer: A) 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.
Rationale: Ctrl + Spacebar selects the entire column. Then, Shift +
arrow keys extends the selection to a range of columns. Finally, Alt
