WGU C268 SPREADSHEETS ACTUAL EXAM - WESTERN
GOVERNORS UNIVERSITY - 2026/2027 ACADEMIC YEAR
- VERIFIED QUESTIONS AND ANSWERS
200 Questions with Answers and Detailed Rationales
100 PERCENT GUARANTEED PASS
INSTANT DOWNLOAD ANSWERS INCLUDED
IMPORTANCE OF THIS DOCUMENT
This comprehensive examination preparation guide has been meticulously developed to help you succeed in the
WGU C268 SPREADSHEETS ACTUAL EXAM - WESTERN GOVERNORS UNIVERSITY - 2026/2027
ACADEMIC YEAR - VERIFIED QUESTIONS AND ANSWERS. It contains 200 carefully selected questions that
reflect the most current exam content and testing strategies. Each question is accompanied by a correct answer
and a detailed rationale that explains the underlying pathophysiology, pharmacology, or clinical reasoning.
Self-Assessment – Test your knowledge and Exam Preparation – Familiarize yourself with the
identify areas requiring further question format and content
study areas
Concept Reinforcement – Deepen your Confidence Building – Develop test-taking
understanding through strategies and reduce
evidence-based exam anxiety
rationales
Time Management – Practice answering
questions under simulated
exam conditions
Review Summary 200 Questions
Foundations - Application - WGU C268 Spreadsheets Actual Western Governors University 2026/2027
Academic YEAR AND Spreadsheet Applications AND DATA Analysis Undergraduate YEAR 3 / Graduate
All answers with rationales
,Table of Contents
Content Area Questions Key Topics
WGU C268 Spreadsheets 1-34 Excel, Formula, Column, YOU NEED, Spreadsheet
Actual Western Governors
University 2026/2027
Academic YEAR AND
Spreadsheet Applications
AND DATA Analysis
Undergraduate YEAR 3 /
Graduate
Formula 35-68 YOU NEED, Column, Spreadsheet, Sales, Correctly
YOU NEED 69-102 Column, Formula, Sales, Spreadsheet, Contains
Sales 103-136 Formula, Column, YOU NEED, Correctly, Table
Spreadsheet 137-170 Column, Sales, YOU NEED, Formula, Contains
Correctly 171-200 Formula, Column, Spreadsheet, Excel, Range
TOTAL 200 All questions include answers and detailed rationales
,Section A - WGU C268 Spreadsheets Actual Western
Governors University 2026/2027 Academic YEAR AND
Spreadsheet Applications AND DATA Analysis
Undergraduate YEAR 3 / Graduate
Q1.
A financial analyst is building a model to compute the net present value of a project with
uneven cash flows occurring at irregular intervals. Which Excel function is most
appropriate, and what critical assumption must be verified before relying on its output?
A. XNPV with a discount rate that matches B. NPV with all cash flows equally spaced
the periodicity of the cash flows and occurring at the end of each period
C. IRR with a guess rate close to the cost of D. MIRR with separate financing and
capital reinvestment rates
Correct: A - XNPV with a discount rate that matches the periodicity of the cash flows
Rationale:XNPV is designed for cash flows at irregular dates, using the exact date of each
cash flow. The discount rate must be annualized consistently with the dates. NPV assumes
equal periods, IRR returns a rate not a value, and MIRR is for regular periods with explicit
rates.
Q2.
A data analyst needs to extract a list of unique product names from a large dataset and
also count how many times each product appears. Which combination of Excel features is
most efficient and dynamic for this task?
A. Remove Duplicates on a copy of the B. Use the UNIQUE function to list products
data, then use COUNTIF and COUNTIF to count occurrences
C. Create a pivot table with product names D. Use Advanced Filter with unique records
in rows and count in values only, then COUNTIF
Correct: B - Use the UNIQUE function to list products and COUNTIF to count occurrences
Rationale:The UNIQUE function dynamically returns a list of unique values, and COUNTIF
can count each occurrence. Pivot tables are powerful but require manual refresh and layout
changes. Remove Duplicates and Advanced Filter are static and less adaptable to data
changes.
Q3.
In a complex spreadsheet model, a formula returns #REF! after a column is deleted. What
is the most effective way to prevent this error in the future while maintaining formula
integrity?
Page 3
, Section A - WGU C268 Spreadsheets Actual Western Governors University 2026/2027 Academic YEAR AND Spreadsheet Applications AND
DATA Analysis Undergraduate YEAR 3 / Graduate
A. Use absolute cell references throughout B. Convert all formulas to use the
the model INDIRECT function
C. Define named ranges for key inputs and D. Enable iterative calculation to resolve
use those in formulas circular references
Correct: C - Define named ranges for key inputs and use those in formulas
Rationale:Named ranges are resilient to structural changes like row/column insertion or
deletion because they reference named objects. Absolute references still break if the
referenced cell is deleted. INDIRECT can be volatile and inefficient. Iterative calculation does
not fix reference errors.
Q4.
A manager wants to compare quarterly sales across three regions using a chart that
emphasizes the contribution of each region to the total each quarter. Which chart type is
most appropriate?
A. Stacked column chart with percentage B. Clustered column chart
axis
C. Line chart with markers D. Pie chart for each quarter
Correct: A - Stacked column chart with percentage axis
Rationale:A stacked column chart with a percentage axis shows the relative contribution of
each region to the total per quarter, making comparisons easy. Clustered columns compare
absolute values but not proportions. Line charts show trends, and separate pie charts are
inefficient for multiple quarters.
Q5.
A data scientist is analyzing a dataset with several outliers. They need to compute a
robust measure of central tendency and dispersion. Which Excel functions should they
use?
A. AVERAGE and STDEV.P B. MEDIAN and QUARTILE.INC
C. MODE.SNGL and VAR.S D. TRIMMEAN and STDEV.S
Correct: B - MEDIAN and QUARTILE.INC
Rationale:The median is resistant to outliers, and quartiles provide robust dispersion
measures. AVERAGE and STDEV are sensitive to outliers. TRIMMEAN trims a percentage
but still uses mean-based logic. MODE and VAR are not robust to extreme values.
Page 4
GOVERNORS UNIVERSITY - 2026/2027 ACADEMIC YEAR
- VERIFIED QUESTIONS AND ANSWERS
200 Questions with Answers and Detailed Rationales
100 PERCENT GUARANTEED PASS
INSTANT DOWNLOAD ANSWERS INCLUDED
IMPORTANCE OF THIS DOCUMENT
This comprehensive examination preparation guide has been meticulously developed to help you succeed in the
WGU C268 SPREADSHEETS ACTUAL EXAM - WESTERN GOVERNORS UNIVERSITY - 2026/2027
ACADEMIC YEAR - VERIFIED QUESTIONS AND ANSWERS. It contains 200 carefully selected questions that
reflect the most current exam content and testing strategies. Each question is accompanied by a correct answer
and a detailed rationale that explains the underlying pathophysiology, pharmacology, or clinical reasoning.
Self-Assessment – Test your knowledge and Exam Preparation – Familiarize yourself with the
identify areas requiring further question format and content
study areas
Concept Reinforcement – Deepen your Confidence Building – Develop test-taking
understanding through strategies and reduce
evidence-based exam anxiety
rationales
Time Management – Practice answering
questions under simulated
exam conditions
Review Summary 200 Questions
Foundations - Application - WGU C268 Spreadsheets Actual Western Governors University 2026/2027
Academic YEAR AND Spreadsheet Applications AND DATA Analysis Undergraduate YEAR 3 / Graduate
All answers with rationales
,Table of Contents
Content Area Questions Key Topics
WGU C268 Spreadsheets 1-34 Excel, Formula, Column, YOU NEED, Spreadsheet
Actual Western Governors
University 2026/2027
Academic YEAR AND
Spreadsheet Applications
AND DATA Analysis
Undergraduate YEAR 3 /
Graduate
Formula 35-68 YOU NEED, Column, Spreadsheet, Sales, Correctly
YOU NEED 69-102 Column, Formula, Sales, Spreadsheet, Contains
Sales 103-136 Formula, Column, YOU NEED, Correctly, Table
Spreadsheet 137-170 Column, Sales, YOU NEED, Formula, Contains
Correctly 171-200 Formula, Column, Spreadsheet, Excel, Range
TOTAL 200 All questions include answers and detailed rationales
,Section A - WGU C268 Spreadsheets Actual Western
Governors University 2026/2027 Academic YEAR AND
Spreadsheet Applications AND DATA Analysis
Undergraduate YEAR 3 / Graduate
Q1.
A financial analyst is building a model to compute the net present value of a project with
uneven cash flows occurring at irregular intervals. Which Excel function is most
appropriate, and what critical assumption must be verified before relying on its output?
A. XNPV with a discount rate that matches B. NPV with all cash flows equally spaced
the periodicity of the cash flows and occurring at the end of each period
C. IRR with a guess rate close to the cost of D. MIRR with separate financing and
capital reinvestment rates
Correct: A - XNPV with a discount rate that matches the periodicity of the cash flows
Rationale:XNPV is designed for cash flows at irregular dates, using the exact date of each
cash flow. The discount rate must be annualized consistently with the dates. NPV assumes
equal periods, IRR returns a rate not a value, and MIRR is for regular periods with explicit
rates.
Q2.
A data analyst needs to extract a list of unique product names from a large dataset and
also count how many times each product appears. Which combination of Excel features is
most efficient and dynamic for this task?
A. Remove Duplicates on a copy of the B. Use the UNIQUE function to list products
data, then use COUNTIF and COUNTIF to count occurrences
C. Create a pivot table with product names D. Use Advanced Filter with unique records
in rows and count in values only, then COUNTIF
Correct: B - Use the UNIQUE function to list products and COUNTIF to count occurrences
Rationale:The UNIQUE function dynamically returns a list of unique values, and COUNTIF
can count each occurrence. Pivot tables are powerful but require manual refresh and layout
changes. Remove Duplicates and Advanced Filter are static and less adaptable to data
changes.
Q3.
In a complex spreadsheet model, a formula returns #REF! after a column is deleted. What
is the most effective way to prevent this error in the future while maintaining formula
integrity?
Page 3
, Section A - WGU C268 Spreadsheets Actual Western Governors University 2026/2027 Academic YEAR AND Spreadsheet Applications AND
DATA Analysis Undergraduate YEAR 3 / Graduate
A. Use absolute cell references throughout B. Convert all formulas to use the
the model INDIRECT function
C. Define named ranges for key inputs and D. Enable iterative calculation to resolve
use those in formulas circular references
Correct: C - Define named ranges for key inputs and use those in formulas
Rationale:Named ranges are resilient to structural changes like row/column insertion or
deletion because they reference named objects. Absolute references still break if the
referenced cell is deleted. INDIRECT can be volatile and inefficient. Iterative calculation does
not fix reference errors.
Q4.
A manager wants to compare quarterly sales across three regions using a chart that
emphasizes the contribution of each region to the total each quarter. Which chart type is
most appropriate?
A. Stacked column chart with percentage B. Clustered column chart
axis
C. Line chart with markers D. Pie chart for each quarter
Correct: A - Stacked column chart with percentage axis
Rationale:A stacked column chart with a percentage axis shows the relative contribution of
each region to the total per quarter, making comparisons easy. Clustered columns compare
absolute values but not proportions. Line charts show trends, and separate pie charts are
inefficient for multiple quarters.
Q5.
A data scientist is analyzing a dataset with several outliers. They need to compute a
robust measure of central tendency and dispersion. Which Excel functions should they
use?
A. AVERAGE and STDEV.P B. MEDIAN and QUARTILE.INC
C. MODE.SNGL and VAR.S D. TRIMMEAN and STDEV.S
Correct: B - MEDIAN and QUARTILE.INC
Rationale:The median is resistant to outliers, and quartiles provide robust dispersion
measures. AVERAGE and STDEV are sensitive to outliers. TRIMMEAN trims a percentage
but still uses mean-based logic. MODE and VAR are not robust to extreme values.
Page 4
