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 What is the default file extension for a standard Excel workbook in Excel 2007 and
later versions?
A. .xls
B. .xltx
C. .xlsx [CORRECT]
D. .csv
Correct Answer: C
Rationale: .xlsx is the default XML-based format for Excel 2007 and later, offering smaller file
sizes and better data recovery. Option A (.xls) is the legacy Excel 97-2003 binary format. Option
B (.xltx) is an Excel template format. Option D (.csv) is a comma-separated values text file that
stores data only, not formatting or formulas.
Question 2 Which keyboard shortcut opens the "Go To" dialog box, allowing you to quickly
navigate to a specific cell?
A. Ctrl + F
B. Ctrl + H
C. Ctrl + G [CORRECT]
D. Ctrl + K
Correct Answer: C
Rationale: Ctrl + G opens the "Go To" dialog for rapid navigation to any cell address or named
range. Option A (Ctrl + F) opens Find. Option B (Ctrl + H) opens Find and Replace. Option D
(Ctrl + K) inserts or edits a hyperlink.
,Question 3 To keep the top row visible while scrolling through a large dataset, which command
should you use?
A. Split
B. Freeze Panes > Freeze First Column
C. Freeze Panes > Freeze Top Row [CORRECT]
D. New Window
Correct Answer: C
Rationale: "Freeze Top Row" locks the first row in place during vertical scrolling, essential for
viewing headers with large datasets. Option A (Split) divides the window into scrollable panes.
Option B freezes the first column for horizontal scrolling. Option D creates a duplicate window
view of the same workbook.
Question 4 Which of the following is NOT a valid Excel workbook view?
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 view. Excel offers Normal (default
editing view), Page Layout (shows pages as printed), and Page Break Preview (displays page
breaks). Other valid views include Formula Bar and Full Screen.
Question 5 What happens when you press Ctrl + Home in Excel?
A. Moves to the last cell with data
B. Moves to cell A1 [CORRECT]
C. Moves to the current region
D. Opens the Home tab on the ribbon
Correct Answer: B
Rationale: Ctrl + Home navigates to cell A1 (or the top-left of the worksheet). Ctrl + End (A)
moves to the last cell with data. Ctrl + * (C) selects the current data region. Option D is
incorrect—Ctrl + Home does not activate ribbon tabs.
, Question 6 To save a workbook in a format that can be opened in Excel 2003 and earlier
versions, you should use:
A. .xlsx
B. .xls [CORRECT]
C. .xlsm
D. .pdf
Correct Answer: B
Rationale: The .xls format provides backward compatibility with Excel 97-2003. However, it
has limitations (65,536 rows, 256 columns, no new features). Option A (.xlsx) is not compatible
with Excel 2003 without a converter. Option C (.xlsm) is macro-enabled but still incompatible
with older versions. Option D (.pdf) is for viewing/printing only.
Question 7 Which feature allows you to view two different parts of the same worksheet
simultaneously?
A. Freeze Panes
B. Split [CORRECT]
C. Hide
D. Group
Correct Answer: B
Rationale: Split divides the worksheet window into two or four scrollable panes, allowing
simultaneous viewing of distant sections. Freeze Panes (A) locks rows/columns but doesn't
create independent scroll areas. Hide (C) conceals rows/columns. Group (D) creates outline
levels for data organization.
Question 8 To set a specific area of a worksheet to print (rather than the entire sheet), you
should:
A. Use Page Break Preview only
B. Define the Print Area [CORRECT]
C. Hide all other cells
D. Copy the data to a new sheet
Correct Answer: B
Rationale: Page Layout > Print Area > Set Print Area defines specific ranges to print. This is
more efficient than hiding cells (C) or creating new sheets (D). Page Break Preview (A) shows
breaks but doesn't limit printing to specific areas without setting the print area.
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 What is the default file extension for a standard Excel workbook in Excel 2007 and
later versions?
A. .xls
B. .xltx
C. .xlsx [CORRECT]
D. .csv
Correct Answer: C
Rationale: .xlsx is the default XML-based format for Excel 2007 and later, offering smaller file
sizes and better data recovery. Option A (.xls) is the legacy Excel 97-2003 binary format. Option
B (.xltx) is an Excel template format. Option D (.csv) is a comma-separated values text file that
stores data only, not formatting or formulas.
Question 2 Which keyboard shortcut opens the "Go To" dialog box, allowing you to quickly
navigate to a specific cell?
A. Ctrl + F
B. Ctrl + H
C. Ctrl + G [CORRECT]
D. Ctrl + K
Correct Answer: C
Rationale: Ctrl + G opens the "Go To" dialog for rapid navigation to any cell address or named
range. Option A (Ctrl + F) opens Find. Option B (Ctrl + H) opens Find and Replace. Option D
(Ctrl + K) inserts or edits a hyperlink.
,Question 3 To keep the top row visible while scrolling through a large dataset, which command
should you use?
A. Split
B. Freeze Panes > Freeze First Column
C. Freeze Panes > Freeze Top Row [CORRECT]
D. New Window
Correct Answer: C
Rationale: "Freeze Top Row" locks the first row in place during vertical scrolling, essential for
viewing headers with large datasets. Option A (Split) divides the window into scrollable panes.
Option B freezes the first column for horizontal scrolling. Option D creates a duplicate window
view of the same workbook.
Question 4 Which of the following is NOT a valid Excel workbook view?
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 view. Excel offers Normal (default
editing view), Page Layout (shows pages as printed), and Page Break Preview (displays page
breaks). Other valid views include Formula Bar and Full Screen.
Question 5 What happens when you press Ctrl + Home in Excel?
A. Moves to the last cell with data
B. Moves to cell A1 [CORRECT]
C. Moves to the current region
D. Opens the Home tab on the ribbon
Correct Answer: B
Rationale: Ctrl + Home navigates to cell A1 (or the top-left of the worksheet). Ctrl + End (A)
moves to the last cell with data. Ctrl + * (C) selects the current data region. Option D is
incorrect—Ctrl + Home does not activate ribbon tabs.
, Question 6 To save a workbook in a format that can be opened in Excel 2003 and earlier
versions, you should use:
A. .xlsx
B. .xls [CORRECT]
C. .xlsm
D. .pdf
Correct Answer: B
Rationale: The .xls format provides backward compatibility with Excel 97-2003. However, it
has limitations (65,536 rows, 256 columns, no new features). Option A (.xlsx) is not compatible
with Excel 2003 without a converter. Option C (.xlsm) is macro-enabled but still incompatible
with older versions. Option D (.pdf) is for viewing/printing only.
Question 7 Which feature allows you to view two different parts of the same worksheet
simultaneously?
A. Freeze Panes
B. Split [CORRECT]
C. Hide
D. Group
Correct Answer: B
Rationale: Split divides the worksheet window into two or four scrollable panes, allowing
simultaneous viewing of distant sections. Freeze Panes (A) locks rows/columns but doesn't
create independent scroll areas. Hide (C) conceals rows/columns. Group (D) creates outline
levels for data organization.
Question 8 To set a specific area of a worksheet to print (rather than the entire sheet), you
should:
A. Use Page Break Preview only
B. Define the Print Area [CORRECT]
C. Hide all other cells
D. Copy the data to a new sheet
Correct Answer: B
Rationale: Page Layout > Print Area > Set Print Area defines specific ranges to print. This is
more efficient than hiding cells (C) or creating new sheets (D). Page Break Preview (A) shows
breaks but doesn't limit printing to specific areas without setting the print area.
