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 I16, determine if Maria Jenkins earns the time bonus using AND.
-
=AND(E16
1) -
=AND(E16
=1) -
=AND(E16>C16,H16>1)
-
=AND(E161)
Explanation
Time bonus requires two conditions: actual hours < estimated hours AND quality score > 1. The quality scale in every OA is 1–3 where 1 = poor, 2 = good, 3 = excellent. Only scores 2 or 3 qualify for bonus, so >1 is required. This exact AND formula in column I is worth 5 points.
Correct Answer Is:
=AND(E16
Insert line sparklines in column P (P16:P35) showing each employee’s Total Pay trend across their projects.
-
Select P16:P35 → Insert → Sparklines → Line → Data Range N16:N35 → OK → Sparkline tab → Marker Color → High Point red, Low Point blue
-
Column sparklines
-
Win/Loss sparklines
Explanation
Sparklines must be Line type with red high-point markers and blue low-point markers exactly. The data range is N16:N35 (Total Pay) because each employee has multiple rows. This visual trend column is worth 4 points and appears right after the data bars task.
Correct Answer Is:
Select P16:P35 → Insert → Sparklines → Line → Data Range N16:N35 → OK → Sparkline tab → Marker Color → High Point red, Low Point blue
In cell W5 calculate average total pay for Marketing department projects only using AVERAGEIFS.
-
=AVERAGEIFS(N\(16:N\)35,B\(16:B\)35,"Marketing")
-
=AVERAGEIF(B16:B35,"Marketing",N16:N35)
-
=SUMIF(B\(16:B\)35,"Marketing",N\(16:N\)35)/COUNTIF(B\(16:B\)35,"Marketing")
-
=AVERAGEIF(N16:N35,B16:B35,"Marketing")
Explanation
AVERAGEIFS handles multiple criteria but here uses one: department in column B matching "Marketing", averaging from Total Pay column N with absolute ranges for copying. This is more efficient than manual division and scores full 4 points in summary stats.
Correct Answer Is:
=AVERAGEIFS(N\(16:N\)35,B\(16:B\)35,"Marketing")
Conditional formatting on Hours Worked (E16:E35): highlight > Estimated Hours (C16:C35) with Light Red Fill with Dark Red Text.
-
Select E16:E35 → Home → Conditional Formatting → Highlight Cells → Greater Than → =C16:C35 → Light Red Fill with Dark Red Text
-
Use formula =E16>C16
-
Greater Than → C16
Explanation
The range E16:E35 must be selected first, then the Greater Than rule must reference the entire corresponding range =C16:C35 so Excel automatically compares row-by-row. Only the preset “Light Red Fill with Dark Red Text” matches the exact RGB values the grader expects. Using a formula or typing a single cell causes static comparison and fails all 5 points.
Correct Answer Is:
Select E16:E35 → Home → Conditional Formatting → Highlight Cells → Greater Than → =C16:C35 → Light Red Fill with Dark Red Text
Apply data validation to Quality column (H16:H35) allowing only whole numbers 1, 2, or 3 with error message “Quality must be 1, 2, or 3 only.” Title must be “Invalid Quality Score”.
-
Select H16:H35 → Data → Data Validation → Settings → Whole number → between 1 and 3 → Error Alert → Style: Stop → Title: Invalid Quality Score → Error message: Quality must be 1, 2, or 3 only
-
Select H16:H35 → Data Validation → List → 1,2,3
Explanation
Using List with “1,2,3” allows text entry and fails the grader. Whole number + between 1 and 3 + exact error title and message is the only combination that scores 4 points. This rule prevents bad data and is checked in every single OA.
Correct Answer Is:
Select H16:H35 → Data → Data Validation → Settings → Whole number → between 1 and 3 → Error Alert → Style: Stop → Title: Invalid Quality Score → Error message: Quality must be 1, 2, or 3 only
Add a Form Control Combo Box that lists every unique employee name and links to cell T4 so the FILTER function updates instantly.
-
Developer → Insert → Form Controls → Combo Box → draw near T4 → right-click → Format Control → Input range: =UNIQUE(Table1[Employee]) → Cell link: \(T\)4
-
ActiveX Combo Box
-
Data Validation List
Explanation
The combo box must use the dynamic spill range =UNIQUE(Table1[Employee]) so new employees automatically appear without editing. Linking to \(T\)4 makes the FILTER function in T5:T35 update live. This replaced old Data Validation lists in 2025 and is worth 5 points.
Correct Answer Is:
Developer → Insert → Form Controls → Combo Box → draw near T4 → right-click → Format Control → Input range: =UNIQUE(Table1[Employee]) → Cell link: \(T\)4
In cell F20, calculate the principal amount for period 1 by subtracting the interest amount for period 1 (cell D20) from the payment amount (cell C15). This formula must be reusable when copied down the column.
-
=C15-D20
-
=\(C\)15-D20
-
=C15-\(D\)20
-
=\(C\)15-\(D\)20
Explanation
In a proper amortization schedule, the principal paid each period is what remains after covering the interest on the outstanding balance. Since the payment amount (C15) is fixed for the entire loan term, it must be referenced absolutely (\(C\)15) so the value never changes when the formula is copied down hundreds of rows. The interest for the current period (D20) uses a relative reference so it updates each row. This exact formula appears in the C268 OA loan amortization table and is worth multiple points for correct absolute/relative referencing.
Correct Answer Is:
=\(C\)15-D20
Create a one-variable data table in cells U10:V21 that shows monthly payment for interest rates from 3% to 6% in 0.25% increments (link to PMT in C15).
-
Select U10:V21 → Data → What-If Analysis → Data Table → Row input cell: C13
-
Select U10:U21 → Data Table → Column input cell: C13
-
Data → Forecast → What-If
Explanation
The data table range U10:V21 has rates in row 10 (U10=3%, V10=3.25%, etc.) and formula =C15 in U11. Using Row input cell C13 fills the table horizontally with varying rates while keeping term fixed. This sensitivity analysis task is worth 6 points and appears after Scenario Manager in 100% of OAs.
Correct Answer Is:
Select U10:V21 → Data → What-If Analysis → Data Table → Row input cell: C13
Unlock ONLY the loan input cells C11:C13 before final sheet protection.
-
Select C11:C13 → right-click → Format Cells → Protection tab → uncheck “Locked” → OK → then Review → Protect Sheet
-
Ctrl+1 → uncheck Locked
-
Select whole sheet → unlock all
Explanation
By default every cell is locked. To let users still change loan amount, years, and rate after protection, you must explicitly unlock C11:C13 first. Then protect the sheet while keeping Sort and PivotTable options checked. This two-step protection is worth 5 points.
Correct Answer Is:
Select C11:C13 → right-click → Format Cells → Protection tab → uncheck “Locked” → OK → then Review → Protect Sheet
In the final row of the amortization table, what should the ending balance show?
-
$0.00
-
-\(0.05 to\)0.05 (rounding OK)
-
Positive number
-
Blank
Explanation
Excel’s rounding means the true final balance is usually between -0.05 and +0.05. WGU’s automated grader accepts anything in this range as zero. Anything larger triggers a 10-point deduction on the entire amortization table.
Correct Answer Is:
-\(0.05 to\)0.05 (rounding OK)
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 .