WGU D100 Introduction to Spreadsheets
Actual Exam QUESTIONS AND ANSWERS
2026 | Complete Guide A+ Graded | Pass
Guaranteed - A+ Graded
Section 1: Spreadsheet Fundamentals and Navigation
Questions 1-8
Question 1 In Microsoft Excel, what is the default file extension for a standard workbook?
A. .xltx
B. .xlsx [CORRECT]
C. .xlsm
D. .csv
Correct Answer: B
Rationale: .xlsx is the default file extension for Excel workbooks in Excel 2007 and later, using
the Open XML format. .xltx (A) is a template file extension. .xlsm (C) is a macro-enabled
workbook that allows VBA macros. .csv (D) is a comma-separated values text file format that
loses formatting and formulas. Understanding file extensions is crucial for saving work correctly
and ensuring compatibility.
Question 2 To freeze the top row of a worksheet so it remains visible while scrolling down,
which command should you use?
A. Split
B. Freeze Panes > Freeze Top Row [CORRECT]
C. Freeze Panes > Freeze First Column
D. View Side by Side
Correct Answer: B
Rationale: "Freeze Top Row" keeps the first row visible when scrolling down through data,
essential for viewing headers. "Freeze First Column" (C) keeps the first column visible when
scrolling right. "Freeze Panes" (not listed) allows freezing at any selected cell. Split (A) divides
,the window into independently scrollable panes. View Side by Side (D) compares two
workbooks simultaneously. Freezing panes improves navigation in large datasets.
Question 3 Which keyboard shortcut is used to open the "Go To" dialog box?
A. Ctrl + G [CORRECT]
B. Ctrl + F
C. Ctrl + H
D. Ctrl + K
Correct Answer: A
Rationale: Ctrl + G opens the "Go To" dialog box, allowing quick navigation to specific cells,
named ranges, or special cells (blanks, formulas, etc.). Ctrl + F (B) opens Find. Ctrl + H (C)
opens Find and Replace. Ctrl + K (D) inserts a hyperlink. Mastering keyboard shortcuts
improves spreadsheet efficiency significantly.
Question 4 Which of the following is NOT a standard workbook view in Excel?
A. Normal
B. Page Layout
C. Page Break Preview
D. Slide Show [CORRECT]
Correct Answer: D
Rationale: Slide Show is a PowerPoint feature, not an Excel workbook view. Excel's standard
views are: Normal (standard editing view), Page Layout (shows pages as printed with
headers/footers), and Page Break Preview (shows page breaks with page numbers).
Understanding views helps with editing and printing preparation. Slide Show (D) is included as a
distractor because students might confuse Office applications.
Question 5 To select all cells in a worksheet, which shortcut should you use?
A. Ctrl + A
B. Ctrl + Shift + Space
C. Click the Select All button (intersection of row and column headers) [CORRECT]
D. Both A and C [CORRECT]
Correct Answer: D
, Rationale: Both methods select all cells: Ctrl + A selects the current region first, then all cells on
second press; clicking the Select All button (the gray square at the intersection of row and
column headers) immediately selects all. Ctrl + Shift + Space (B) selects the current data region.
Knowing multiple selection methods improves efficiency. In practice, both A and C accomplish
the task, though Ctrl + A may require two presses depending on context.
Question 6 When printing a large worksheet, which option allows you to fit the content to a
specific number of pages wide and tall?
A. Print Active Sheets
B. Scale to Fit [CORRECT]
C. Print Selection
D. Print Entire Workbook
Correct Answer: B
Rationale: Scale to Fit (in Page Layout tab) allows specifying width and height in pages,
automatically scaling content to fit. This prevents data being cut off or printed across too many
pages. Print Active Sheets (A) prints the current sheet. Print Selection (C) prints only selected
cells. Print Entire Workbook (D) prints all sheets. Scale to Fit is essential for professional
document presentation.
Question 7 Which feature allows you to view two different parts of the same worksheet
simultaneously?
A. Freeze Panes
B. Split [CORRECT]
C. New Window
D. Arrange All
Correct Answer: B
Rationale: Split divides the worksheet window into independently scrollable panes, allowing
viewing of different areas simultaneously (e.g., row 1 headers and row 5000 data). Freeze Panes
(A) keeps rows/columns visible while scrolling but doesn't create independent panes. New
Window (C) creates a second window of the same workbook. Arrange All (D) arranges multiple
open windows. Split is useful for comparing distant data in large worksheets.
Question 8 To quickly move to the last cell with data in a worksheet, which keyboard shortcut
should you use?
Actual Exam QUESTIONS AND ANSWERS
2026 | Complete Guide A+ Graded | Pass
Guaranteed - A+ Graded
Section 1: Spreadsheet Fundamentals and Navigation
Questions 1-8
Question 1 In Microsoft Excel, what is the default file extension for a standard workbook?
A. .xltx
B. .xlsx [CORRECT]
C. .xlsm
D. .csv
Correct Answer: B
Rationale: .xlsx is the default file extension for Excel workbooks in Excel 2007 and later, using
the Open XML format. .xltx (A) is a template file extension. .xlsm (C) is a macro-enabled
workbook that allows VBA macros. .csv (D) is a comma-separated values text file format that
loses formatting and formulas. Understanding file extensions is crucial for saving work correctly
and ensuring compatibility.
Question 2 To freeze the top row of a worksheet so it remains visible while scrolling down,
which command should you use?
A. Split
B. Freeze Panes > Freeze Top Row [CORRECT]
C. Freeze Panes > Freeze First Column
D. View Side by Side
Correct Answer: B
Rationale: "Freeze Top Row" keeps the first row visible when scrolling down through data,
essential for viewing headers. "Freeze First Column" (C) keeps the first column visible when
scrolling right. "Freeze Panes" (not listed) allows freezing at any selected cell. Split (A) divides
,the window into independently scrollable panes. View Side by Side (D) compares two
workbooks simultaneously. Freezing panes improves navigation in large datasets.
Question 3 Which keyboard shortcut is used to open the "Go To" dialog box?
A. Ctrl + G [CORRECT]
B. Ctrl + F
C. Ctrl + H
D. Ctrl + K
Correct Answer: A
Rationale: Ctrl + G opens the "Go To" dialog box, allowing quick navigation to specific cells,
named ranges, or special cells (blanks, formulas, etc.). Ctrl + F (B) opens Find. Ctrl + H (C)
opens Find and Replace. Ctrl + K (D) inserts a hyperlink. Mastering keyboard shortcuts
improves spreadsheet efficiency significantly.
Question 4 Which of the following is NOT a standard workbook view in Excel?
A. Normal
B. Page Layout
C. Page Break Preview
D. Slide Show [CORRECT]
Correct Answer: D
Rationale: Slide Show is a PowerPoint feature, not an Excel workbook view. Excel's standard
views are: Normal (standard editing view), Page Layout (shows pages as printed with
headers/footers), and Page Break Preview (shows page breaks with page numbers).
Understanding views helps with editing and printing preparation. Slide Show (D) is included as a
distractor because students might confuse Office applications.
Question 5 To select all cells in a worksheet, which shortcut should you use?
A. Ctrl + A
B. Ctrl + Shift + Space
C. Click the Select All button (intersection of row and column headers) [CORRECT]
D. Both A and C [CORRECT]
Correct Answer: D
, Rationale: Both methods select all cells: Ctrl + A selects the current region first, then all cells on
second press; clicking the Select All button (the gray square at the intersection of row and
column headers) immediately selects all. Ctrl + Shift + Space (B) selects the current data region.
Knowing multiple selection methods improves efficiency. In practice, both A and C accomplish
the task, though Ctrl + A may require two presses depending on context.
Question 6 When printing a large worksheet, which option allows you to fit the content to a
specific number of pages wide and tall?
A. Print Active Sheets
B. Scale to Fit [CORRECT]
C. Print Selection
D. Print Entire Workbook
Correct Answer: B
Rationale: Scale to Fit (in Page Layout tab) allows specifying width and height in pages,
automatically scaling content to fit. This prevents data being cut off or printed across too many
pages. Print Active Sheets (A) prints the current sheet. Print Selection (C) prints only selected
cells. Print Entire Workbook (D) prints all sheets. Scale to Fit is essential for professional
document presentation.
Question 7 Which feature allows you to view two different parts of the same worksheet
simultaneously?
A. Freeze Panes
B. Split [CORRECT]
C. New Window
D. Arrange All
Correct Answer: B
Rationale: Split divides the worksheet window into independently scrollable panes, allowing
viewing of different areas simultaneously (e.g., row 1 headers and row 5000 data). Freeze Panes
(A) keeps rows/columns visible while scrolling but doesn't create independent panes. New
Window (C) creates a second window of the same workbook. Arrange All (D) arranges multiple
open windows. Split is useful for comparing distant data in large worksheets.
Question 8 To quickly move to the last cell with data in a worksheet, which keyboard shortcut
should you use?
