EXCEL CRASH COURSE EXAM 2026 LATEST VERSION FROM
WALL STREET QUESTIONS AND 100% CORRECT ANSWERS
(BRAND NEW!!)/WSP EXCEL CRASH COURSE
Excel Crash Course Exam
Instructions: Choose the best answer for each of the following questions.
Section 1: Excel Fundamentals (Questions 1-10)
1. In Excel, a file is typically referred to as a:
a) Worksheet
b) Workbook
c) Spreadsheet
d) Document
Answer: b) Workbook
Rationale: A workbook is the Excel file itself, which can contain one or multiple
worksheets (also called spreadsheets). A worksheet is a single page within the
workbook.
2. A cell is identified by its:
a) Row number and column number
b) Column letter and row number
c) Name Box entry
d) Formula Bar reference
Answer: b) Column letter and row number
Rationale: The cell address uses the column letter first, followed by the row number (e.g.,
A1, B5, Z100). This is known as the cell reference.
3. Which of the following is the correct syntax for a basic formula?
a) =A1+A2
, b) A1+A2
c) SUM(A1+A2)
d) =SUM A1+A2
Answer: a) =A1+A2
Rationale: All Excel formulas and functions must begin with an equals sign (=) to signal
to the program that a calculation is to be performed.
4. What is the keyboard shortcut to save a workbook?
a) Ctrl + S
b) Ctrl + N
c) Ctrl + P
d) Ctrl + O
Answer: a) Ctrl + S
Rationale: Ctrl + S is the universal shortcut for "Save." Ctrl + N creates a new workbook,
Ctrl + P prints, and Ctrl + O opens an existing workbook.
5. What does the "Name Box" show?
a) The formula in the active cell
b) The address of the active cell
c) The sum of selected cells
d) The name of the active worksheet
Answer: b) The address of the active cell
Rationale: The Name Box is located to the left of the formula bar and displays the cell
reference (e.g., B4) of the currently selected cell. It can also be used to create named
ranges.
6. Which tab contains the "Paste Special" command?
a) Home
b) Insert
c) Page Layout
d) Data
Answer: a) Home
Rationale: The "Paste Special" command is found under the "Paste" dropdown button
on the Home tab. It allows for advanced pasting options like pasting only values,
formats, or formulas.
7. To move to the very last cell containing data in a worksheet, you can press:
a) Ctrl + End
WALL STREET QUESTIONS AND 100% CORRECT ANSWERS
(BRAND NEW!!)/WSP EXCEL CRASH COURSE
Excel Crash Course Exam
Instructions: Choose the best answer for each of the following questions.
Section 1: Excel Fundamentals (Questions 1-10)
1. In Excel, a file is typically referred to as a:
a) Worksheet
b) Workbook
c) Spreadsheet
d) Document
Answer: b) Workbook
Rationale: A workbook is the Excel file itself, which can contain one or multiple
worksheets (also called spreadsheets). A worksheet is a single page within the
workbook.
2. A cell is identified by its:
a) Row number and column number
b) Column letter and row number
c) Name Box entry
d) Formula Bar reference
Answer: b) Column letter and row number
Rationale: The cell address uses the column letter first, followed by the row number (e.g.,
A1, B5, Z100). This is known as the cell reference.
3. Which of the following is the correct syntax for a basic formula?
a) =A1+A2
, b) A1+A2
c) SUM(A1+A2)
d) =SUM A1+A2
Answer: a) =A1+A2
Rationale: All Excel formulas and functions must begin with an equals sign (=) to signal
to the program that a calculation is to be performed.
4. What is the keyboard shortcut to save a workbook?
a) Ctrl + S
b) Ctrl + N
c) Ctrl + P
d) Ctrl + O
Answer: a) Ctrl + S
Rationale: Ctrl + S is the universal shortcut for "Save." Ctrl + N creates a new workbook,
Ctrl + P prints, and Ctrl + O opens an existing workbook.
5. What does the "Name Box" show?
a) The formula in the active cell
b) The address of the active cell
c) The sum of selected cells
d) The name of the active worksheet
Answer: b) The address of the active cell
Rationale: The Name Box is located to the left of the formula bar and displays the cell
reference (e.g., B4) of the currently selected cell. It can also be used to create named
ranges.
6. Which tab contains the "Paste Special" command?
a) Home
b) Insert
c) Page Layout
d) Data
Answer: a) Home
Rationale: The "Paste Special" command is found under the "Paste" dropdown button
on the Home tab. It allows for advanced pasting options like pasting only values,
formats, or formulas.
7. To move to the very last cell containing data in a worksheet, you can press:
a) Ctrl + End
