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 100 + 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
Add data bars to the Total Pay column N16:N35 (blue gradient).
- Select N16:N35 → Home → Conditional Formatting → Data Bars → Gradient Fill (blue)
- Data Bars → Solid Fill
Explanation
Visualizes pay distribution instantly. Only the blue gradient version scores full points; solid fill or different colors fail. This is worth 3 easy points.
Correct Answer Is:
Select N16:N35 → Home → Conditional Formatting → Data Bars → Gradient Fill (blue)
In cell C15, calculate the monthly payment for a $250,000 loan at 4.5% annual interest for 30 years. Use the PMT function with correct signs so the result is positive.
- =PMT(C13/12,C12,-C11)
- =PMT(C13/12,C12,C11)
- =PMT(C13,C12,-C11)
- =PMT(C13/12*12,C12,-C11)
Explanation
The PMT function requires the rate per period (annual rate in C13 divided by 12), total number of payments (years in C12 – no need to multiply by 12 because the rate is already monthly), and present value as negative when you’re the borrower. Using -C11 produces a positive payment that can be copied into every row of the amortization table. This identical formula appears in 100% of C268 files in cell C15 and is worth 4 points.
Correct Answer Is:
=PMT(C13/12,C12,-C11)
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
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
Protect sheet but still allow Sort and Use PivotTable & PivotChart. No password.
- Review → Protect Sheet → check Sort & Use PivotTable & PivotChart → OK (leave password blank)
- Protect Sheet → check all
- File → Protect
Explanation
Unchecking “Sort” grays out table headers; unchecking “Use PivotTable & PivotChart” disables the slicer. Both must stay checked while everything else is locked. Leaving password blank is mandatory. This final protection step is worth 5 points and appears in 100% of November 2025 exams.
Correct Answer Is:
Review → Protect Sheet → check Sort & Use PivotTable & PivotChart → OK (leave password blank)
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
In cell J16, calculate the time bonus dollar amount. If I16 is TRUE, pay 15% of Job Pay; otherwise 0.
- =IF(I16,K16*$M$11,0)
- =IF(I16=TRUE,K16*$M$11,0)
- =IF(I16=K16*$M$11,0)
- =IF(I16=TRUE,K16*M11,0)
Explanation
Excel treats TRUE/FALSE as logical values, so testing I16 alone is sufficient; adding =TRUE is redundant and fails the grader. The bonus rate in M11 must be absolute ($M$11) so every row uses the same 15%. This formula in column J is copied down to J35 and is worth 4 points in every single OA.
Correct Answer Is:
=IF(I16,K16*$M$11,0)
Add line sparklines to column O (O16:O35) showing trend of Total Pay for each employee across their projects.
- Select O16:O35 → Insert → Sparklines → Line → Data Range: N16:N35 → OK → Sparkline → Marker Color → High Point → Red
- Column sparklines
Explanation
Sparklines must be Line type (not column) and show markers for high point in red. This visual appears in every single 2025 file and is worth 4 points.
Correct Answer Is:
Select O16:O35 → Insert → Sparklines → Line → Data Range: N16:N35 → OK → Sparkline → Marker Color → High Point → Red
Freeze panes so the headers in row 15 stay visible when scrolling down.
- Select cell A16 → View → Freeze Panes → Freeze Panes
- View → Freeze Top Row
- View → Freeze First Column
Explanation
Headers are in row 15, so you must select A16 first, then freeze panes. Freezing only the top row keeps row 1 visible instead and costs 2 points. This is checked in every single OA.
Correct Answer Is:
Select cell A16 → View → Freeze Panes → Freeze Panes
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 .