www.careerinformationportal.in
APNA CAREER PORTAL
www.careerinformationportal.in
CBSE Sample Practice Paper — 1 (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 is an example of non-verbal communication?
Q2. SWOT analysis helps an individual identify:
Q3. Which of the following is a self-management skill?
Q4. ICT stands for:
Q5. An entrepreneur is best described as a person who:
Q6. Green skills are primarily related to:
Q7. Which of the following is an example of a "soft skill"?
Q8. The "4 Rs" commonly associated with green/sustainable practices are:
Q9. Which of the following is NOT generally considered a characteristic of a successful entrepreneur?
Q10. Effective communication requires:
PART B — SUBJECT SPECIFIC SKILLS (40 Marks)
Section 1 — Objective Type Questions (1 Mark each) — Q11 to Q20
Q11. Which file extension is used for an OpenDocument Text file created in LibreOffice Writer?
Q12. In LibreOffice Calc, which function is used to find the average of a range of cells?
Q13. A field that uniquely identifies each record in a database table is called a:
Q14. Which view in LibreOffice Impress is used to rearrange the order of slides?
Q15. The process of combining a standard document with a data source to create personalised documents is called:
Q16. Which of the following is a valid cell reference in a spreadsheet?
Q17. Which SQL command is used to retrieve data from a database table?
Q18. Which feature is used to apply a consistent design/theme across all slides in a presentation?
Q19. Absolute cell referencing in a spreadsheet is denoted by using which symbol before the column and row?
Q20. A table in a database consists of:
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 difference between "Save" and "Save As" options in a Digital Documentation application? 2
Q22. Write the steps to insert a header and footer in a LibreOffice Writer document. 2
Q23. What is meant by "sorting" data in a spreadsheet? Give one example of a situation where it is useful. 2
Q24. Differentiate between a "Primary Key" and a "Foreign Key" in a database table. 2
Q25. What is a "Slide Transition" in a presentation? Name any two types of slide transitions. 2
Section 3 — Long Answer Questions (4 Marks each) — Q26 to Q30
Q26. Explain the steps involved in performing a Mail Merge operation in LibreOffice Writer to send personalised letters to multiple recipients. 4
Q27. Explain any four functions/formulas commonly used in LibreOffice Calc, along with their syntax and purpose. 4
Q28. What are the different types of relationships that can exist between tables in a relational database (one-to-one, one-to-many, many-to-many)? Explain each briefly with an example. 4
Q29. Describe the steps to create a new presentation with at least three slides in LibreOffice Impress, including adding text, images, and applying a design template. 4
Q30. What is "data validation" in a spreadsheet? Explain its importance with a suitable example (e.g., restricting entry to a specific range of values). 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 | (B) | 7 | (B) |
| 3 | (A) | 8 | (A) |
| 4 | (B) | 9 | (C) |
| 5 | (B) | 10 | (C) |
PART B — SUBJECT SPECIFIC SKILLS
Section 1 — Answer Key
| Q | Ans | Q | Ans |
|---|---|---|---|
| 11 | (B) .odt | 16 | (B) A1 |
| 12 | (B) AVERAGE() | 17 | (B) SELECT |
| 13 | (B) Primary key | 18 | (A) Slide Master |
| 14 | (B) Slide Sorter view | 19 | (B) $ |
| 15 | (A) Mail merge | 20 | (A) Rows and columns |
Section 2 — Key Answers
Q21. "Save" stores changes to the existing file under its current name and format/location; "Save As" allows the user to save the file with a new name, format, or location, creating a separate copy.
Q22. Go to Insert menu → Header and Footer → select Header (or Footer) → choose the required style/enable it for the document → type the required text in the header/footer area.
Q23. Sorting arranges data in a spreadsheet in a particular order (ascending or descending) based on the values in one or more columns; useful, for example, when arranging student marks from highest to lowest.
Q24. A Primary Key uniquely identifies each record within its own table and cannot contain duplicate/null values; a Foreign Key is a field in one table that refers to the Primary Key of another table, establishing a relationship between the two tables.
Q25. A Slide Transition is the visual effect that occurs when moving from one slide to the next during a presentation; examples include "Fade" and "Wipe" (or any two correctly named transition types).
Section 3 — Key Answers
Q26. Steps: (1) Create/open the main document (e.g., a letter). (2) Go to Tools → Mail Merge Wizard. (3) Select or create the data source (e.g., an address list). (4) Insert merge fields (like name, address) into the document at appropriate places. (5) Preview the merged documents. (6) Complete the merge to generate individual personalised copies, or print/send them directly.
Q27. Example functions: SUM() — adds a range of numeric values, e.g., =SUM(A1:A10); AVERAGE() — calculates the mean of a range, e.g., =AVERAGE(B1:B5); MAX()/MIN() — returns the largest/smallest value in a range; COUNT() — counts the number of cells containing numeric values in a range (any four correctly explained functions with syntax should be accepted).
Q28. One-to-One: each record in Table A relates to exactly one record in Table B (e.g., an employee and their unique ID card record); One-to-Many: one record in Table A relates to multiple records in Table B (e.g., one teacher teaching many students); Many-to-Many: multiple records in Table A relate to multiple records in Table B (e.g., students enrolled in multiple courses, and each course having multiple students).
Q29. Steps: (1) Open LibreOffice Impress and select a template/design theme. (2) Add a title slide with the topic name. (3) Insert a new slide (Slide → New Slide) and add text content using a text placeholder. (4) Insert an image via Insert → Image on another slide. (5) Add a third slide with additional content, and apply/verify the chosen design template is consistently applied across all slides. (6) Save the presentation.
Q30. Data validation restricts the type or range of data that can be entered into a specific spreadsheet cell, helping prevent incorrect data entry; for example, a cell can be set to only accept whole numbers between 1 and 100, so entering "150" or text would trigger an error/warning, ensuring data accuracy and consistency.
Page 3 of 3 (Answer Key) | www.careerinformationportal.in
