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 "active listening"?
Q2. Setting SMART goals means goals should be:
Q3. Which of the following is an example of a computer input device used in ICT?
Q4. A business plan is primarily useful for:
Q5. Which of the following is an example of a green practice at a workplace?
Q6. Emotional intelligence includes the ability to:
Q7. Which of the following is a characteristic of good teamwork?
Q8. "Stress management" techniques can include:
Q9. Which of these best describes a "career pathway"?
Q10. "Digital footprint" refers to:
PART B — SUBJECT SPECIFIC SKILLS (40 Marks)
Section 1 — Objective Type Questions (1 Mark each) — Q11 to Q20
Q11. Which shortcut key is commonly used to insert a hyperlink in a document?
Q12. In LibreOffice Calc, which function returns the number of numeric cells in a range?
Q13. In a database, a "query" is used to:
Q14. Which view is used to add speaker notes to a slide in LibreOffice Impress?
Q15. Which of the following is a text-wrapping option available for images inserted in a word processor document?
Q16. In a spreadsheet, which operator is used for exponentiation (power)?
Q17. Which term refers to a set of rules that ensures the accuracy and consistency of data in a database?
Q18. Which file format is commonly used to export a presentation as a set of static images/pages for easy sharing?
Q19. What is the purpose of "Find and Replace" in a Digital Documentation tool?
Q20. Which of the following is NOT a valid database object typically found in a DBMS?
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 using "Styles" (such as Heading 1, Heading 2) in a word processing document? 2
Q22. What is a "chart" in a spreadsheet? Name any two types of charts commonly used. 2
Q23. What is the significance of enforcing "referential integrity" between related tables in a database? 2
Q24. Explain the term "Custom Animation" in a presentation software. 2
Q25. What is the difference between relative and absolute cell referencing when a formula is copied to another cell? 2
Section 3 — Long Answer Questions (4 Marks each) — Q26 to Q30
Q26. Explain the steps to create a table of contents automatically in a LibreOffice Writer document using heading styles. 4
Q27. Explain the concept of "conditional formatting" in a spreadsheet, and describe how it can be applied, with a suitable example. 4
Q28. Describe the steps to create a query in a database to retrieve specific records based on given criteria (e.g., students scoring above 80 marks). 4
Q29. Explain any four features/tools available in LibreOffice Impress that help make a presentation more effective and engaging. 4
Q30. What are macros in a spreadsheet/document application? Explain their purpose, and describe one situation where using a macro would be beneficial. 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 | (A) | 7 | (B) |
| 3 | (C) | 8 | (B) |
| 4 | (B) | 9 | (B) |
| 5 | (B) | 10 | (B) |
PART B — SUBJECT SPECIFIC SKILLS
Section 1 — Answer Key
| Q | Ans | Q | Ans |
|---|---|---|---|
| 11 | (A) Ctrl+K | 16 | (C) ^ |
| 12 | (B) COUNT() | 17 | (B) Data integrity |
| 13 | (B) Retrieve specific data | 18 | (B) .pdf |
| 14 | (B) Notes view | 19 | (B) Search and replace text |
| 15 | (B) Square/Wrap around | 20 | (D) Slide |
Section 2 — Key Answers
Q21. Styles allow consistent, reusable formatting to be applied to text (e.g., all main headings look the same); they also make it possible to automatically generate features like a table of contents based on the heading levels used.
Q22. A chart is a graphical representation of spreadsheet data, making trends and comparisons easier to understand visually; examples include Bar chart, Pie chart, and Line chart (any two correctly named types).
Q23. Referential integrity ensures that relationships between tables remain consistent — for example, preventing a record from referencing a foreign key value that does not exist in the related table — thereby maintaining accurate and reliable data across the database.
Q24. Custom Animation allows the presenter to apply and control specific entrance, emphasis, or exit visual effects to individual objects (text, images) on a slide, controlling how and when each element appears or moves during the presentation.
Q25. A relative reference automatically adjusts (changes) to reflect its new position when a formula is copied to another cell; an absolute reference (marked with $) remains fixed and does not change, always referring to the same specific cell regardless of where the formula is copied.
Section 3 — Key Answers
Q26. Steps: (1) Apply appropriate heading styles (Heading 1, Heading 2, etc.) to the section titles throughout the document. (2) Place the cursor where the table of contents should appear. (3) Go to Insert → Table of Contents and Index → Table of Contents, Index or Bibliography. (4) Configure the desired settings (number of levels, etc.) and click OK. (5) The table of contents is generated automatically, listing headings with page numbers, and can be updated later if the document changes.
Q27. Conditional formatting automatically changes the appearance (e.g., cell colour, font) of cells based on specified conditions/rules; for example, in a marks sheet, cells with values below 33 could be automatically highlighted in red to flag failing scores, making such data instantly visible without manually checking each cell.
Q28. Steps: (1) Open the database and go to the Queries section. (2) Choose "Create Query in Design View" (or use the Query Wizard). (3) Select the required table(s) and add the necessary fields to the query grid. (4) In the "Criteria" row under the relevant field (e.g., Marks), enter the condition (e.g., >80). (5) Run the query to view only the records matching the specified criteria.
Q29. Features include: Slide Master (for consistent design across all slides), Slide Transitions (visual effects between slides), Custom Animation (effects for individual objects), and multimedia insertion (audio/video) to make the presentation more engaging and professional-looking.
Q30. A macro is a recorded sequence of commands/actions that can be replayed with a single command, automating repetitive tasks; for example, if a user regularly needs to format a report in a specific way (fonts, borders, headers) each week, a macro can be recorded once and then run automatically to perform all those steps instantly, saving time and reducing errors.
Page 3 of 3 (Answer Key) | www.careerinformationportal.in
