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 cell N16, calculate Total Pay for the first project (Job Pay + Time Bonus $).
- =K16+J16
- =K16+J16+K16
- =$K$16+$J$16
- =K16+$J$16
Explanation
Total Pay is simply the sum of regular pay plus any bonus earned. Both references must be relative so the formula works when copied down all 20 rows of Table1. Using any $ signs causes incorrect totals for every employee below row 16.
Correct Answer Is:
=K16+J16
Change the worksheet tab name to “C268 OA – [Your Name]”.
- Right-click tab → Rename → C268 OA – John Michael
- Double-click tab → type name
Explanation
Personalized tab name helps the evaluator. Using your real name here speeds up grading by 24 hours. Worth 1 point but everyone forgets it.
Correct Answer Is:
Right-click tab → Rename → C268 OA – John Michael
Protect the worksheet while allowing users to use the slicer and sort the data in table 1. Do not require a password.
- (Review → Protect Sheet → check "Use PivotTable & PivotChart" and "Sort" → OK)
- (Review → Protect Sheet → leave password blank → allow Sort and Use PivotTable reports → OK)
- (File → Protect Workbook → Encrypt with password)
- (Review → Protect Sheet → check all boxes → OK)
Explanation
The final task in every C268 OA is worksheet protection that still permits interactivity. Users must be able to click the Project Type slicer and sort table 1 by any column, so "Sort" and "Use PivotTable & PivotChart" must be checked. Leaving password blank is required. Forgetting to allow these two actions causes the slicer to gray out and costs 5 critical points.
Correct Answer Is:
(Review → Protect Sheet → leave password blank → allow Sort and Use PivotTable reports → OK)
Create a clustered column chart using the summary table G38:H42. Place the chart in cell A55, switch row/column so employee names are on the X-axis, and change the title to exactly “Total Employee Pay”.
- Select G38:H42 → Insert → Clustered Column → move chart to A55 → Switch Row/Column → click title → type Total Employee Pay
- Insert → Recommended Charts → Clustered Column
- Select data → F11 → move chart
Explanation
The grader checks four things: exact data range G38:H42, chart starts in A55, Switch Row/Column was used (otherwise departments become bars), and title is exactly “Total Employee Pay” (case-sensitive). This chart is worth 7 points and appears in 100% of current OAs.
Correct Answer Is:
Select G38:H42 → Insert → Clustered Column → move chart to A55 → Switch Row/Column → click title → type Total Employee Pay
Use the FILTER function in cell T5 to spill all rows for the employee name typed in T4.
- =FILTER(Table1[[Employee]:[Total Pay]],Table1[Employee]=T4)
- =FILTER(Table1,Table1[Employee]=T4)
- =SPILL(VLO crossing)
Explanation
Dynamic arrays are tested heavily. FILTER must include headers and spill automatically when T4 changes. This replaces old VLOOKUP methods and is worth 5 points.
Correct Answer Is:
=FILTER(Table1,Table1[Employee]=T4)
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
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 X16 use nested IF to assign a performance grade: Quality 3="A", 2="B", 1="C".
- =IF(H16=3,"A",IF(H16=2,"B","C"))
- =IF(H16>2,"A","B")
- =CHOOSE(H16,"C","B","A")
- =IF(H16>=3,"A",IF(H16>=2,"B","C"))
Explanation
Nested IF evaluates from left to right: first check for 3 (A), else check for 2 (B), else C. Relative reference H16 copies down perfectly. CHOOSE works but grader prefers explicit IF for readability. Worth 3 points in logical functions.
Correct Answer Is:
=IF(H16=3,"A",IF(H16=2,"B","C"))
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
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 .