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
Create clustered column chart in A55 using G38:H42. Switch Row/Column, title “Total Employee Pay”.
- Select G38:H42 → Insert → Clustered Column → Move chart → Existing worksheet A55 → Switch Row/Column → Chart Title → Total Employee Pay
- Insert → Recommended Charts
- Select data → F11 → Move chart
Explanation
The automated grader looks for: exact data range G38:H42, chart object anchored at A55, Row/Column switched so employee names are on the X-axis (not departments), and the title spelled exactly “Total Employee Pay” (case-sensitive). Using Recommended Charts or pressing F11 creates a default chart that fails on location and switching, costing the entire 7-point task.
Correct Answer Is:
Select G38:H42 → Insert → Clustered Column → Move chart → Existing worksheet A55 → Switch Row/Column → Chart Title → Total Employee Pay
In Power Query Editor, remove the column “Notes” and change “Project Cost” to Currency data type.
- Home → Choose Columns → uncheck Notes → OK → Select Project Cost column → Transform → Data Type → Currency
- Right-click Notes → Remove
Explanation
Power Query tasks are new in 2025. You must remove exactly the “Notes” column and format Project Cost as Currency (not Accounting). The query must be closed and loaded after changes. Worth 4 points.
Correct Answer Is:
Home → Choose Columns → uncheck Notes → OK → Select Project Cost column → Transform → Data Type → Currency
Use the VLOOKUP function in cell I39 to return the correct bonus rate for the employee in G39. Search the lookup table named "BonusRates" (columns M:O). Employee names are in the first column of the table.
- =VLOOKUP(G39,BonusRates,2,FALSE)
- =VLOOKUP(G39,M:O,2,0)
- =VLOOKUP(G39,BonusRates,3,FALSE)
- =VLOOKUP(G39,$M$5:$O$15,2,FALSE)
Explanation
VLOOKUP is tested heavily in C268 for payroll and commission scenarios. The function needs an exact match (FALSE or 0) because employee names must match precisely. "BonusRates" is a named range covering M5:O15 where column M contains names, column N contains the bonus percentage. Specifying column index 2 returns the rate from column N. Using the named range is the cleanest, most professional method and is the exact version graded correctly in the WGU C268 OA summary section.
Correct Answer Is:
=VLOOKUP(G39,BonusRates,2,FALSE)
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
Create a clustered column chart using the data in table 3 (cells G38:H42). Place the chart starting in cell A55. Move "Total Pay" to the legend and use "Employee" for the horizontal axis. Change the chart title to "Total Employee Pay".
- (Select G38:H42 → Insert → Clustered Column → Move chart to A55 → Switch Row/Column → Chart Title → Total Employee Pay)
- (Select G38:H42 → Insert → Column Chart → Drag chart to A55 → Change title)
- (Insert → Charts → Column → Select data → Move to A55)
- (Select any cell → Insert → Recommended Charts → Clustered Column)
Explanation
The C268 OA requires a perfect clustered column chart that compares total pay across employees. The data range must be exactly G38:H42 (the summary table), and "Switch Row/Column" is mandatory so Employee names appear on the X-axis while Total Pay becomes the bars. The chart must be moved to A55 and titled exactly "Total Employee Pay" (case-sensitive). This chart is worth 6 points and fails instantly if the legend is missing or if Recommended Charts is used instead of manual creation.
Correct Answer Is:
(Select G38:H42 → Insert → Clustered Column → Move chart to A55 → Switch Row/Column → Chart Title → Total Employee Pay)
Refresh the PivotTable in A90 so it now shows Sum of Profit by Department instead of Project Cost.
- Click PivotTable A90 → right-click → Refresh → drag Profit to Values → Value Field Settings → Sum → Number Format → Currency 0 decimals
- Analyze → Refresh All
Explanation
After adding the Profit column, you must manually refresh and replace the old field. The grader checks that A90 now shows Profit (not Project Cost) and is formatted as Currency with no decimals. This catches students who forget to refresh.
Correct Answer Is:
Click PivotTable A90 → right-click → Refresh → drag Profit to Values → Value Field Settings → Sum → Number Format → Currency 0 decimals
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
Calculate, in cell D20, the interest amount for period 1 by multiplying the balance in period 0 (cell F19) by the loan interest rate (cell C13) divided by 12. Dividing the interest rate by 12 results in the monthly interest rate. This formula is reusable. The interest for a given period is always the monthly interest rate times the balance from the previous period.
- =F19C13/12
- =F19(C13/12)
- =$F$19*$C$13/12
- =F20*C13/12
Explanation
In an amortization schedule, the interest for each period is calculated based on the remaining balance from the prior period multiplied by the monthly interest rate. The initial balance is in F19 (period 0), the annual rate in C13 must be divided by 12 for monthly compounding, and parentheses ensure proper order of operations. Using relative references (F19) allows the formula to adjust correctly when copied down the column, recalculating interest based on the updating balance each month. This is a core concept in the C268 amortization section, where accurate interest calculation feeds into principal reduction and ensures the loan pays off exactly over the term.
Correct Answer Is:
=F19*(C13/12)
Create a dynamic named range "PayData" that automatically includes new rows added to Table1.
- Formulas → Name Manager → New → Name: PayData → Refers to: =Table1[#All]
- Select N16:N35 → Name Box → PayData
- Formulas → Define Name → =OFFSET(N15,1,0,COUNTA(D:D)-15,1)
Explanation
Using =Table1[#All] makes the named range expand/contract automatically with table rows. This is cleaner than OFFSET and is the exact method graded in 2025 OAs for dynamic SUMIF/VLOOKUP. Worth 3 points.
Correct Answer Is:
Formulas → Name Manager → New → Name: PayData → Refers to: =Table1[#All]
Use the IF function to complete the "Time Bonus $" column of table 1. If an employee earns a time bonus (i.e., the corresponding cell in the "Time Bonus?" column is TRUE), then "Time Bonus $" is the "Job Pay" for that project times the bonus percentage in cell M11. Otherwise "Time Bonus $" is 0.
- =IF(I16=TRUE,K16*$M$11,0)
- =IF(I16,K16*$M$11,0)
- =IF(I16=TRUE,K16M11,0)
- =IF(I16=FALSE,K16$M$11,0)
Explanation
Nested with the previous AND result, the IF function checks the logical test in I16 (Time Bonus?). When TRUE, it multiplies Job Pay (K16) by the fixed bonus rate in M11 (absolute reference $M$11 prevents shifting when copied). When FALSE, it returns 0. This creates conditional pay calculations common in HR spreadsheets. The simplified logical test (I16) works because Excel treats TRUE/FALSE directly, and the absolute reference on M11 ensures all rows use the same company-wide bonus rate—critical for the C268 OA scoring on reusable formulas.
Correct Answer Is:
=IF(I16,K16*$M$11,0)
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 .