Wgu C268 Spreadsheets Real Exam Questions And Correct
Answers (Verified Answers) Plus Rationales| Instant Download
Pdf
This exam assesses mastery of core spreadsheet fundamentals and navigation in Microsoft Excel as defined by the
WGU C268 competency framework. It emphasizes workbook structure, cell referencing behavior, name
management, navigation techniques, selection semantics, and worksheet-level operations required for accurate
formula construction and efficient data handling. It contains 146 multiple-choice questions, each with four
distractors and a fully worked rationale that explains why the keyed answer is correct. Content is organized into
11 focused sections: Spreadsheet Fundamentals and Navigation, Formulas and Functions, Cell References
(Relative, Absolute, Mixed), Formatting and Worksheet Presentation, Charts and Data Visualization, Data
Management, Sorting, and Filtering, Tables and Structured References, Conditional Logic and Lookup Functions,
What-If Analysis and Data Tools, Workbook Management and Printing, Collaboration, Protection, and Validation.
Targeted learning outcomes include: Navigate workbooks, worksheets, and cell ranges efficiently using keyboard,
Name Box, and Go To Special techniques.; Distinguish relative, absolute, and mixed cell references and predict
how they behave when copied or filled.; Manage worksheet structure including insertion, deletion, grouping,
freezing, and defined names without breaking formulas.; Apply selection and editing semantics (ranges,
noncontiguous selections, fill handle, paste special) accurately in multi-step scenarios.. Every item has been
reviewed for clinical accuracy, current guidelines, and clarity so that students can study with confidence and
Section 1: Spreadsheet Fundamentals and Navigation (Questions 1-14)
1 Cell D5 contains =B$5*$C5. After copying D5 two columns right and three
rows down, what formula appears?
A) =D$8*$C8
B) =D$5*$C8
C) =F$8*$C8
D) =D$5*$C5
Answer: A
Rationale: Copying two columns right shifts the relative column B to D while
the absolute row $5 stays fixed; copying three rows down shifts the relative
row 5 to 8 while the absolute column $C stays fixed, yielding =D$8*$C8.
Options B, C, and D misapply which components are locked, producing
incorrect row or column shifts.
2 A workbook defines the name Qtr1 as Sheet1!$B$2:$B$10. After inserting a
new row at row 5 on Sheet1, what does Qtr1 reference?
A) Sheet1!$B$2:$B$10 unchanged
B) Sheet1!$B$2:$B$11
C) Sheet1!$B$2:$B$9
D) #REF! error
,Answer: B
Rationale: Excel defined names are dynamic; inserting a row inside the
referenced range expands the name to include the new row, so Qtr1 becomes
$B$2:$B$11. The range does not remain static, shrink, or break unless the
entire referenced range is deleted.
3 Which Go To Special option selects only cells containing formulas that
return numbers, excluding text results?
A) Constants
B) Formulas with Numbers
C) Current region
D) Conditional formats
Answer: B
Rationale: Go To Special > Formulas with Numbers selects formula cells whose
results are numeric, filtering out text-returning formulas. Constants selects
non-formula values, Current region selects a contiguous block, and Conditional
formats selects cells with formatting rules, none of which isolate numeric
formula results.
4 With Sheet1:Sheet3 grouped, a user types a value in Sheet2!A1. What is the
immediate effect?
A) Only Sheet2!A1 changes
B) A1 changes on all grouped sheets
C) Excel blocks the edit
D) A1 changes on Sheet1 only
Answer: B
Rationale: Grouping sheets links entry so any edit made on one grouped sheet is
replicated to the same cell on all grouped sheets, so A1 changes on Sheet1,
Sheet2, and Sheet3. Excel does not block the edit, and changes are not limited
to a single sheet while grouping is active.
5 A worksheet has data in A1:C20. Which Name Box entry selects the
noncontiguous ranges A1:A5 and C1:C5?
A) A1:A5;C1:C5
B) A1:A5,C1:C5
C) A1:A5 C1:C5
,D) A1:A5+C1:C5
Answer: B
Rationale: The Name Box uses a comma to separate multiple references for a
multi-area selection, so A1:A5,C1:C5 selects both ranges. Semicolons, spaces,
and plus signs are not valid multi-area delimiters in the Name Box and will not
produce the intended selection.
6 A user presses Ctrl+Shift+End from cell B2. Which cell becomes the active
endpoint of the selection?
A) Last used cell of the worksheet
B) Last cell of column B
C) Last cell of row 2
D) Cell A1
Answer: A
Rationale: Ctrl+Shift+End extends the selection from the current cell to the last
used cell of the worksheet (the intersection of the last used row and column),
not merely the end of the current row or column. Ctrl+Shift+Down or
Ctrl+Shift+Right would extend only along a single column or row.
7 A formula in C1 references a named range that is later deleted via Name
Manager. What does C1 display?
A) #NAME?
B) #REF!
C) 0
D) The last calculated value
Answer: A
Rationale: Deleting a defined name removes the name from the workbook, so
any formula still referencing it returns #NAME? because Excel cannot resolve
the identifier. #REF! arises from deleted cells or invalid references, not from
removing a name definition.
8 Which statement correctly distinguishes Excel Tables from ordinary ranges
regarding structured references?
A) Tables auto-expand and support structured references like Table1[Sales]
B) Ordinary ranges support structured references but Tables do not
C) Both Tables and ranges require A1-style references only
, D) Structured references work only with absolute references
Answer: A
Rationale: Excel Tables automatically expand when new rows or columns are
added and allow structured references such as Table1[Sales], which are more
readable and robust than A1 references. Ordinary ranges do not support
structured references, and structured references are not restricted to absolute
references.
9 A user wants row 1 and column A visible while scrolling to cell Z100.
Which action achieves this?
A) Freeze Panes at cell B2
B) Freeze Top Row only
C) Split at cell B2
D) Freeze First Column only
Answer: A
Rationale: Freezing panes at cell B2 locks both the rows above (row 1) and the
columns to the left (column A) so they remain visible while scrolling. Freezing
only the top row or first column locks just one dimension, and Split creates
resizable panes rather than persistent frozen headers.
10 Which paste option pastes only the values from copied cells, discarding
formulas and formatting?
A) Paste Special > Values
B) Paste Special > Formulas
C) Paste Special > Formats
D) Paste Special > All
Answer: A
Rationale: Paste Special > Values inserts only the calculated results, removing
formulas and source formatting. Formulas pastes formulas without formatting,
Formats pastes only formatting, and All pastes everything, so none of those
isolate values alone.
11 In a workbook with grouped sheets, entering a formula in the active sheet
affects which sheets?
A) Only the active sheet, because grouping affects formatting only.
B) All sheets in the group, populating the same cell on each grouped sheet.
Answers (Verified Answers) Plus Rationales| Instant Download
This exam assesses mastery of core spreadsheet fundamentals and navigation in Microsoft Excel as defined by the
WGU C268 competency framework. It emphasizes workbook structure, cell referencing behavior, name
management, navigation techniques, selection semantics, and worksheet-level operations required for accurate
formula construction and efficient data handling. It contains 146 multiple-choice questions, each with four
distractors and a fully worked rationale that explains why the keyed answer is correct. Content is organized into
11 focused sections: Spreadsheet Fundamentals and Navigation, Formulas and Functions, Cell References
(Relative, Absolute, Mixed), Formatting and Worksheet Presentation, Charts and Data Visualization, Data
Management, Sorting, and Filtering, Tables and Structured References, Conditional Logic and Lookup Functions,
What-If Analysis and Data Tools, Workbook Management and Printing, Collaboration, Protection, and Validation.
Targeted learning outcomes include: Navigate workbooks, worksheets, and cell ranges efficiently using keyboard,
Name Box, and Go To Special techniques.; Distinguish relative, absolute, and mixed cell references and predict
how they behave when copied or filled.; Manage worksheet structure including insertion, deletion, grouping,
freezing, and defined names without breaking formulas.; Apply selection and editing semantics (ranges,
noncontiguous selections, fill handle, paste special) accurately in multi-step scenarios.. Every item has been
reviewed for clinical accuracy, current guidelines, and clarity so that students can study with confidence and
Section 1: Spreadsheet Fundamentals and Navigation (Questions 1-14)
1 Cell D5 contains =B$5*$C5. After copying D5 two columns right and three
rows down, what formula appears?
A) =D$8*$C8
B) =D$5*$C8
C) =F$8*$C8
D) =D$5*$C5
Answer: A
Rationale: Copying two columns right shifts the relative column B to D while
the absolute row $5 stays fixed; copying three rows down shifts the relative
row 5 to 8 while the absolute column $C stays fixed, yielding =D$8*$C8.
Options B, C, and D misapply which components are locked, producing
incorrect row or column shifts.
2 A workbook defines the name Qtr1 as Sheet1!$B$2:$B$10. After inserting a
new row at row 5 on Sheet1, what does Qtr1 reference?
A) Sheet1!$B$2:$B$10 unchanged
B) Sheet1!$B$2:$B$11
C) Sheet1!$B$2:$B$9
D) #REF! error
,Answer: B
Rationale: Excel defined names are dynamic; inserting a row inside the
referenced range expands the name to include the new row, so Qtr1 becomes
$B$2:$B$11. The range does not remain static, shrink, or break unless the
entire referenced range is deleted.
3 Which Go To Special option selects only cells containing formulas that
return numbers, excluding text results?
A) Constants
B) Formulas with Numbers
C) Current region
D) Conditional formats
Answer: B
Rationale: Go To Special > Formulas with Numbers selects formula cells whose
results are numeric, filtering out text-returning formulas. Constants selects
non-formula values, Current region selects a contiguous block, and Conditional
formats selects cells with formatting rules, none of which isolate numeric
formula results.
4 With Sheet1:Sheet3 grouped, a user types a value in Sheet2!A1. What is the
immediate effect?
A) Only Sheet2!A1 changes
B) A1 changes on all grouped sheets
C) Excel blocks the edit
D) A1 changes on Sheet1 only
Answer: B
Rationale: Grouping sheets links entry so any edit made on one grouped sheet is
replicated to the same cell on all grouped sheets, so A1 changes on Sheet1,
Sheet2, and Sheet3. Excel does not block the edit, and changes are not limited
to a single sheet while grouping is active.
5 A worksheet has data in A1:C20. Which Name Box entry selects the
noncontiguous ranges A1:A5 and C1:C5?
A) A1:A5;C1:C5
B) A1:A5,C1:C5
C) A1:A5 C1:C5
,D) A1:A5+C1:C5
Answer: B
Rationale: The Name Box uses a comma to separate multiple references for a
multi-area selection, so A1:A5,C1:C5 selects both ranges. Semicolons, spaces,
and plus signs are not valid multi-area delimiters in the Name Box and will not
produce the intended selection.
6 A user presses Ctrl+Shift+End from cell B2. Which cell becomes the active
endpoint of the selection?
A) Last used cell of the worksheet
B) Last cell of column B
C) Last cell of row 2
D) Cell A1
Answer: A
Rationale: Ctrl+Shift+End extends the selection from the current cell to the last
used cell of the worksheet (the intersection of the last used row and column),
not merely the end of the current row or column. Ctrl+Shift+Down or
Ctrl+Shift+Right would extend only along a single column or row.
7 A formula in C1 references a named range that is later deleted via Name
Manager. What does C1 display?
A) #NAME?
B) #REF!
C) 0
D) The last calculated value
Answer: A
Rationale: Deleting a defined name removes the name from the workbook, so
any formula still referencing it returns #NAME? because Excel cannot resolve
the identifier. #REF! arises from deleted cells or invalid references, not from
removing a name definition.
8 Which statement correctly distinguishes Excel Tables from ordinary ranges
regarding structured references?
A) Tables auto-expand and support structured references like Table1[Sales]
B) Ordinary ranges support structured references but Tables do not
C) Both Tables and ranges require A1-style references only
, D) Structured references work only with absolute references
Answer: A
Rationale: Excel Tables automatically expand when new rows or columns are
added and allow structured references such as Table1[Sales], which are more
readable and robust than A1 references. Ordinary ranges do not support
structured references, and structured references are not restricted to absolute
references.
9 A user wants row 1 and column A visible while scrolling to cell Z100.
Which action achieves this?
A) Freeze Panes at cell B2
B) Freeze Top Row only
C) Split at cell B2
D) Freeze First Column only
Answer: A
Rationale: Freezing panes at cell B2 locks both the rows above (row 1) and the
columns to the left (column A) so they remain visible while scrolling. Freezing
only the top row or first column locks just one dimension, and Split creates
resizable panes rather than persistent frozen headers.
10 Which paste option pastes only the values from copied cells, discarding
formulas and formatting?
A) Paste Special > Values
B) Paste Special > Formulas
C) Paste Special > Formats
D) Paste Special > All
Answer: A
Rationale: Paste Special > Values inserts only the calculated results, removing
formulas and source formatting. Formulas pastes formulas without formatting,
Formats pastes only formatting, and All pastes everything, so none of those
isolate values alone.
11 In a workbook with grouped sheets, entering a formula in the active sheet
affects which sheets?
A) Only the active sheet, because grouping affects formatting only.
B) All sheets in the group, populating the same cell on each grouped sheet.
