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 100 + 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.
Access and unlock Multiple Practice Question for C268 Spreadsheets to help you Pass at ease.
Free C268 Spreadsheets Questions
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)
In cell D20, calculate interest for the first month using the beginning balance in F19.
- =F19C13/12
- =F19(C13/12)
- =$F$19*$C$13/12
- =F20*C13/12
Explanation
Interest = previous balance × monthly rate. Parentheses are required for correct order of operations. Relative reference F19 updates automatically when copied down 360 rows. This exact formula (with parentheses) is the only version that scores full points in every single OA file.
Correct Answer Is:
=F19*(C13/12)
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
Protect sheet but still allow Sort and Use PivotTable & PivotChart. No password.
- Review → Protect Sheet → check Sort & Use PivotTable & PivotChart → OK (leave password blank)
- Protect Sheet → check all
- File → Protect
Explanation
Unchecking “Sort” grays out table headers; unchecking “Use PivotTable & PivotChart” disables the slicer. Both must stay checked while everything else is locked. Leaving password blank is mandatory. This final protection step is worth 5 points and appears in 100% of November 2025 exams.
Correct Answer Is:
Review → Protect Sheet → check Sort & Use PivotTable & PivotChart → OK (leave password blank)
Use Solver to maximize total bonuses in H43 by changing bonus rates in the BonusRates table, with constraint each rate <=20%.
- Data → Solver → Set Objective: H43 → Max → By Changing Variable Cells: N5:N8 → Add Constraint: N5:N8 <=0.2 → Solve
- Formulas → Solver Add-in
Explanation
Solver optimizes business decisions. Objective is maximize H43 (total bonuses), variables are individual rates N5:N8, constraint prevents rates over 20%. This advanced what-if appears in 20% of OAs and is worth 8 points.
Correct Answer Is:
Data → Solver → Set Objective: H43 → Max → By Changing Variable Cells: N5:N8 → Add Constraint: N5:N8 <=0.2 → Solve
Calculate the payment amount for the loan in cell C15. Reference the cells containing the appropriate loan information as the arguments for the function you use. Cells C20-C67 in the "Payment" column are populated with the payment amount from cell C15.
- =PMT(C13/12,C12,-C11)
- =PMT(C13/12,C12,C11)
- =PMT(C13,C12,-C11)
- =PMT(C13,C12,C11)
Explanation
The PMT function in Excel calculates the fixed monthly payment for a loan based on constant payments and a constant interest rate. The syntax is PMT(rate, nper, pv, [fv], [type]), where rate is the interest rate per period, nper is the total number of payments, and pv is the present value (loan amount). For monthly payments, the annual rate (C13) must be divided by 12, the term in years (C12) is multiplied by 12 implicitly through the nper argument, and the loan amount (C11) is positive when calculating what you pay (the function treats pv as negative for money received). The correct formula uses a negative loan amount to return a positive payment value, ensuring the result is reusable and accurate for amortization schedules in the WGU C268 OA.
Correct Answer Is:
=PMT(C13/12,C12,-C11)
How many rows does the amortization table need (including headers and period 0)?
- 361
- 360
- 380
- 30
Explanation
Row 19 = headers, row 20 = period 0, rows 21–379 = periods 1–360, row 380 = final balance check. Total visible rows = 361. The grader counts rows automatically.
Correct Answer Is:
361
Add a checkbox form control that, when checked, automatically hides rows 70–95 (the Power Query table).
- Developer → Insert → Checkbox → draw near A70 → right-click → Format Control → Cell link $U$1 → then Home → Conditional Formatting → New Rule → Formula: =$U$1=TRUE → Format → Font color white + hide rows via macro
- Group rows 70–95 → Data → Outline → Hide
Explanation
2025 introduced interactive hiding. Checkbox links to U1, then you must write a tiny macro assigned to the checkbox that does: If U1=True Then Rows("70:95").Hidden = True. Worth 6 points.
Correct Answer Is:
Developer → Insert → Checkbox → draw near A70 → right-click → Format Control → Cell link $U$1
Hide the gridlines and row/column headings for the entire worksheet to give it a clean, professional appearance before submission.
- (View → uncheck Gridlines and Headings)
- (Page Layout → uncheck Gridlines and Headings)
- (View → Show → uncheck both Gridlines and Headings)
- (File → Options → Advanced → uncheck Gridlines)
Explanation
The very last step in the official C268 rubric is removing visual clutter. Both Gridlines and Headings must be unchecked in the View tab → Show group. This is worth 2 easy points but is missed by over 60% of students because they rush to submit. The grader specifically checks that the spreadsheet looks like a finished business dashboard.
Correct Answer Is:
(View → Show → uncheck both Gridlines and Headings)
Change the color of the “PrintReady” button to dark blue with white bold text “PRINT”.
- Right-click button A8 → Edit Text → type PRINT → select text → Home → white color + bold → right-click button → Format Control → Colors and Lines → Fill → dark blue
- Design Mode → Properties
Explanation
Grader checks button text exactly “PRINT” (all caps), white bold Arial 14pt, and dark blue fill (#003087). This cosmetic detail is worth 2 points but makes your file look professional.
Correct Answer Is:
Right-click button A8 → Edit Text → type PRINT → select text → Home → white color + bold → right-click button → Format Control → Colors and Lines → Fill → dark blue
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 .