WGU D100: Introduction to
Spreadsheets – Final Exam Practice
Test (2026 Edition)||| questions and
answers with rationales/graded
A+/2026 update/100% correct
/instant download
Total Questions: 85
Format: Multiple Choice
Instructions: Select the best answer for each question. Correct answers are
highlighted in bold.
Section 1: Spreadsheet Fundamentals & Navigation (Questions 1–12)
1. In Excel, what is the intersection of a row and a column called?
A) Range
B) Worksheet
C) Cell
D) Tab
Rationale: A cell is the basic unit, identified by its column letter and row number
(e.g., B4).
2. Which keyboard shortcut opens the "Go To" dialog box?
A) Ctrl + G
B) Ctrl + F
C) Ctrl + H
D) Ctrl + A
Rationale: Ctrl+G opens Go To; Ctrl+F is Find; Ctrl+H is Replace.
3. What does the "Name Box" display?
A) Formula result
,B) Active cell reference
C) Workbook name
D) Function argument
Rationale: Name Box shows the address (e.g., C10) or named range of the selected
cell.
4. How can you quickly select an entire column?
A) Ctrl + Spacebar
B) Shift + Spacebar
C) Ctrl + Shift + L
D) Alt + Enter
Rationale: Click column letter or Ctrl+Spacebar selects entire column;
Shift+Spacebar selects row.
5. Which view is best for checking page breaks before printing?
A) Normal
B) Page Layout
C) Page Break Preview
D) Custom Views
Rationale: Page Break Preview shows dashed lines indicating where pages will
break.
6. What does "Ctrl + Page Down" do?
A) Moves to next worksheet
B) Scrolls down one screen
C) Moves to last cell
D) Opens print preview
Rationale: Ctrl+Page Down moves to the next sheet to the right.
7. A relative cell reference (e.g., A1) when copied from row 5 to row 6 will
change to:
A) AA1
B) A2
C) A2 (if formula in column A)
D) B1
Rationale: Relative references adjust based on relative movement; copying down
one row increments row number.
, 8. Which symbol is used to anchor a row or column in an absolute reference?
A) @
B) #
C) $
D) &
Rationale: locksreference;locksreference;A1locksboth,A1locksboth,A1 locks row,
$A1 locks column.
9. What file extension is used for Excel macro-enabled workbooks?
A) .xlsx
B) .xlsm
C) .xls
D) .csv
Rationale: .xlsm supports VBA macros; .xlsx does not.
10. Which feature freezes top row while scrolling?
A) Split
B) Freeze Top Row
C) New Window
D) Arrange All
Rationale: View → Freeze Panes → Freeze Top Row keeps row 1 visible.
11. What is the maximum number of rows in Excel 2026 (Microsoft 365)?
A) 65,536
B) 1,048,576
C) 16,384
D) 256
Rationale: Excel supports 1,048,576 rows and 16,384 columns.
12. Which of the following is NOT a valid cell reference?
A) AAAA10
B) 10A
C) XFD1048576
D) B$4
Rationale: Column letter must precede row number; 10A is invalid.
Spreadsheets – Final Exam Practice
Test (2026 Edition)||| questions and
answers with rationales/graded
A+/2026 update/100% correct
/instant download
Total Questions: 85
Format: Multiple Choice
Instructions: Select the best answer for each question. Correct answers are
highlighted in bold.
Section 1: Spreadsheet Fundamentals & Navigation (Questions 1–12)
1. In Excel, what is the intersection of a row and a column called?
A) Range
B) Worksheet
C) Cell
D) Tab
Rationale: A cell is the basic unit, identified by its column letter and row number
(e.g., B4).
2. Which keyboard shortcut opens the "Go To" dialog box?
A) Ctrl + G
B) Ctrl + F
C) Ctrl + H
D) Ctrl + A
Rationale: Ctrl+G opens Go To; Ctrl+F is Find; Ctrl+H is Replace.
3. What does the "Name Box" display?
A) Formula result
,B) Active cell reference
C) Workbook name
D) Function argument
Rationale: Name Box shows the address (e.g., C10) or named range of the selected
cell.
4. How can you quickly select an entire column?
A) Ctrl + Spacebar
B) Shift + Spacebar
C) Ctrl + Shift + L
D) Alt + Enter
Rationale: Click column letter or Ctrl+Spacebar selects entire column;
Shift+Spacebar selects row.
5. Which view is best for checking page breaks before printing?
A) Normal
B) Page Layout
C) Page Break Preview
D) Custom Views
Rationale: Page Break Preview shows dashed lines indicating where pages will
break.
6. What does "Ctrl + Page Down" do?
A) Moves to next worksheet
B) Scrolls down one screen
C) Moves to last cell
D) Opens print preview
Rationale: Ctrl+Page Down moves to the next sheet to the right.
7. A relative cell reference (e.g., A1) when copied from row 5 to row 6 will
change to:
A) AA1
B) A2
C) A2 (if formula in column A)
D) B1
Rationale: Relative references adjust based on relative movement; copying down
one row increments row number.
, 8. Which symbol is used to anchor a row or column in an absolute reference?
A) @
B) #
C) $
D) &
Rationale: locksreference;locksreference;A1locksboth,A1locksboth,A1 locks row,
$A1 locks column.
9. What file extension is used for Excel macro-enabled workbooks?
A) .xlsx
B) .xlsm
C) .xls
D) .csv
Rationale: .xlsm supports VBA macros; .xlsx does not.
10. Which feature freezes top row while scrolling?
A) Split
B) Freeze Top Row
C) New Window
D) Arrange All
Rationale: View → Freeze Panes → Freeze Top Row keeps row 1 visible.
11. What is the maximum number of rows in Excel 2026 (Microsoft 365)?
A) 65,536
B) 1,048,576
C) 16,384
D) 256
Rationale: Excel supports 1,048,576 rows and 16,384 columns.
12. Which of the following is NOT a valid cell reference?
A) AAAA10
B) 10A
C) XFD1048576
D) B$4
Rationale: Column letter must precede row number; 10A is invalid.
