www.careerinformationportal.in
APNA CAREER PORTAL
www.careerinformationportal.in
CBSE Sample Practice Paper — 5 (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 formal communication in a workplace?
Q2. "Self-awareness" as a self-management skill means:
Q3. Which of the following is an example of an ICT device used for communication?
Q4. Market research before starting a business helps an entrepreneur to:
Q5. Which of the following represents a "carbon footprint" reduction practice?
Q6. Conflict resolution skills help in:
Q7. Which of these is an example of a "hard skill"?
Q8. Time management involves:
Q9. An "elevator pitch" is:
Q10. Cyber safety practices include:
PART B — SUBJECT SPECIFIC SKILLS (40 Marks)
Section 1 — Objective Type Questions (1 Mark each) — Q11 to Q20
Q11. Which feature in a word processor allows the automatic checking and correction of spelling errors?
Q12. In LibreOffice Calc, which function is used to find the smallest value in a range of cells?
Q13. Which of the following is a valid data type commonly used for storing numeric values in a database field?
Q14. Which of the following allows a presenter to display a presentation on one screen while viewing notes on another?
Q15. Which of the following is used to combine two or more cells into a single cell in a spreadsheet?
Q16. In a document, "Track Changes" is used to:
Q17. Which term describes the situation where the same data is unnecessarily stored multiple times in a database?
Q18. Which file format is native to LibreOffice Impress presentations?
Q19. What is the purpose of "Freeze Rows/Columns" in a spreadsheet?
Q20. Which of the following database objects is used to present data in a formatted, printable layout?
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 the "Spell Check" feature in a word processor? Explain briefly. 2
Q22. What is meant by "data normalization" in a database? Why is it important? 2
Q23. Explain the difference between a "Form" and a "Report" in a database application. 2
Q24. What is the use of the "Freeze Panes" feature in a spreadsheet? 2
Q25. What are "Speaker Notes" in a presentation, and why are they useful? 2
Section 3 — Long Answer Questions (4 Marks each) — Q26 to Q30
Q26. Explain the steps to protect a document with a password in LibreOffice Writer, and discuss why this feature is important. 4
Q27. Explain the concept of "filtering" data in a spreadsheet. Describe the steps to apply AutoFilter to a range of data. 4
Q28. What is meant by "normalization" in database design? Briefly explain the first three normal forms (1NF, 2NF, 3NF) with simple examples. 4
Q29. Explain the steps to insert and format a table (rows and columns) within a slide in LibreOffice Impress. 4
Q30. What are "templates" in office applications (word processor, spreadsheet, presentation)? Explain their advantages with an example. 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 | (B) |
| 4 | (B) | 9 | (B) |
| 5 | (A) | 10 | (B) |
PART B — SUBJECT SPECIFIC SKILLS
Section 1 — Answer Key
| Q | Ans | Q | Ans |
|---|---|---|---|
| 11 | (A) Spell Check | 16 | (B) Record edits for review |
| 12 | (B) MIN() | 17 | (B) Data redundancy |
| 13 | (B) Number/Integer | 18 | (A) .odp |
| 14 | (B) Presenter view | 19 | (B) Keep rows/columns visible |
| 15 | (B) Merge Cells | 20 | (C) Report |
Section 2 — Key Answers
Q21. Spell Check automatically scans the document text and identifies possible spelling errors, suggesting corrections, helping ensure the document is free of typing/spelling mistakes before finalising it.
Q22. Data normalization is the process of organising data in a database to reduce redundancy and improve data integrity, typically by dividing large tables into smaller, related tables; it is important because it prevents inconsistent/duplicate data and makes the database more efficient to maintain.
Q23. A Form provides a user-friendly interface for entering, viewing and editing data in a database (usually one record at a time); a Report is used to present and print selected data in a formatted, organised layout, often for summarising or sharing information, but is not typically used for direct data entry.
Q24. Freeze Panes keeps specific rows and/or columns (e.g., header rows) fixed and visible on screen while the user scrolls through the rest of a large spreadsheet, making it easier to reference column/row labels for distant data.
Q25. Speaker Notes are additional text notes attached to each slide, visible only to the presenter (not the audience), used to remind the presenter of key points, explanations, or reminders to mention while delivering that particular slide.
Section 3 — Key Answers
Q26. Steps: (1) Open the document in LibreOffice Writer. (2) Go to File → Save As (or File → Properties, depending on version) and look for security/password options, or use File → Save As and check "Save with password". (3) Enter and confirm the desired password. (4) Save the file. This feature is important as it restricts unauthorised access to sensitive or confidential documents, ensuring only people with the password can open/view the content.
Q27. Filtering allows the user to temporarily display only rows of data that meet specific criteria, hiding the rest, without permanently altering the data. Steps for AutoFilter: (1) Select the data range including headers. (2) Go to Data → AutoFilter. (3) Drop-down arrows appear on each header; click the arrow for the desired column. (4) Select the specific value(s) or condition to filter by, and the spreadsheet displays only matching rows.
Q28. Normalization organises data to minimise redundancy and dependency issues. 1NF: eliminates repeating groups, ensuring each field contains only atomic (single) values (e.g., splitting a "Subjects" field containing multiple subjects into separate rows). 2NF: builds on 1NF, ensuring all non-key fields depend on the entire primary key (relevant for composite keys). 3NF: builds on 2NF, ensuring non-key fields do not depend on other non-key fields (removing transitive dependencies), such as separating a "City" and "Pincode" that depend on each other into a related table.
Q29. Steps: (1) Select the slide where the table is needed. (2) Go to Insert → Table. (3) Specify the required number of rows and columns in the dialog box, and click Insert/OK. (4) Click into individual cells to type the required data. (5) Use the Table toolbar/properties to format the table — adjusting borders, cell colours, and column widths as needed.
Q30. Templates are pre-designed layouts (with formatting, structure and sometimes placeholder content) that can be used as a starting point for creating new documents, spreadsheets, or presentations; advantages include saving time, ensuring visual consistency, and providing a professional look without designing from scratch — for example, using a pre-made invoice template in a spreadsheet application instead of building one from an empty sheet each time.
Page 3 of 3 (Answer Key) | www.careerinformationportal.in
