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 XML-based file extension for Excel workbooks in Excel 2007 and
later versions. This format does not support macros and has better security and smaller file sizes
than the older .xls format. Option A (.xltx) is a template file format. Option C (.xlsm) is a macro-
enabled workbook format required when VBA macros are present. Option D (.csv) is a comma-
separated values text file format that loses formatting, formulas, and multiple sheets.
Understanding file formats is critical for saving work appropriately 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" is the specific command that keeps the first row visible when
scrolling vertically through data. This is essential when working with large datasets where header
rows need to remain visible. Option A (Split) divides the window into independently scrollable
,panes but does not lock rows. Option C (Freeze First Column) keeps the first column visible
when scrolling horizontally. Option D (View Side by Side) is used to compare two different
workbooks or windows simultaneously. These commands are located on the View tab in the
Window group.
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, which allows quick navigation to specific
cells, ranges, or named ranges. It also provides access to the "Special" selection options
(formulas, constants, blanks, etc.). Option B (Ctrl + F) opens the Find dialog. Option C (Ctrl +
H) opens Find and Replace. Option D (Ctrl + K) inserts or edits a hyperlink. Keyboard shortcuts
significantly improve spreadsheet navigation efficiency.
Question 4 To select all cells in a worksheet, which keyboard shortcut should you use?
A. Ctrl + A [CORRECT]
B. Ctrl + Shift + A
C. Alt + A
D. Shift + A
Correct Answer: A
Rationale: Ctrl + A selects all cells in the current worksheet. If the cursor is within a data range,
the first press selects the current region, and the second press selects all cells. This is essential for
applying formatting to entire sheets or clearing all content. The other combinations (B, C, D) do
not perform the select-all function in Excel.
Question 5 The Quick Access Toolbar in Excel:
A. Cannot be customized
B. Provides one-click access to frequently used commands and can be customized [CORRECT]
C. Only contains the Save button
D. Is located at the bottom of the screen
, Correct Answer: B
Rationale: The Quick Access Toolbar is located above the ribbon (by default) and provides
customizable one-click access to frequently used commands like Save, Undo, Redo, Print, etc.
Users can add any ribbon command to this toolbar for efficiency. Option A is incorrect—it is
highly customizable. Option C is incorrect—it can contain many commands. Option D is
incorrect—it is at the top of the screen (though it can be moved below the ribbon).
Question 6 To print only a specific range of cells rather than the entire worksheet, you should:
A. Select the range and set it as the Print Area [CORRECT]
B. Hide all other cells
C. Copy the range to a new workbook
D. Print the entire worksheet and ignore extra pages
Correct Answer: A
Rationale: Setting the Print Area (Page Layout > Print Area > Set Print Area) defines which
cells will be printed. This is the professional method for printing specific data ranges. Option B
is cumbersome and unnecessary. Option C creates unnecessary file management. Option D
wastes paper and is unprofessional. The Print Area setting remains until cleared or changed.
Question 7 Which view allows you to see how the worksheet will look when printed, including
headers, footers, and page breaks?
A. Normal view
B. Page Layout view [CORRECT]
C. Page Break Preview
D. Formula view
Correct Answer: B
Rationale: Page Layout view displays the worksheet as it will appear on the printed page,
showing margins, headers, footers, and page breaks in real-time. This is ideal for final formatting
before printing. Option A (Normal) is the standard editing view without page layout elements.
Option C (Page Break Preview) shows page breaks but not headers/footers. Option D (Formula
view) shows formulas instead of values.
Question 8 The intersection of a row and a column is called a:
A. Range
B. Worksheet
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 XML-based file extension for Excel workbooks in Excel 2007 and
later versions. This format does not support macros and has better security and smaller file sizes
than the older .xls format. Option A (.xltx) is a template file format. Option C (.xlsm) is a macro-
enabled workbook format required when VBA macros are present. Option D (.csv) is a comma-
separated values text file format that loses formatting, formulas, and multiple sheets.
Understanding file formats is critical for saving work appropriately 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" is the specific command that keeps the first row visible when
scrolling vertically through data. This is essential when working with large datasets where header
rows need to remain visible. Option A (Split) divides the window into independently scrollable
,panes but does not lock rows. Option C (Freeze First Column) keeps the first column visible
when scrolling horizontally. Option D (View Side by Side) is used to compare two different
workbooks or windows simultaneously. These commands are located on the View tab in the
Window group.
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, which allows quick navigation to specific
cells, ranges, or named ranges. It also provides access to the "Special" selection options
(formulas, constants, blanks, etc.). Option B (Ctrl + F) opens the Find dialog. Option C (Ctrl +
H) opens Find and Replace. Option D (Ctrl + K) inserts or edits a hyperlink. Keyboard shortcuts
significantly improve spreadsheet navigation efficiency.
Question 4 To select all cells in a worksheet, which keyboard shortcut should you use?
A. Ctrl + A [CORRECT]
B. Ctrl + Shift + A
C. Alt + A
D. Shift + A
Correct Answer: A
Rationale: Ctrl + A selects all cells in the current worksheet. If the cursor is within a data range,
the first press selects the current region, and the second press selects all cells. This is essential for
applying formatting to entire sheets or clearing all content. The other combinations (B, C, D) do
not perform the select-all function in Excel.
Question 5 The Quick Access Toolbar in Excel:
A. Cannot be customized
B. Provides one-click access to frequently used commands and can be customized [CORRECT]
C. Only contains the Save button
D. Is located at the bottom of the screen
, Correct Answer: B
Rationale: The Quick Access Toolbar is located above the ribbon (by default) and provides
customizable one-click access to frequently used commands like Save, Undo, Redo, Print, etc.
Users can add any ribbon command to this toolbar for efficiency. Option A is incorrect—it is
highly customizable. Option C is incorrect—it can contain many commands. Option D is
incorrect—it is at the top of the screen (though it can be moved below the ribbon).
Question 6 To print only a specific range of cells rather than the entire worksheet, you should:
A. Select the range and set it as the Print Area [CORRECT]
B. Hide all other cells
C. Copy the range to a new workbook
D. Print the entire worksheet and ignore extra pages
Correct Answer: A
Rationale: Setting the Print Area (Page Layout > Print Area > Set Print Area) defines which
cells will be printed. This is the professional method for printing specific data ranges. Option B
is cumbersome and unnecessary. Option C creates unnecessary file management. Option D
wastes paper and is unprofessional. The Print Area setting remains until cleared or changed.
Question 7 Which view allows you to see how the worksheet will look when printed, including
headers, footers, and page breaks?
A. Normal view
B. Page Layout view [CORRECT]
C. Page Break Preview
D. Formula view
Correct Answer: B
Rationale: Page Layout view displays the worksheet as it will appear on the printed page,
showing margins, headers, footers, and page breaks in real-time. This is ideal for final formatting
before printing. Option A (Normal) is the standard editing view without page layout elements.
Option C (Page Break Preview) shows page breaks but not headers/footers. Option D (Formula
view) shows formulas instead of values.
Question 8 The intersection of a row and a column is called a:
A. Range
B. Worksheet
