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.
Access and unlock Multiple Practice Question for C268 Spreadsheets to help you Pass at ease.
Free C268 Spreadsheets Questions
In the PivotTable A45, group the Department field into "IT" and "Non-IT".
- Right-click any Department value → Group → select IT items → OK → add Non-IT group
- PivotTable Analyze → Group Field
- Data → Group
Explanation
Grouping categorizes text fields for higher-level analysis. Right-click a specific department like "Development", select Group, choose IT-related items, then manually add "Non-IT" as a second group. This custom grouping tests PivotTable flexibility and is worth 4 points.
Correct Answer Is:
Right-click any Department value → Group → select IT items → OK → add Non-IT group
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)
What must the ending balance in cell F379 show for full credit?
- Exactly $0.00
- Between -$0.05 and +$0.05
- Positive balance
- Negative balance
Explanation
Due to rounding in Excel, a balance between -0.05 and +0.05 is accepted as zero. The grader allows this tiny range. Anything outside costs 10 points on the entire amortization table.
Correct Answer Is:
Between -$0.05 and +$0.05
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
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)
In cell F20, calculate the ending balance for period 1.
- =F19-E20
- =$F$19-E20
- =F19-$E$20
- =$F$19-$E$20
Explanation
Ending balance = beginning balance minus principal paid. Both cells must be relative so the formula can be copied down 360 rows and always look at the row above. Using any $ signs here causes the balance to never decrease and fails the entire amortization table.
Correct Answer Is:
=F19-E20
Add a calculated field to the PivotTable in A45 called "Bonus %" that multiplies Sum of Total Pay by 0.15.
- PivotTable Analyze → Fields, Items & Sets → Calculated Field → Name: Bonus % → Formula: ='Sum of Total Pay'*0.15 → OK
- Value Field Settings → Calculated Field
- PivotTable Design → Calculated Field
Explanation
Calculated fields let you create new metrics inside the PivotTable without altering source data. The formula uses the exact field name 'Sum of Total Pay' multiplied by the company bonus rate 0.15. Drag the new field to Values for instant company-wide bonus calculation. This is worth 5 points in the advanced PivotTable section.
Correct Answer Is:
PivotTable Analyze → Fields, Items & Sets → Calculated Field → Name: Bonus % → Formula: ='Sum of Total Pay'*0.15 → OK
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
Set the print area to exactly A1:O380 and fit to 1 page wide by 1 page tall.
- Select A1:O380 → Page Layout → Print Area → Set Print Area → Page Layout → Dialog launcher → Page tab → Fit to 1 page wide by 1 tall
- File → Print → Scaling → Fit Sheet on One Page
Explanation
The grader prints your file automatically. If it spills to 2 pages, you lose 3 points. Both steps are required: set the exact print area first, then force fit.
Correct Answer Is:
Select A1:O380 → Page Layout → Print Area → Set Print Area → Page Layout → Dialog launcher → Page tab → Fit to 1 page wide by 1 tall
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]
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 .