WGU D100 Introduction to Spreadsheets
Actual Exam QUESTIONS AND ANSWERS
2026 | Complete Guide A+ Graded | Pass
Guaranteed - A+ Graded
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 format for Excel workbooks (Excel 2007 and
later), offering smaller file sizes and better data recovery than older formats. .xltx (A) is a
template format. .xlsm (C) is macro-enabled (required for VBA macros). .csv (D) is a plain text
comma-separated format that loses formatting and formulas. Understanding file extensions is
critical 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 locks row 1 in place, keeping headers visible during vertical
scrolling. Freeze First Column (C) locks column A for horizontal scrolling. Split (A) divides the
window into independently scrollable panes. View Side by Side (D) compares two workbooks
simultaneously. This is essential for working with large datasets while maintaining header
visibility.
,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 for rapid navigation to specific cells or ranges
(including named ranges). Ctrl + F (B) opens Find. Ctrl + H (C) opens Find and Replace. Ctrl +
K (D) inserts hyperlinks. Go To is particularly useful for navigating large worksheets or
accessing named ranges quickly.
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: Excel offers Normal (standard editing), Page Layout (shows pages as printed), and
Page Break Preview (shows page breaks). Slide Show (D) is a PowerPoint feature, not Excel.
Understanding views helps users prepare documents for printing versus editing.
Question 5 To select non-contiguous cells (cells that are not next to each other), you should hold
which key while clicking?
A. Shift
B. Ctrl [CORRECT]
C. Alt
D. Tab
Correct Answer: B
Rationale: Ctrl + Click selects non-contiguous cells or ranges, useful for applying formatting or
formulas to scattered cells. Shift (A) selects contiguous ranges. Alt (C) activates ribbon access
keys. Tab (D) moves to the next cell. This is essential for efficient data manipulation.
, Question 6 Which command allows you to print only a specific selected range of cells rather
than the entire worksheet?
A. Print Active Sheets
B. Print Selection [CORRECT]
C. Print Entire Workbook
D. Print Gridlines
Correct Answer: B
Rationale: Print Selection prints only the currently selected range. Print Active Sheets (A) prints
the current sheet. Print Entire Workbook (C) prints all sheets. Print Gridlines (D) is a layout
option, not a scope selector. Setting the print area prevents wasting paper on unnecessary data.
Question 7 The Quick Access Toolbar in Excel:
A. Cannot be customized
B. Provides one-click access to frequently used commands [CORRECT]
C. Only contains the Save button
D. Is located at the bottom of the screen
Correct Answer: B
Rationale: The Quick Access Toolbar (top-left by default) can be customized with any command
for instant access regardless of ribbon tab. It can be moved below the ribbon. It is highly
customizable (A is wrong), not limited to Save (C), and located at the top (D is wrong).
Question 8 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 window into independently scrollable panes, allowing simultaneous
viewing of distant sections (e.g., row 1 headers and row 5000 data). Freeze Panes (A) locks
rows/columns but doesn't create independent panes. Hide (C) conceals rows/columns. Group (D)
creates outline levels.
Actual Exam QUESTIONS AND ANSWERS
2026 | Complete Guide A+ Graded | Pass
Guaranteed - A+ Graded
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 format for Excel workbooks (Excel 2007 and
later), offering smaller file sizes and better data recovery than older formats. .xltx (A) is a
template format. .xlsm (C) is macro-enabled (required for VBA macros). .csv (D) is a plain text
comma-separated format that loses formatting and formulas. Understanding file extensions is
critical 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 locks row 1 in place, keeping headers visible during vertical
scrolling. Freeze First Column (C) locks column A for horizontal scrolling. Split (A) divides the
window into independently scrollable panes. View Side by Side (D) compares two workbooks
simultaneously. This is essential for working with large datasets while maintaining header
visibility.
,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 for rapid navigation to specific cells or ranges
(including named ranges). Ctrl + F (B) opens Find. Ctrl + H (C) opens Find and Replace. Ctrl +
K (D) inserts hyperlinks. Go To is particularly useful for navigating large worksheets or
accessing named ranges quickly.
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: Excel offers Normal (standard editing), Page Layout (shows pages as printed), and
Page Break Preview (shows page breaks). Slide Show (D) is a PowerPoint feature, not Excel.
Understanding views helps users prepare documents for printing versus editing.
Question 5 To select non-contiguous cells (cells that are not next to each other), you should hold
which key while clicking?
A. Shift
B. Ctrl [CORRECT]
C. Alt
D. Tab
Correct Answer: B
Rationale: Ctrl + Click selects non-contiguous cells or ranges, useful for applying formatting or
formulas to scattered cells. Shift (A) selects contiguous ranges. Alt (C) activates ribbon access
keys. Tab (D) moves to the next cell. This is essential for efficient data manipulation.
, Question 6 Which command allows you to print only a specific selected range of cells rather
than the entire worksheet?
A. Print Active Sheets
B. Print Selection [CORRECT]
C. Print Entire Workbook
D. Print Gridlines
Correct Answer: B
Rationale: Print Selection prints only the currently selected range. Print Active Sheets (A) prints
the current sheet. Print Entire Workbook (C) prints all sheets. Print Gridlines (D) is a layout
option, not a scope selector. Setting the print area prevents wasting paper on unnecessary data.
Question 7 The Quick Access Toolbar in Excel:
A. Cannot be customized
B. Provides one-click access to frequently used commands [CORRECT]
C. Only contains the Save button
D. Is located at the bottom of the screen
Correct Answer: B
Rationale: The Quick Access Toolbar (top-left by default) can be customized with any command
for instant access regardless of ribbon tab. It can be moved below the ribbon. It is highly
customizable (A is wrong), not limited to Save (C), and located at the top (D is wrong).
Question 8 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 window into independently scrollable panes, allowing simultaneous
viewing of distant sections (e.g., row 1 headers and row 5000 data). Freeze Panes (A) locks
rows/columns but doesn't create independent panes. Hide (C) conceals rows/columns. Group (D)
creates outline levels.
