EXCEL CRASH COURSE EXAM 2026
LATEST VERSION FROM WALL STREET
QUESTIONS AND 100% CORRECT
ANSWERS PLUS RATIONALES (BRAND
NEW!!)/WSP EXCEL CRASH COURSE
1. What is a workbook in Excel?
A. A single cell
B. A collection of worksheets
C. A formula
D. A chart
✅ Answer: B
📌 Rationale: A workbook is an Excel file that contains one or more worksheets.
2. What is the intersection of a row and a column called?
A. Range
B. Cell
C. Worksheet
D. Table
✅ Answer: B
📌 Rationale: A cell is formed where a row and a column meet.
3. Which file extension is used by modern Excel versions?
A. .xls
B. .docx
C. .xlsx
D. .pptx
✅ Answer: C
📌 Rationale: .xlsx is the default Excel file format since Excel 2007.
,4. How many rows does Excel support (Excel 2016 and later)?
A. 65,536
B. 1,048,576
C. 500,000
D. Unlimited
✅ Answer: B
📌 Rationale: Modern Excel versions support 1,048,576 rows per worksheet.
5. How many columns are available in Excel?
A. 256
B. 1,024
C. 16,384
D. Unlimited
✅ Answer: C
📌 Rationale: Excel columns run from A to XFD, totaling 16,384 columns.
6. Which key combination saves a workbook?
A. Ctrl + A
B. Ctrl + P
C. Ctrl + S
D. Ctrl + Z
✅ Answer: C
📌 Rationale: Ctrl + S saves the current workbook.
7. Which symbol is used to start a formula in Excel?
A. +
B. #
C. =
D. @
✅ Answer: C
📌 Rationale: All Excel formulas must begin with an equals sign (=).
, 8. Which of the following is NOT a valid cell reference?
A. A1
B. B10
C. 1A
D. AA5
✅ Answer: C
📌 Rationale: Cell references must start with a column letter followed by a row number.
9. What does the Name Box display?
A. Worksheet name
B. File name
C. Active cell reference
D. Formula result
✅ Answer: C
📌 Rationale: The Name Box shows the address of the currently selected cell.
10. Which key allows you to edit the active cell?
A. Enter
B. Esc
C. F2
D. Tab
✅ Answer: C
📌 Rationale: Pressing F2 places the cursor inside the active cell for editing.
11. What is a worksheet?
A. The Excel program
B. A single spreadsheet
C. A chart
D. A macro
✅ Answer: B
📌 Rationale: A worksheet is one spreadsheet within a workbook.
LATEST VERSION FROM WALL STREET
QUESTIONS AND 100% CORRECT
ANSWERS PLUS RATIONALES (BRAND
NEW!!)/WSP EXCEL CRASH COURSE
1. What is a workbook in Excel?
A. A single cell
B. A collection of worksheets
C. A formula
D. A chart
✅ Answer: B
📌 Rationale: A workbook is an Excel file that contains one or more worksheets.
2. What is the intersection of a row and a column called?
A. Range
B. Cell
C. Worksheet
D. Table
✅ Answer: B
📌 Rationale: A cell is formed where a row and a column meet.
3. Which file extension is used by modern Excel versions?
A. .xls
B. .docx
C. .xlsx
D. .pptx
✅ Answer: C
📌 Rationale: .xlsx is the default Excel file format since Excel 2007.
,4. How many rows does Excel support (Excel 2016 and later)?
A. 65,536
B. 1,048,576
C. 500,000
D. Unlimited
✅ Answer: B
📌 Rationale: Modern Excel versions support 1,048,576 rows per worksheet.
5. How many columns are available in Excel?
A. 256
B. 1,024
C. 16,384
D. Unlimited
✅ Answer: C
📌 Rationale: Excel columns run from A to XFD, totaling 16,384 columns.
6. Which key combination saves a workbook?
A. Ctrl + A
B. Ctrl + P
C. Ctrl + S
D. Ctrl + Z
✅ Answer: C
📌 Rationale: Ctrl + S saves the current workbook.
7. Which symbol is used to start a formula in Excel?
A. +
B. #
C. =
D. @
✅ Answer: C
📌 Rationale: All Excel formulas must begin with an equals sign (=).
, 8. Which of the following is NOT a valid cell reference?
A. A1
B. B10
C. 1A
D. AA5
✅ Answer: C
📌 Rationale: Cell references must start with a column letter followed by a row number.
9. What does the Name Box display?
A. Worksheet name
B. File name
C. Active cell reference
D. Formula result
✅ Answer: C
📌 Rationale: The Name Box shows the address of the currently selected cell.
10. Which key allows you to edit the active cell?
A. Enter
B. Esc
C. F2
D. Tab
✅ Answer: C
📌 Rationale: Pressing F2 places the cursor inside the active cell for editing.
11. What is a worksheet?
A. The Excel program
B. A single spreadsheet
C. A chart
D. A macro
✅ Answer: B
📌 Rationale: A worksheet is one spreadsheet within a workbook.
