WALL STREET PREP:EXCEL CRASH COURS /EXCEL CRASH
COURSE EXAM 2026 LATEST VERSION FROM WALL STREET
QUESTIONS AND 100% CORRECT ANSWERS (BRAND
NEW!!)/WSP EXCEL CRASH COURSE.
A user is entering a formula in Excel and types the "=" sign to
begin. What does the "=" sign tell Excel about the information
that follows?
a. The information should be treated as plain text
b. The information should be treated as a formula
c. The information should be treated as a comment
d. The information should be treated as a hyperlink
✔️ Correct Answer: B
Rationale: The "=" sign tells Excel that the information that
follows should be treated as a formula and not as plain text.
This is the fundamental way Excel distinguishes formulas from
text entries. Without the "=" sign, Excel will treat the entry as
plain text rather than performing calculations. Options A, C, and
D are incorrect because they do not describe the function of the
"=" sign.
Which keyboard shortcut is used to open the Format Cells
dialog box in Excel?
a. Ctrl+1
b. Ctrl+2
,c. Ctrl+3
d. Ctrl+4
✔️ Correct Answer: A
Rationale: Ctrl+1 is the keyboard shortcut to open the Format
Cells dialog box. This is a quick way to access formatting options
such as Number, Alignment, Font, Border, and Fill. Options B, C,
and D are incorrect because they do not open the Format Cells
dialog box.
What does the keyboard shortcut Ctrl+Shift+Arrows
(Cmnd+Shift+Arrows) do in Excel?
a. Highlights a non-contiguous range
b. Highlights a contiguous range
c. Selects the entire worksheet
d. Moves to the next worksheet
✔️ Correct Answer: B
Rationale: Ctrl+Shift+Arrows (Cmnd+Shift+Arrows on Mac)
highlights a contiguous range of cells in the direction of the
arrow key until a blank cell is reached. This is a quick way to
select large ranges of data. Option A is incorrect because
Ctrl+Click selects non-contiguous ranges. Option C is incorrect
because Ctrl+A selects the entire worksheet. Option D is
incorrect because Ctrl+PageUp/PageDown moves between
worksheets.
Which keyboard shortcut is used to toggle between open
workbooks in Excel?
,a. Ctrl+Tab
b. Ctrl+Shift+Tab
c. Alt+Tab
d. Ctrl+W
✔️ Correct Answer: A
Rationale: Ctrl+Tab toggles between open workbooks in Excel.
This is a quick way to navigate between multiple open files.
Ctrl+Shift+Tab moves in the opposite direction. Alt+Tab toggles
between all open applications, not just Excel workbooks. Ctrl+W
closes the current workbook.
What is the purpose of the Paste Special feature in Excel?
a. To paste data with formatting
b. To dictate specific attributes of a cell or highlighted region
that should be pasted
c. To paste data as a hyperlink
d. To paste data into a new worksheet
✔️ Correct Answer: B
Rationale: Paste Special (Alt+E+S or Ctrl+Alt+V) allows the user
to dictate the specific attributes of a cell or highlighted region
that should be pasted. This includes pasting values only,
formulas only, formatting, comments, and more. Options A, C,
and D are not the primary purpose of Paste Special.
What is the primary purpose of freezing panes in Excel?
a. To prevent data from being edited
b. To keep specific rows and columns visible when scrolling
, c. To protect the worksheet from changes
d. To create a new worksheet
✔️ Correct Answer: B
Rationale: Freezing panes keeps specific rows and columns
visible when scrolling through a large worksheet. This allows
users to keep headers or labels visible while scrolling through
data. Option A is incorrect because freezing panes does not
prevent editing. Option C is incorrect because protection is a
separate feature. Option D is incorrect because freezing panes
does not create a new worksheet.
Which keyboard shortcut is used to enter an active cell in Excel?
a. F2
b. F3
c. F4
d. F5
✔️ Correct Answer: A
Rationale: F2 (Fn+F2 on Mac) is used to enter an active cell in
Excel, allowing the user to edit the contents of the cell directly.
F3 is used to paste a named range. F4 repeats the last action or
toggles anchoring in a formula. F5 opens the Go To dialog box.
What is the keyboard shortcut to redo an action in Excel?
a. Ctrl+Y
b. Ctrl+Z
c. Ctrl+X
d. Ctrl+C
COURSE EXAM 2026 LATEST VERSION FROM WALL STREET
QUESTIONS AND 100% CORRECT ANSWERS (BRAND
NEW!!)/WSP EXCEL CRASH COURSE.
A user is entering a formula in Excel and types the "=" sign to
begin. What does the "=" sign tell Excel about the information
that follows?
a. The information should be treated as plain text
b. The information should be treated as a formula
c. The information should be treated as a comment
d. The information should be treated as a hyperlink
✔️ Correct Answer: B
Rationale: The "=" sign tells Excel that the information that
follows should be treated as a formula and not as plain text.
This is the fundamental way Excel distinguishes formulas from
text entries. Without the "=" sign, Excel will treat the entry as
plain text rather than performing calculations. Options A, C, and
D are incorrect because they do not describe the function of the
"=" sign.
Which keyboard shortcut is used to open the Format Cells
dialog box in Excel?
a. Ctrl+1
b. Ctrl+2
,c. Ctrl+3
d. Ctrl+4
✔️ Correct Answer: A
Rationale: Ctrl+1 is the keyboard shortcut to open the Format
Cells dialog box. This is a quick way to access formatting options
such as Number, Alignment, Font, Border, and Fill. Options B, C,
and D are incorrect because they do not open the Format Cells
dialog box.
What does the keyboard shortcut Ctrl+Shift+Arrows
(Cmnd+Shift+Arrows) do in Excel?
a. Highlights a non-contiguous range
b. Highlights a contiguous range
c. Selects the entire worksheet
d. Moves to the next worksheet
✔️ Correct Answer: B
Rationale: Ctrl+Shift+Arrows (Cmnd+Shift+Arrows on Mac)
highlights a contiguous range of cells in the direction of the
arrow key until a blank cell is reached. This is a quick way to
select large ranges of data. Option A is incorrect because
Ctrl+Click selects non-contiguous ranges. Option C is incorrect
because Ctrl+A selects the entire worksheet. Option D is
incorrect because Ctrl+PageUp/PageDown moves between
worksheets.
Which keyboard shortcut is used to toggle between open
workbooks in Excel?
,a. Ctrl+Tab
b. Ctrl+Shift+Tab
c. Alt+Tab
d. Ctrl+W
✔️ Correct Answer: A
Rationale: Ctrl+Tab toggles between open workbooks in Excel.
This is a quick way to navigate between multiple open files.
Ctrl+Shift+Tab moves in the opposite direction. Alt+Tab toggles
between all open applications, not just Excel workbooks. Ctrl+W
closes the current workbook.
What is the purpose of the Paste Special feature in Excel?
a. To paste data with formatting
b. To dictate specific attributes of a cell or highlighted region
that should be pasted
c. To paste data as a hyperlink
d. To paste data into a new worksheet
✔️ Correct Answer: B
Rationale: Paste Special (Alt+E+S or Ctrl+Alt+V) allows the user
to dictate the specific attributes of a cell or highlighted region
that should be pasted. This includes pasting values only,
formulas only, formatting, comments, and more. Options A, C,
and D are not the primary purpose of Paste Special.
What is the primary purpose of freezing panes in Excel?
a. To prevent data from being edited
b. To keep specific rows and columns visible when scrolling
, c. To protect the worksheet from changes
d. To create a new worksheet
✔️ Correct Answer: B
Rationale: Freezing panes keeps specific rows and columns
visible when scrolling through a large worksheet. This allows
users to keep headers or labels visible while scrolling through
data. Option A is incorrect because freezing panes does not
prevent editing. Option C is incorrect because protection is a
separate feature. Option D is incorrect because freezing panes
does not create a new worksheet.
Which keyboard shortcut is used to enter an active cell in Excel?
a. F2
b. F3
c. F4
d. F5
✔️ Correct Answer: A
Rationale: F2 (Fn+F2 on Mac) is used to enter an active cell in
Excel, allowing the user to edit the contents of the cell directly.
F3 is used to paste a named range. F4 repeats the last action or
toggles anchoring in a formula. F5 opens the Go To dialog box.
What is the keyboard shortcut to redo an action in Excel?
a. Ctrl+Y
b. Ctrl+Z
c. Ctrl+X
d. Ctrl+C
