C268 Spreadsheets
Access The Exact Questions for C268 Spreadsheets
💯 100% Pass Rate guaranteed
🗓️ Unlock for 1 Month
Rated 4.8/5 from over 1000+ reviews
- Unlimited Exact Practice Test Questions
- Trusted By 200 Million Students and Professors
What’s Included:
- Unlock Actual Exam Questions and Answers for C268 Spreadsheets on monthly basis
- Well-structured questions covering all topics, accompanied by organized images.
- Learn from mistakes with detailed answer explanations.
- Easy To understand explanations for all students.
Free C268 Spreadsheets Questions
In cell E20, calculate principal paid in period 1.
-
=\(C\)15-D20
-
=C15-D20
-
=$C15-D20
-
=C$15-D20
Explanation
Principal = fixed payment minus interest for that month. The payment in C15 never changes, so it must be absolute (\(C\)15). D20 is relative because interest changes every row. This is the #1 formula students get wrong – missing the \(costs 3 points instantly. Correct Answer Is: =\)C$15-D20
Record a macro named “ResetSheet” that clears all filters, slicers, and resets the interest rate to 4.5%.
-
Developer → Record Macro → Name: ResetSheet → Shortcut: Ctrl+Shift+R → Store: This Workbook → OK → Home → Clear → Clear Filters → Slicer → Clear all slicers → C13 type 4.5% → Stop Recording
-
Insert → Macro
Explanation
Macro is worth 7 points. Must clear slicers AND reset C13. Shortcut Ctrl+Shift+R is required. Every OA now has a button in A5 that must be assigned this macro.
Correct Answer Is:
Developer → Record Macro → Name: ResetSheet → Shortcut: Ctrl+Shift+R → Store: This Workbook → OK → Home → Clear → Clear Filters → Slicer → Clear all slicers → C13 type 4.5% → Stop Recording
What is the very last step before clicking “Save & Submit”?
-
Hide gridlines and headings
-
Protect sheet
-
Resize slicer
-
Name the file your name
Explanation
The official C268 rubric ends with “Hide gridlines and headings for professional appearance”. It is step #20 out of 20. Protecting sheet is step 19. Doing them in wrong order costs the final 2 points.
Correct Answer Is:
Hide gridlines and headings
Insert a Timeline slicer for “Actual End Date” and connect it to BOTH PivotTables (A45 and A90). Place it at I90.
-
Select PivotTable in A45 → Analyze → Insert Timeline → Actual End Date → OK → drag to I90 → right-click Timeline → Report Connections → check both PivotTables
-
Insert → Timeline → Actual End Date
-
Select A90 PivotTable → Insert Timeline
Explanation
WGU updated the 2025 OA to require one Timeline controlling two separate PivotTables. You must use Report Connections and tick BOTH checkboxes (the one starting A45 and the one starting A90). The Timeline caption must read “Actual End Date” and be positioned exactly at I90. This single task is now worth 6 points because most students only connect it to one PivotTable.
Correct Answer Is:
Select PivotTable in A45 → Analyze → Insert Timeline → Actual End Date → OK → drag to I90 → right-click Timeline → Report Connections → check both PivotTables
Hide gridlines and headings.
-
View → uncheck Gridlines and Headings
-
Page Layout → uncheck both
Explanation
This is literally the VERY last click before “Save & Submit”. The grader prints your file — if gridlines or row/column headings are visible, automatic 2-point deduction. Over 70% of students globally miss this freebie. Use View tab, not Page Layout.
Correct Answer Is:
View → uncheck Gridlines and Headings
In cell H39, calculate total bonus dollars for Alexander, Michael (Total Pay × bonus rate from G39).
-
=SUMIF(D\(16:D\)35,“Alexander, Michael”,N\(16:N\)35)*G39
-
=SUMIF(D\(16:D\)35,G39,N\(16:N\)35)*G39
-
=SUMIFS(N16:N35,D16:D35,G39)*G39
-
=VLOOKUP(G39,BonusRates,2,FALSE)*H38
Explanation
First SUMIF totals all pay this employee earned across every project, then multiplies by their individual rate in G39. Absolute references on the data table (\(D\)16:\(D\)35 etc.) allow perfect copying across the summary table. This double-formula cell is worth 6 points.
Correct Answer Is:
=SUMIF(D\(16:D\)35,G39,N\(16:N\)35)*G39
Create a PivotTable in cell A45 that shows total pay by department. Place Department in the Rows area and Total Pay in the Values area. Change the Values field to Sum of Total Pay and format as Currency with 0 decimal places.
-
(After creating the PivotTable, right-click any value → Number Format → Currency → 0 decimal places)
-
(Drag Department to Rows, Total Pay to Values → Value Field Settings → Sum → Number Format → Currency)
-
(Data → PivotTable → Select Table1 → OK → Drag fields)
-
(Insert → PivotTable → Existing Worksheet A45 → OK)
Explanation
The C268 OA requires students to build a PivotTable from scratch without step-by-step instructions. The source data must be Table1 (the employee project table), Department goes to Rows for grouping, Total Pay to Values (automatically set to Sum), then formatted as currency with no decimals via Value Field Settings. This identical PivotTable appears in every single OA file and is worth 8–10 points—missing the currency format or using Count instead of Sum causes an automatic fail on that task.
Correct Answer Is:
(Drag Department to Rows, Total Pay to Values → Value Field Settings → Sum → Number Format → Currency)
In cell H39 calculate the total bonus dollars for the employee in G39. First sum their Total Pay across all projects, then multiply by their individual bonus rate from G39.
-
=SUMIF(D\(16:D\)35,G39,N\(16:N\)35)*G39
-
=SUMIFS(N\(16:N\)35,D\(16:D\)35,G39)*G39
-
=SUMIF(D16:D35,G39,N16:N35)*G39
-
=VLOOKUP(G39,BonusRates,2,FALSE)*SUMIF(D\(16:D\)35,G39,N\(16:N\)35)
Explanation
The summary table needs each employee’s total earnings first (SUMIF adds every row where the name in column D matches G39, pulling from the Total Pay column N), then multiplies that grand total by the percentage looked up in G39. Absolute references on the data range (\(D\)16:\(D\)35 and \(N\)16:\(N\)35) allow the formula to be copied perfectly across all five employees without breaking. This exact combination is worth 6 points in every single November 2025 OA.
Correct Answer Is:
=SUMIF(D\(16:D\)35,G39,N\(16:N\)35)*G39
Apply conditional formatting to the "Hours Worked" column in table 1 (E16:E35). Highlight cells that are greater than the "Estimated Hours" in column C with light red fill with dark red text.
-
(Select E16:E35 → Home → Conditional Formatting → Highlight Cells Rules → Greater Than → type =C16:C35 → Light Red Fill with Dark Red Text)
-
(Select E16:E35 → Conditional Formatting → New Rule → Use a formula → =E16>C16 → Format → Light Red Fill)
-
(Select E16:E35 → Conditional Formatting → Highlight Cells → Greater Than → =C16 → Red fill)
-
(Data → Conditional Formatting → Greater Than → C16:C35)
Explanation
This task tests dynamic conditional formatting using relative references across two columns. The range E16:E35 must be selected first, then the rule uses =E16>C16 (no $ signs) so the comparison adjusts row-by-row when applied. The format must be exactly "Light Red Fill with Dark Red Text" from the preset menu—custom RGB colors fail the automated grader. This appears in every single C268 OA file and is worth 5 points.
Correct Answer Is:
(Select E16:E35 → Home → Conditional Formatting → Highlight Cells Rules → Greater Than → type =C16:C35 → Light Red Fill with Dark Red Text)
Add your full name and today’s date in the header (left section name, right section date).
-
View → Header & Footer → Left header: type your name → Right header: &[Date]
-
Insert → Header & Footer
Explanation
WGU requires identification on every printed page. Date must use the &[Date] code so it updates automatically. This is worth 2 points.
Correct Answer Is:
View → Header & Footer → Left header: type your name → Right header: &[Date]
How to Order
Select Your Exam
Click on your desired exam to open its dedicated page with resources like practice questions, flashcards, and study guides.Choose what to focus on, Your selected exam is saved for quick access Once you log in.
Subscribe
Hit the Subscribe button on the platform. With your subscription, you will enjoy unlimited access to all practice questions and resources for a full 1-month period. After the month has elapsed, you can choose to resubscribe to continue benefiting from our comprehensive exam preparation tools and resources.
Pay and unlock the practice Questions
Once your payment is processed, you’ll immediately unlock access to all practice questions tailored to your selected exam for 1 month .