www.careerinformationportal.in
APNA CAREER PORTAL
www.careerinformationportal.in
CBSE Sample Practice Paper — 4 (Session 2026–27)
| Student Name: ______________________ | Roll No.: __________ | Section: __________ |
General Instructions:
1. This paper is divided into two parts — Part A: Employability Skills (10 Marks), and Part B: Subject Specific Skills (40 Marks).
2. Part B is further divided into three sections: Section 1 — Objective Type/MCQ (10 Marks), Section 2 — Short Answer (10 Marks), Section 3 — Long Answer (20 Marks).
3. All questions are compulsory. Marks for each question are indicated against it.
4. Write short and precise answers wherever asked.
PART A — EMPLOYABILITY SKILLS (10 Marks)
Choose the correct option for each of the following questions: 10 × 1 = 10
Q1. Which of the following best describes "self-awareness" as a life skill?
Q2. In a SWOT analysis, increasing competition from a new company entering the market would be classified as a:
Q3. Which of the following is an example of "stress management"?
Q4. Which of the following is an example of an ICT-enabled service?
Q5. Which of the following is a key characteristic that helps an entrepreneur adapt to a changing market?
Q6. Using energy-efficient LED bulbs instead of traditional bulbs is an example of practising:
Q7. Which of the following is an example of a "soft skill"?
Q8. Repairing a broken appliance instead of throwing it away is an example of which "R" among the 4 Rs of sustainability?
Q9. Which of the following best supports effective goal-setting?
Q10. Which of the following is a barrier to effective communication?
PART B — SUBJECT SPECIFIC SKILLS (40 Marks)
Section 1 — Objective Type Questions (1 Mark each) — Q11 to Q20
Q11. Which of the following is a presentation application?
Q12. Which function is used to find the smallest value in a range of cells?
Q13. A set of rules that ensures the accuracy and consistency of data in a database is known as:
Q14. Which of the following file extensions is used for a LibreOffice Impress presentation file?
Q15. In mail merge, the file that contains the list of names, addresses or other varying information is called the:
Q16. Which of the following is a valid formula to add the values in cells A1 and A2 in a spreadsheet?
Q17. Which SQL command is used to remove a record from a database table?
Q18. Which feature allows you to add a running commentary or explanation below each slide, visible only to the presenter?
Q19. Which of the following is the correct order of operator precedence in a spreadsheet formula (from highest to lowest)?
Q20. A form in a database application is primarily used for:
Page 1 of 3 | www.careerinformationportal.in
www.careerinformationportal.in
Section 2 — Short Answer Questions (2 Marks each) — Q21 to Q25
Q21. What is the purpose of "Find and Replace" in a Digital Documentation application? Give one example of its use. 2
Q22. Write the steps to change the font style and size of selected text in a word processing document. 2
Q23. What is meant by "freezing panes" in a spreadsheet? State one situation where it would be useful. 2
Q24. What is a "report" in a database application? State one purpose it serves. 2
Q25. What is "slide animation" in a presentation? How is it different from a "slide transition"? 2
Section 3 — Long Answer Questions (4 Marks each) — Q26 to Q30
Q26. Explain the steps to insert and format an image (resize, wrap text) within a word processing document. 4
Q27. Explain the steps to create a simple formula-based budget spreadsheet that calculates total income, total expenses, and the balance remaining, using at least two different functions. 4
Q28. Explain the steps to create a query in a database application to display specific fields from a table based on a given condition (e.g., listing students who scored more than 80 marks). 4
Q29. Explain the steps to insert and customise a chart/graph (e.g., a bar chart) within a slide of a presentation to visually represent data. 4
Q30. What is meant by "cell protection" in a spreadsheet? Explain its importance with a suitable example (e.g., protecting formula cells in a shared worksheet from accidental editing). 4
Page 2 of 3 | www.careerinformationportal.in
www.careerinformationportal.in
APNA CAREER PORTAL
www.careerinformationportal.in
Answer Key & Marking Scheme (Key Points)
PART A — EMPLOYABILITY SKILLS
| Q | Ans | Q | Ans |
|---|---|---|---|
| 1 | (B) | 6 | (B) |
| 2 | (D) | 7 | (A) |
| 3 | (B) | 8 | (B) |
| 4 | (A) | 9 | (B) |
| 5 | (B) | 10 | (B) |
PART B — SUBJECT SPECIFIC SKILLS
Section 1 — Answer Key
| Q | Ans | Q | Ans |
|---|---|---|---|
| 11 | (C) LibreOffice Impress | 16 | (B) =A1+A2 |
| 12 | (A) MIN() | 17 | (D) DELETE |
| 13 | (B) Data integrity | 18 | (B) Speaker Notes |
| 14 | (C) .odp | 19 | (B) Exponentiation, Multiplication/Division, Addition/Subtraction |
| 15 | (B) Data source | 20 | (B) Entering and viewing data in a user-friendly interface |
Section 2 — Key Answers
Q21. "Find and Replace" locates specific words or phrases in a document and allows the user to automatically replace them with alternative text; e.g., quickly replacing every occurrence of an old company name with a new one throughout a long document.
Q22. Select the required text → open the Font Name dropdown on the toolbar and choose the desired font style → open the Font Size dropdown and select the desired size (alternatively, use Format → Character for more detailed options).
Q23. Freezing panes keeps selected rows and/or columns (such as headers) visible on screen while scrolling through the rest of a large spreadsheet; useful, for example, when scrolling through hundreds of rows of data while keeping the column headers always visible at the top.
Q24. A report is a formatted, print-ready presentation of data retrieved from one or more database tables/queries; it serves the purpose of summarising and presenting data in an organised, professional manner for viewing or printing (e.g., a monthly sales report).
Q25. Slide animation applies a visual effect to individual objects/text within a single slide (e.g., text flying in); a slide transition applies a visual effect to the change between two entire slides as the presentation moves from one to the next.
Section 3 — Key Answers
Q26. Steps: place the cursor at the desired location → Insert menu → Image → From File → select the required image and insert it → click on the inserted image to select it, then drag its corner handles to resize it proportionally → right-click and choose "Wrap Text" (e.g., "Wrap Around" or "Optimal Page Width") to control how surrounding text flows around the image.
Q27. Steps: create a spreadsheet with columns for income items and expense items, entering their respective amounts → use =SUM(range) to calculate total income and total expenses separately → use a subtraction formula, e.g., =TotalIncome−TotalExpenses (or =SUM(IncomeRange)−SUM(ExpenseRange)), to calculate the remaining balance in a designated cell.
Q28. Steps: open the database and go to the Queries section → choose "Create Query in Design View" → select the required table and add the necessary fields to the query grid → in the Criteria row under the "Marks" field, enter the condition (e.g., >80) → run the query to display only the records/fields meeting this condition.
Q29. Steps: select the slide where the chart is needed → Insert menu → Chart → a default chart with sample data appears → double-click the chart and edit the underlying data table to enter the actual values → choose the desired chart type (e.g., Bar) from the chart type options → click outside the chart to finalise it, then resize/reposition it on the slide as needed.
Q30. Cell protection restricts editing of specific cells in a spreadsheet, typically after the sheet is "protected," so that only unlocked cells remain editable; this is important, for example, in a shared worksheet where formula cells (which calculate totals automatically) should be locked/protected to prevent accidental changes, while data-entry cells remain open for users to fill in.
Page 3 of 3 (Answer Key) | www.careerinformationportal.in
