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
How many rows must the amortization table have to reach exactly $0.00 balance?
- 360
- 361
- 30
- 12
Explanation
Row 19 = headers, row 20 = period 0, rows 21–380 = periods 1–360, row 381 = final check. Total visible rows including headers = 361. The grader counts rows automatically and deducts 3 points for 360 or 380.
Correct Answer Is:
361
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
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)
Final file must contain exactly this many sheets:
- 3
- 4
- 2
- 5
Explanation
2025 OA always has: Main Sheet → Summary → Master → (hidden) Power Query sheet. Total = 3 visible sheets.
Correct Answer Is:
3
In cell V5 use the CHOOSECOLS function to extract only columns Employee, Total Pay, and Quality from Table1.
- =CHOOSECOLS(Table1,1,8,5)
- =TAKE(Table1,,3)
- =FILTER(Table1,{1,5,8})
Explanation
CHOOSECOLS is brand new and tested in every 2025 file. Column positions: 1=Employee, 5=Quality, 8=Total Pay. Spills instantly in V5. Worth 4 points.
Correct Answer Is:
=CHOOSECOLS(Table1,1,8,5)
Assign the ResetSheet macro to the button in cell A5.
- Right-click button in A5 → Assign Macro → ResetSheet → OK
- Developer → Insert → Button → draw
Explanation
Button exists already in every OA file. You only need to assign the macro you just recorded. Clicking the button must do everything in one click.
Correct Answer Is:
Right-click button in A5 → Assign Macro → ResetSheet → OK
In cell F19 (Period 0 beginning balance) enter the starting loan amount.
- =C11
- =$C$11
- 250000
- =C11*1
Explanation
Simple relative reference to the loan amount in C11. No $ needed because this cell is never copied. This is the only cell in the entire table that directly references C11.
Correct Answer Is:
=C11
In cell P5, count how many projects earned a time bonus using COUNTIFS.
- =COUNTIFS(I$16:I$35,TRUE)
- =COUNTIF(I16:I35,TRUE)
- =COUNTIFS(H$16:H$35,">1″)
- =SUMIF(I$16:I$35,TRUE)
Explanation
Column I contains TRUE/FALSE from the AND function. COUNTIFS with TRUE is the only function that correctly counts bonus-eligible projects. Using COUNTIF or checking Quality column directly fails the grader. This summary stat is worth 3 points.
Correct Answer Is:
=COUNTIFS(I$16:I$35,TRUE)
Use INDEX + MATCH to return the employee name with the HIGHEST Total Pay (look in the summary table G38:H42).
- =INDEX(G39:G42,MATCH(MAX(H39:H42),H39:H42,0))
- =VLOOKUP(MAX(H39:H42),G38:H42,1,FALSE)
- =INDEX(G38:H42,MATCH(LARGE(H39:H42,1),H39:H42,0))
Explanation
Classic dynamic lookup that beats VLOOKUP. INDEX returns from the name column G, MATCH finds the position of the actual maximum value in H39:H42. This exact formula in cell A99 scores 5 points and appears in every single OA since July 2025.
Correct Answer Is:
=INDEX(G39:G42,MATCH(MAX(H39:H42),H39:H42,0))
In cell T5 use INDEX and MATCH to return the name of the employee with the highest total pay from the summary table G38:H42.
- =INDEX(G39:G42,MATCH(MAX(H39:H42),H39:H42,0))
- =VLOOKUP(MAX(H39:H42),G38:H42,1,FALSE)
- =INDEX(H39:H42,MATCH(MAX(G39:G42),G39:G42,0))
- =XLOOKUP(MAX(H39:H42),H39:H42,G39:G42)
Explanation
INDEX MATCH is the preferred dynamic lookup in advanced C268 tasks because it looks up the position of the maximum value in the pay column H39:H42, then returns the corresponding name from G39:G42. This formula spills correctly and handles ties automatically. It appears in every 2025 OA summary section and is worth 5 points as it tests non-contiguous lookups better than VLOOKUP or XLOOKUP.
Correct Answer Is:
=INDEX(G39:G42,MATCH(MAX(H39:H42),H39:H42,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 .