EXCEL CRASH COURSE EXAM 2026 LATEST VERSION FROM
WALL STREET QUESTIONS AND 100% CORRECT ANSWERS
(BRAND NEW!!)/WSP EXCEL CRASH COURSE
Section 1: The Interface & Basic Navigation (Questions 1-5)
1. What does the "Name Box" display?
a) The name of the current workbook
b) The formula contained in the active cell
c) The address or defined name of the active cell
d) The name of the active worksheet
Answer: c) The address or defined name of the active cell
Rationale: The Name Box is located to the left of the formula bar. Its primary function is to
show the reference (e.g., A1) of the currently selected cell or range. You can also use it to
navigate by typing a cell address and pressing Enter.
2. By default, how many worksheets does a new Excel workbook contain?
a) 1
b) 2
c) 3
d) 4
Answer: c) 3
Rationale: While this can be changed in the Excel options, the default setting for a new
blank workbook is three worksheets (Sheet1, Sheet2, Sheet3).
3. What is the keyboard shortcut to save a workbook?
a) Ctrl + S
b) Ctrl + C
c) Ctrl + N
d) Ctrl + P
Answer: a) Ctrl + S
Rationale: Ctrl+S is the universal shortcut for "Save." Ctrl+C is Copy, Ctrl+N is New
workbook, and Ctrl+P is Print.
4. If you see a series of "####" symbols in a cell, what does this indicate?
a) There is a circular reference error in the formula
b) The column is not wide enough to display the value
, c) The cell has been formatted as text but contains a number
d) The workbook is corrupted
Answer: b) The column is not wide enough to display the value
Rationale: Excel displays hash symbols when the content (a number, date, or long text) is
too wide for the current column width. Widening the column resolves the issue.
5. Which view allows you to see page breaks and add headers/footers?
a) Normal View
b) Page Break Preview
c) Page Layout View
d) Full Screen View
Answer: c) Page Layout View
Rationale: Page Layout View shows the worksheet as it would appear on paper. It allows
users to visually manage margins, headers, footers, and page breaks. Page Break Preview
is specifically for adjusting breaks.
Section 2: Formulas & Functions (Questions 6-20)
6. What symbol must be typed at the beginning of any formula or function?
a) '
b) @
c) =
d) #
Answer: c) =
Rationale: The equals sign tells Excel that the cell's contents should be evaluated as a
formula. Without it, Excel treats the input as text.
7. Which function would you use to find the largest number in a range of cells?
a) LARGE
b) MAX
c) HIGHEST
d) TOP
Answer: b) MAX
Rationale: The MAX function (e.g., =MAX(A1:A10)) returns the largest numeric value in a
WALL STREET QUESTIONS AND 100% CORRECT ANSWERS
(BRAND NEW!!)/WSP EXCEL CRASH COURSE
Section 1: The Interface & Basic Navigation (Questions 1-5)
1. What does the "Name Box" display?
a) The name of the current workbook
b) The formula contained in the active cell
c) The address or defined name of the active cell
d) The name of the active worksheet
Answer: c) The address or defined name of the active cell
Rationale: The Name Box is located to the left of the formula bar. Its primary function is to
show the reference (e.g., A1) of the currently selected cell or range. You can also use it to
navigate by typing a cell address and pressing Enter.
2. By default, how many worksheets does a new Excel workbook contain?
a) 1
b) 2
c) 3
d) 4
Answer: c) 3
Rationale: While this can be changed in the Excel options, the default setting for a new
blank workbook is three worksheets (Sheet1, Sheet2, Sheet3).
3. What is the keyboard shortcut to save a workbook?
a) Ctrl + S
b) Ctrl + C
c) Ctrl + N
d) Ctrl + P
Answer: a) Ctrl + S
Rationale: Ctrl+S is the universal shortcut for "Save." Ctrl+C is Copy, Ctrl+N is New
workbook, and Ctrl+P is Print.
4. If you see a series of "####" symbols in a cell, what does this indicate?
a) There is a circular reference error in the formula
b) The column is not wide enough to display the value
, c) The cell has been formatted as text but contains a number
d) The workbook is corrupted
Answer: b) The column is not wide enough to display the value
Rationale: Excel displays hash symbols when the content (a number, date, or long text) is
too wide for the current column width. Widening the column resolves the issue.
5. Which view allows you to see page breaks and add headers/footers?
a) Normal View
b) Page Break Preview
c) Page Layout View
d) Full Screen View
Answer: c) Page Layout View
Rationale: Page Layout View shows the worksheet as it would appear on paper. It allows
users to visually manage margins, headers, footers, and page breaks. Page Break Preview
is specifically for adjusting breaks.
Section 2: Formulas & Functions (Questions 6-20)
6. What symbol must be typed at the beginning of any formula or function?
a) '
b) @
c) =
d) #
Answer: c) =
Rationale: The equals sign tells Excel that the cell's contents should be evaluated as a
formula. Without it, Excel treats the input as text.
7. Which function would you use to find the largest number in a range of cells?
a) LARGE
b) MAX
c) HIGHEST
d) TOP
Answer: b) MAX
Rationale: The MAX function (e.g., =MAX(A1:A10)) returns the largest numeric value in a
