WGU C268
SPREADSHEETS
OA MASTER STUDY GUIDE
88 performance-based tasks with step-by-step solutions
Formulas - PivotTables - Charts - Financial Models
2026 Updated Edition
Includes companion Excel practice workbook
Original educational practice material. It is not an official WGU exam, answer key, or guaranteed representation of a current
assessment form.
WGU C268 Spreadsheets OA Master Study Guide - Original practice material Page 1
, How to Use This Bundle
C268 is best learned by doing. Work in the companion .xlsx file while keeping this guide open. Attempt each task from the
Task Checklist before viewing the Solutions sheet or the method below.
Pass Action Evidence
1. Read Identify the required object, function, range, and format. You can state what must change.
2. Perform Use Excel commands or enter the formula exactly. The workbook reflects the requested action.
3. Verify Inspect displayed result, formula bar, and formatting. The result is logically and visually correct.
4. If wrong, check references, parentheses, ranges, and number format. The cause is corrected, not hidden.
Diagnose
High-Yield Formula Map
Purpose Formula pattern Reference warning
Revenue =Units*UnitPrice Relative references when filled
Profit =Revenue-Cost Subtraction order
Margin =IFERROR(Profit/Revenue,0) Format as percentage
Criteria total =SUMIFS(sum_range,criteria_range,criteria) All ranges same size
Exact lookup =XLOOKUP(key,keys,return,"Not Found",0) Exact match; lock tables
Alternate lookup =INDEX(return,MATCH(key,keys,0)) MATCH mode 0
Running total =SUM($C$5:C5) Mixed expanding range
Payment =PMT(rate/periods,number_periods,-principal) Rate and periods use same frequency
NPV =NPV(rate,future_flows)+initial_flow Year 0 outside NPV
Break-even =FixedCosts/(Price-VariableCost) Use contribution margin
WGU C268 Spreadsheets OA Master Study Guide - Original practice material Page 2
, 1. Workbook Setup and Navigation
Module goal: Complete all 11 actions without using the solution, then verify the outcome. Tasks 1-11.
Task 1: Rename a worksheet and apply a descriptive tab name
Method / formula: Double-click the sheet tab, type the requested name, and press Enter. Keep names short enough to
display.
Verification: The new tab name matches the instruction exactly.
Troubleshooting cue: Confirm the active sheet and selected range first; then inspect formula references, data type, and number format.
Task 2: Move a worksheet into the requested order
Method / formula: Drag the sheet tab left or right until the insertion marker is in the requested position.
Verification: The workbook tab sequence is correct.
Troubleshooting cue: Confirm the active sheet and selected range first; then inspect formula references, data type, and number format.
Task 3: Freeze the top row of a data table
Method / formula: Select View > Freeze Panes > Freeze Top Row. Scroll down to confirm the heading remains visible.
Verification: Row 1 or the designated header row stays on screen.
Troubleshooting cue: Confirm the active sheet and selected range first; then inspect formula references, data type, and number format.
Task 4: Set print orientation to Landscape
Method / formula: Open Page Layout > Orientation > Landscape. Use Print Preview to confirm the table fits better
horizontally.
Verification: Preview shows landscape orientation.
Troubleshooting cue: Confirm the active sheet and selected range first; then inspect formula references, data type, and number format.
Task 5: Define a print area for the populated range
Method / formula: Select the required range, choose Page Layout > Print Area > Set Print Area, then preview.
Verification: Only the required cells print.
Troubleshooting cue: Confirm the active sheet and selected range first; then inspect formula references, data type, and number format.
Task 6: Insert a header containing the workbook title
Method / formula: Use Insert > Header & Footer, select the center header section, and enter the exact title.
Verification: The title appears in page-layout or print preview.
Troubleshooting cue: Confirm the active sheet and selected range first; then inspect formula references, data type, and number format.
WGU C268 Spreadsheets OA Master Study Guide - Original practice material Page 3
SPREADSHEETS
OA MASTER STUDY GUIDE
88 performance-based tasks with step-by-step solutions
Formulas - PivotTables - Charts - Financial Models
2026 Updated Edition
Includes companion Excel practice workbook
Original educational practice material. It is not an official WGU exam, answer key, or guaranteed representation of a current
assessment form.
WGU C268 Spreadsheets OA Master Study Guide - Original practice material Page 1
, How to Use This Bundle
C268 is best learned by doing. Work in the companion .xlsx file while keeping this guide open. Attempt each task from the
Task Checklist before viewing the Solutions sheet or the method below.
Pass Action Evidence
1. Read Identify the required object, function, range, and format. You can state what must change.
2. Perform Use Excel commands or enter the formula exactly. The workbook reflects the requested action.
3. Verify Inspect displayed result, formula bar, and formatting. The result is logically and visually correct.
4. If wrong, check references, parentheses, ranges, and number format. The cause is corrected, not hidden.
Diagnose
High-Yield Formula Map
Purpose Formula pattern Reference warning
Revenue =Units*UnitPrice Relative references when filled
Profit =Revenue-Cost Subtraction order
Margin =IFERROR(Profit/Revenue,0) Format as percentage
Criteria total =SUMIFS(sum_range,criteria_range,criteria) All ranges same size
Exact lookup =XLOOKUP(key,keys,return,"Not Found",0) Exact match; lock tables
Alternate lookup =INDEX(return,MATCH(key,keys,0)) MATCH mode 0
Running total =SUM($C$5:C5) Mixed expanding range
Payment =PMT(rate/periods,number_periods,-principal) Rate and periods use same frequency
NPV =NPV(rate,future_flows)+initial_flow Year 0 outside NPV
Break-even =FixedCosts/(Price-VariableCost) Use contribution margin
WGU C268 Spreadsheets OA Master Study Guide - Original practice material Page 2
, 1. Workbook Setup and Navigation
Module goal: Complete all 11 actions without using the solution, then verify the outcome. Tasks 1-11.
Task 1: Rename a worksheet and apply a descriptive tab name
Method / formula: Double-click the sheet tab, type the requested name, and press Enter. Keep names short enough to
display.
Verification: The new tab name matches the instruction exactly.
Troubleshooting cue: Confirm the active sheet and selected range first; then inspect formula references, data type, and number format.
Task 2: Move a worksheet into the requested order
Method / formula: Drag the sheet tab left or right until the insertion marker is in the requested position.
Verification: The workbook tab sequence is correct.
Troubleshooting cue: Confirm the active sheet and selected range first; then inspect formula references, data type, and number format.
Task 3: Freeze the top row of a data table
Method / formula: Select View > Freeze Panes > Freeze Top Row. Scroll down to confirm the heading remains visible.
Verification: Row 1 or the designated header row stays on screen.
Troubleshooting cue: Confirm the active sheet and selected range first; then inspect formula references, data type, and number format.
Task 4: Set print orientation to Landscape
Method / formula: Open Page Layout > Orientation > Landscape. Use Print Preview to confirm the table fits better
horizontally.
Verification: Preview shows landscape orientation.
Troubleshooting cue: Confirm the active sheet and selected range first; then inspect formula references, data type, and number format.
Task 5: Define a print area for the populated range
Method / formula: Select the required range, choose Page Layout > Print Area > Set Print Area, then preview.
Verification: Only the required cells print.
Troubleshooting cue: Confirm the active sheet and selected range first; then inspect formula references, data type, and number format.
Task 6: Insert a header containing the workbook title
Method / formula: Use Insert > Header & Footer, select the center header section, and enter the exact title.
Verification: The title appears in page-layout or print preview.
Troubleshooting cue: Confirm the active sheet and selected range first; then inspect formula references, data type, and number format.
WGU C268 Spreadsheets OA Master Study Guide - Original practice material Page 3
