WGU C268
SPREADSHEETS
OBJECTIVE ASSESSMENT (OA)
45 PRACTICAL TASKS
Full Instructions • Correct Answers • Formula Solutions • Detailed Rationales
2026 ALIGNED PRACTICE EDITION
Original Excel-based assessment preparation resource
, Important Use Note
This is a complete original practice assessment modeled on the practical, instruction-driven nature of spreadsheet
competency testing. It does not reproduce, claim to reveal, or guarantee the contents of a live WGU Objective Assessment.
The assessment contains 45 direct Excel tasks. Complete the Questions section first in a blank practice workbook, then use
the Answers and Rationales section to audit your work. Cell addresses and workbook design are internally consistent within
this practice scenario.
Recommended workbook tabs
Tab Purpose
Assumptions Centralized inputs, rates, holidays, and manager lookup table
Historical Data Event attendance and product sales source data
Forecast Statistics, forecast, confidence limits, and contribution model
Loan Payment calculation and amortization schedule
Projects Project table, bonuses, lookups, and duration
Dashboard Summary formulas, PivotTable, PivotChart, and selectors
OA workflow
Read the instruction precisely; identify the target cell or range; determine the function or Excel tool; enter and verify the first
result; copy only after confirming reference behavior; apply the requested format; and perform a final audit.
WGU C268 Spreadsheets - 45-Task OA-Style Practice Assessment | 2026 Page 2
, Assessment Blueprint
Domain Tasks
Workbook Setup 3
Historical Analysis 4
Forecasting 7
Visualization 1
Financial Modeling 9
Projects 9
Data Management 3
PivotTables 2
What-If Analysis 3
Text and Cleanup 1
Formatting 1
Quality Control 2
Scoring suggestion
Assign 2 points to each task for a 90-point practice assessment. Award 1 point for the correct Excel feature or formula
structure and 1 point for accurate references, placement, and formatting. For multi-part tasks, withhold the second point when
copying or formatting is incomplete.
WGU C268 Spreadsheets - 45-Task OA-Style Practice Assessment | 2026 Page 3
SPREADSHEETS
OBJECTIVE ASSESSMENT (OA)
45 PRACTICAL TASKS
Full Instructions • Correct Answers • Formula Solutions • Detailed Rationales
2026 ALIGNED PRACTICE EDITION
Original Excel-based assessment preparation resource
, Important Use Note
This is a complete original practice assessment modeled on the practical, instruction-driven nature of spreadsheet
competency testing. It does not reproduce, claim to reveal, or guarantee the contents of a live WGU Objective Assessment.
The assessment contains 45 direct Excel tasks. Complete the Questions section first in a blank practice workbook, then use
the Answers and Rationales section to audit your work. Cell addresses and workbook design are internally consistent within
this practice scenario.
Recommended workbook tabs
Tab Purpose
Assumptions Centralized inputs, rates, holidays, and manager lookup table
Historical Data Event attendance and product sales source data
Forecast Statistics, forecast, confidence limits, and contribution model
Loan Payment calculation and amortization schedule
Projects Project table, bonuses, lookups, and duration
Dashboard Summary formulas, PivotTable, PivotChart, and selectors
OA workflow
Read the instruction precisely; identify the target cell or range; determine the function or Excel tool; enter and verify the first
result; copy only after confirming reference behavior; apply the requested format; and perform a final audit.
WGU C268 Spreadsheets - 45-Task OA-Style Practice Assessment | 2026 Page 2
, Assessment Blueprint
Domain Tasks
Workbook Setup 3
Historical Analysis 4
Forecasting 7
Visualization 1
Financial Modeling 9
Projects 9
Data Management 3
PivotTables 2
What-If Analysis 3
Text and Cleanup 1
Formatting 1
Quality Control 2
Scoring suggestion
Assign 2 points to each task for a 90-point practice assessment. Award 1 point for the correct Excel feature or formula
structure and 1 point for accurate references, placement, and formatting. For multi-part tasks, withhold the second point when
copying or formatting is incomplete.
WGU C268 Spreadsheets - 45-Task OA-Style Practice Assessment | 2026 Page 3
