WGU C268
SPREADSHEETS
OBJECTIVE ASSESSMENT
COMPREHENSIVE STUDY GUIDE
Excel skills blueprint • formulas • worked examples • practice tasks • solutions
2026 UPDATED EDITION
Original, OA-focused preparation resource
, How to Use This Guide
Purpose. This guide develops the spreadsheet skills commonly assessed in WGU C268 through original explanations,
examples, and practice. It is not an official WGU publication and does not reproduce a live assessment.
Assessment reality. C268 is best prepared for by doing work inside Microsoft Excel. Reading formulas is useful, but the
decisive skill is entering, copying, auditing, and correcting them in a multi-sheet workbook.
Recommended study sequence
•
Complete the diagnostic checklist and identify weak domains.
•
Rebuild every worked example in Excel instead of copying formulas blindly.
•
Practice absolute, relative, and mixed references until copying formulas is predictable.
•
Complete the original capstone practice scenario without looking at the solutions.
•
Audit the workbook, correct errors, and repeat the weak tasks.
Integrity note
Use this guide as a learning and practice resource. Do not upload, distribute, or request proprietary assessment files.
Formula names and Excel features are standard software concepts; the scenarios and practice tasks in this guide are
original.
WGU C268 Spreadsheets - OA Comprehensive Study Guide | 2026 Page 2
, Contents
Section Topic
1 Assessment orientation and OA workflow
2 Workbook foundations and reference logic
3 Core calculations and logical functions
4 Lookup, text, date, and error-handling functions
5 Tables, sorting, filtering, and conditional formatting
6 Statistical analysis, forecasting, and confidence intervals
7 Financial modeling and amortization
8 PivotTables, PivotCharts, and visualization
9 What-if analysis, Goal Seek, and Solver
10 Formula auditing and troubleshooting
11 Original OA-style practice scenario
12 Detailed solutions and final checklist
WGU C268 Spreadsheets - OA Comprehensive Study Guide | 2026 Page 3
, 1. Assessment Orientation and OA Workflow
C268 evaluates whether you can translate written business instructions into accurate spreadsheet operations. A task may
require several linked actions: identify the correct worksheet, select the specified cell, build a formula using references, copy
it through a range, format the output, and verify that dependent values update correctly.
High-value skill domains
Domain What mastery looks like
Navigation and setup Locate worksheets and ranges quickly; preserve supplied labels and structure.
Formula construction Use operators, functions, parentheses, and correct references.
Reference behavior Choose relative, absolute, or mixed references before copying.
Business analysis Convert a narrative requirement into a calculation or model.
Data analysis Summarize, compare, forecast, and interpret data.
Presentation Apply number formats, tables, charts, and PivotTables appropriately.
Quality control Find formula inconsistencies, errors, and incorrect ranges.
A reliable task routine
Step Action Verification
1. Read Identify action verb, worksheet, target cell, source range, Restate the requirement in plain language.
and required format.
2. Plan Decide whether the task needs a formula, function, tool, Predict which references must stay fixed.
chart, or format.
3. Build Enter the formula in the first target cell. Check syntax and displayed result.
4. Copy Fill across or down only after reference behavior is correct. Inspect first, middle, and last copied formulas.
5. Apply requested currency, percentage, date, decimals, or Confirm formatting did not change the underlying value.
Format style.
6. Audit Check errors, ranges, totals, and plausibility. Use Trace Precedents or Show Formulas when needed.
Core principle: Do not treat the workbook as a list of unrelated cells. Most errors propagate. One incorrect assumption, copied
reference, or source range can corrupt an entire schedule.
WGU C268 Spreadsheets - OA Comprehensive Study Guide | 2026 Page 4
SPREADSHEETS
OBJECTIVE ASSESSMENT
COMPREHENSIVE STUDY GUIDE
Excel skills blueprint • formulas • worked examples • practice tasks • solutions
2026 UPDATED EDITION
Original, OA-focused preparation resource
, How to Use This Guide
Purpose. This guide develops the spreadsheet skills commonly assessed in WGU C268 through original explanations,
examples, and practice. It is not an official WGU publication and does not reproduce a live assessment.
Assessment reality. C268 is best prepared for by doing work inside Microsoft Excel. Reading formulas is useful, but the
decisive skill is entering, copying, auditing, and correcting them in a multi-sheet workbook.
Recommended study sequence
•
Complete the diagnostic checklist and identify weak domains.
•
Rebuild every worked example in Excel instead of copying formulas blindly.
•
Practice absolute, relative, and mixed references until copying formulas is predictable.
•
Complete the original capstone practice scenario without looking at the solutions.
•
Audit the workbook, correct errors, and repeat the weak tasks.
Integrity note
Use this guide as a learning and practice resource. Do not upload, distribute, or request proprietary assessment files.
Formula names and Excel features are standard software concepts; the scenarios and practice tasks in this guide are
original.
WGU C268 Spreadsheets - OA Comprehensive Study Guide | 2026 Page 2
, Contents
Section Topic
1 Assessment orientation and OA workflow
2 Workbook foundations and reference logic
3 Core calculations and logical functions
4 Lookup, text, date, and error-handling functions
5 Tables, sorting, filtering, and conditional formatting
6 Statistical analysis, forecasting, and confidence intervals
7 Financial modeling and amortization
8 PivotTables, PivotCharts, and visualization
9 What-if analysis, Goal Seek, and Solver
10 Formula auditing and troubleshooting
11 Original OA-style practice scenario
12 Detailed solutions and final checklist
WGU C268 Spreadsheets - OA Comprehensive Study Guide | 2026 Page 3
, 1. Assessment Orientation and OA Workflow
C268 evaluates whether you can translate written business instructions into accurate spreadsheet operations. A task may
require several linked actions: identify the correct worksheet, select the specified cell, build a formula using references, copy
it through a range, format the output, and verify that dependent values update correctly.
High-value skill domains
Domain What mastery looks like
Navigation and setup Locate worksheets and ranges quickly; preserve supplied labels and structure.
Formula construction Use operators, functions, parentheses, and correct references.
Reference behavior Choose relative, absolute, or mixed references before copying.
Business analysis Convert a narrative requirement into a calculation or model.
Data analysis Summarize, compare, forecast, and interpret data.
Presentation Apply number formats, tables, charts, and PivotTables appropriately.
Quality control Find formula inconsistencies, errors, and incorrect ranges.
A reliable task routine
Step Action Verification
1. Read Identify action verb, worksheet, target cell, source range, Restate the requirement in plain language.
and required format.
2. Plan Decide whether the task needs a formula, function, tool, Predict which references must stay fixed.
chart, or format.
3. Build Enter the formula in the first target cell. Check syntax and displayed result.
4. Copy Fill across or down only after reference behavior is correct. Inspect first, middle, and last copied formulas.
5. Apply requested currency, percentage, date, decimals, or Confirm formatting did not change the underlying value.
Format style.
6. Audit Check errors, ranges, totals, and plausibility. Use Trace Precedents or Show Formulas when needed.
Core principle: Do not treat the workbook as a list of unrelated cells. Most errors propagate. One incorrect assumption, copied
reference, or source range can corrupt an entire schedule.
WGU C268 Spreadsheets - OA Comprehensive Study Guide | 2026 Page 4
