EXCEL CRASH COURSE EXAM 2026 LATEST VERSION FROM
WALL STREET QUESTIONS AND 100% CORRECT ANSWERS
(BRAND NEW!!)/WSP EXCEL CRASH COURSE
Answers presented at the end of the test.
Section 1: The Basics (Questions 1-10)
1. In Excel, a file is commonly referred to as a:
a) Worksheet
b) Workbook
c) Spreadsheet
d) Document
2. A cell is identified by its:
a) Row number and column letter
b) Column letter and row number
c) Cell content and value
d) Formula bar reference
3. What is the keyboard shortcut to save a workbook?
a) Ctrl + N
b) Ctrl + O
c) Ctrl + S
d) Ctrl + P
4. What does the "Fill Handle" (the small square at the bottom-right of a selected
cell) allow you to do?
a) Delete the cell's contents
b) Copy the cell's contents or continue a series into adjacent cells
c) Change the font size of the cell
d) Insert a comment into the cell
5. Which view is best for seeing how your spreadsheet will look on paper?
a) Normal View
b) Page Layout View
c) Page Break Preview
d) Custom Views
, 6. To select an entire column, you would:
a) Click the row number on the left
b) Press Ctrl + A
c) Click the column letter at the top
d) Double-click any cell in the column
7. Which tab contains the "Paste Special" option?
a) Insert
b) Formulas
c) Data
d) Home
8. What does the "Wrap Text" feature do?
a) Automatically saves the workbook
b) Displays the content of a cell on multiple lines within the same cell
c) Deletes text that is too long for a cell
d) Copies text to a new worksheet
9. The "Name Box" is located to the left of the formula bar and is used to:
a) Display the result of a formula
b) Show the active cell's address or defined name
c) Enter new formulas
d) Format the font of the selected cell
10. To insert a new worksheet into your workbook, you can click the:
a) "New" button on the Quick Access Toolbar
b) Plus (+) icon next to the existing sheet tabs
c) "Insert" tab and then "New Sheet"
d) "Page Layout" tab and then "Insert Sheet"
Section 2: Formulas & Functions (Questions 11-25)
11. All Excel formulas must begin with which symbol?
a) @
b) #
c) =
d) &
WALL STREET QUESTIONS AND 100% CORRECT ANSWERS
(BRAND NEW!!)/WSP EXCEL CRASH COURSE
Answers presented at the end of the test.
Section 1: The Basics (Questions 1-10)
1. In Excel, a file is commonly referred to as a:
a) Worksheet
b) Workbook
c) Spreadsheet
d) Document
2. A cell is identified by its:
a) Row number and column letter
b) Column letter and row number
c) Cell content and value
d) Formula bar reference
3. What is the keyboard shortcut to save a workbook?
a) Ctrl + N
b) Ctrl + O
c) Ctrl + S
d) Ctrl + P
4. What does the "Fill Handle" (the small square at the bottom-right of a selected
cell) allow you to do?
a) Delete the cell's contents
b) Copy the cell's contents or continue a series into adjacent cells
c) Change the font size of the cell
d) Insert a comment into the cell
5. Which view is best for seeing how your spreadsheet will look on paper?
a) Normal View
b) Page Layout View
c) Page Break Preview
d) Custom Views
, 6. To select an entire column, you would:
a) Click the row number on the left
b) Press Ctrl + A
c) Click the column letter at the top
d) Double-click any cell in the column
7. Which tab contains the "Paste Special" option?
a) Insert
b) Formulas
c) Data
d) Home
8. What does the "Wrap Text" feature do?
a) Automatically saves the workbook
b) Displays the content of a cell on multiple lines within the same cell
c) Deletes text that is too long for a cell
d) Copies text to a new worksheet
9. The "Name Box" is located to the left of the formula bar and is used to:
a) Display the result of a formula
b) Show the active cell's address or defined name
c) Enter new formulas
d) Format the font of the selected cell
10. To insert a new worksheet into your workbook, you can click the:
a) "New" button on the Quick Access Toolbar
b) Plus (+) icon next to the existing sheet tabs
c) "Insert" tab and then "New Sheet"
d) "Page Layout" tab and then "Insert Sheet"
Section 2: Formulas & Functions (Questions 11-25)
11. All Excel formulas must begin with which symbol?
a) @
b) #
c) =
d) &
