www.careerinformationportal.in
APNA CAREER PORTAL
www.careerinformationportal.in
CBSE Sample Practice Paper — 2 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. This is a High-Level / HOTS practice edition — most questions are framed as short scenarios that require you to apply concepts, not just recall definitions.
4. All questions are compulsory. Marks for each question are indicated against it.
5. 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. During a job interview, a candidate maintains eye contact, sits upright, and nods while listening to the interviewer. This behaviour primarily demonstrates effective use of:
Q2. A student notes that she is confident at public speaking but struggles with managing her time, and also notices a growing demand for content creators in her city. In a SWOT analysis, "growing demand for content creators" would be classified as a:
Q3. Raj consistently completes his assignments a day before the deadline by planning each day using a to-do list. This behaviour best reflects which self-management skill?
Q4. A hospital stores patient records digitally, conducts remote consultations via video calls, and lets patients book appointments through a mobile app. This is best described as an application of:
Q5. Priya starts a small business making eco-friendly bags, investing her own savings along with a bank loan, fully aware that the venture might fail. This best illustrates which entrepreneurial trait?
Q6. A company installs solar panels and reduces paper usage across its offices to lower its environmental impact. This primarily reflects the use of:
Q7. During a group project, a team member listens to others' ideas, resolves disagreements calmly, and helps the team stay focused on the deadline. This behaviour is best described as demonstrating:
Q8. A canteen stops using plastic cutlery, reuses glass jars for storage, and sends leftover packaging for recycling. Together, these actions best reflect the practice of:
Q9. An entrepreneur whose first business fails due to poor planning studies her mistakes carefully and starts a second, better-planned venture instead of giving up. This best reflects which characteristic?
Q10. In a meeting, a speaker explains a plan clearly while the listener asks clarifying questions and paraphrases key points to confirm understanding. This exchange best demonstrates:
PART B — SUBJECT SPECIFIC SKILLS (40 Marks)
Section 1 — Objective Type Questions (1 Mark each) — Q11 to Q20
Q11. A user wants to send the same document to several people who use different word-processing applications, and wants it to remain freely editable by all of them. Which file format would best meet this requirement?
Q12. A teacher has the marks of 40 students in one column and wants a single value that best represents the "typical" score for comparison across sections. Which spreadsheet function is most appropriate here?
Q13. In a "Students" table, the field "Roll_No" is unique for every student and never repeats across records. Which type of key does this field best qualify as?
Q14. A presenter has 20 slides and needs to quickly rearrange the second half of the presentation without opening each slide individually. Which view would be most efficient for this task?
Q15. A school wants to send 500 personalised admit cards, each showing a different student's name, roll number and exam centre, using one common template. Which feature should be used?
Q16. Which of the following cell references would automatically adjust the row number but keep the column letter fixed when the formula is copied to a new column?
Q17. A librarian wants to retrieve the names of all books published after the year 2020 from a "Books" table. Which SQL command forms the base of this query?
Q18. A company wants every slide in its 30-slide presentation to automatically display the same logo, font and background, without manually formatting each slide individually. Which feature should be used?
Q19. A formula =$A$1+B1 is entered in cell C1 and then copied to cell C2. What happens to the reference to A1 in the copied formula?
Q20. A database table named "Orders" includes a field that stores the Customer ID of the customer who placed each order, referring back to the "Customers" table. This field in the "Orders" table is an example of a:
Page 1 of 3 | www.careerinformationportal.in
www.careerinformationportal.in
Section 2 — Short Answer Questions (2 Marks each) — Q21 to Q25
Q21. A user accidentally overwrites an important original file by clicking "Save" while intending to keep both the original and an edited copy. Explain how understanding the difference between "Save" and "Save As" could have prevented this data loss. 2
Q22. A student wants every page of her project report to display the project title at the top and the page number at the bottom, without having to type them manually on each page. Explain how she can achieve this in a Digital Documentation application. 2
Q23. A teacher has a spreadsheet listing 60 students with their marks across five subjects and wants to quickly identify the top 10 overall performers. Explain how sorting can help her achieve this, and briefly describe the steps involved. 2
Q24. A school database has a "Students" table and a separate "Fees" table. Using the concept of primary and foreign keys, explain how these two tables can be linked to find the fee status of a particular student. 2
Q25. A presenter wants consecutive slides in a product-launch presentation to flow smoothly into one another to keep the audience engaged, rather than switching abruptly. Explain how slide transitions can help achieve this, and name any two suitable transition types. 2
Section 3 — Long Answer Questions (4 Marks each) — Q26 to Q30
Q26. A small business owner wants to send personalised invoices to 200 customers, each containing the customer's name, address and outstanding amount, using a single common invoice template. Explain, with the required steps, how Mail Merge can be used to accomplish this task efficiently. 4
Q27. A shopkeeper maintains a spreadsheet of daily sales for a month and wants to: (a) calculate the total monthly sales, (b) find the highest single-day sale, (c) count the number of days on which sales exceeded ₹5000, and (d) calculate the average daily sale. Identify and explain the appropriate function for each requirement, along with its correct syntax. 4
Q28. A college wants to design a database to manage student enrolment in multiple courses, where each student can enrol in several courses, and each course can have many students enrolled. Explain which type of table relationship (one-to-one, one-to-many, many-to-many) is most suitable here, and describe how it would typically be implemented using an additional linking table. 4
Q29. A student has been asked to create a 5-slide presentation on "Water Conservation" for a school competition, ensuring visual consistency, engaging content, and a logical flow. Describe the steps she should follow in a presentation application, from creating the presentation to finalising the design and content of each slide. 4
Q30. An online form requires users to enter their age, and the system must ensure that no one can enter an age below 18 or above 60. Explain the concept of data validation in a spreadsheet, and describe how this specific restriction could be implemented, including what should happen if a user enters an invalid value. 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 | (C) | 7 | (B) |
| 3 | (B) | 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) .odt | 16 | (C) A$1 |
| 12 | (B) AVERAGE() | 17 | (B) SELECT |
| 13 | (B) Primary key | 18 | (A) Slide Master |
| 14 | (B) Slide Sorter view | 19 | (B) Remains fixed as $A$1 |
| 15 | (B) Mail merge | 20 | (B) Foreign key |
Section 2 — Key Answers
Q21. "Save" overwrites the currently open file under its existing name, while "Save As" creates a new file with a different name/location, keeping the original intact; had the user chosen "Save As" before editing, the original file would have remained unaffected as a separate, unedited copy.
Q22. She can use the Header and Footer feature (Insert → Header and Footer) to add the title once in the header and the page number field once in the footer; once set, these will automatically repeat on every page of the document without manual retyping.
Q23. Sorting arranges the rows of a spreadsheet in ascending or descending order based on chosen column(s) — here, sorting the "total marks" or "overall percentage" column in descending order instantly brings the highest-scoring students to the top; steps: select the data range → Data menu → Sort → choose the relevant column and order (descending).
Q24. The "Students" table would have "Student_ID" as its Primary Key; the "Fees" table would include "Student_ID" as a Foreign Key referring back to the Students table. By matching this common field, the two tables can be linked (joined) to look up the fee record corresponding to any specific student.
Q25. Slide transitions are animated visual effects that occur when moving from one slide to the next; using consistent, smooth transitions (such as "Fade" or "Wipe") helps the presentation feel continuous and professional rather than jarring, keeping the audience's attention through the changeover.
Section 3 — Key Answers
Q26. Steps: (1) Create the common invoice template as the main document. (2) Prepare/select a data source containing each customer's name, address and outstanding amount. (3) Open the Mail Merge Wizard and link the data source to the document. (4) Insert merge fields (Name, Address, Amount) into the invoice template at the correct places. (5) Preview a few merged invoices to check accuracy. (6) Complete the merge to generate all 200 personalised invoices at once, ready for printing or emailing.
Q27. (a) Total monthly sales — SUM(): e.g., =SUM(B2:B31), adds all daily sales values in the range. (b) Highest single-day sale — MAX(): e.g., =MAX(B2:B31), returns the largest value in the range. (c) Days with sales exceeding ₹5000 — COUNTIF(): e.g., =COUNTIF(B2:B31,">5000"), counts cells meeting the given condition. (d) Average daily sale — AVERAGE(): e.g., =AVERAGE(B2:B31), calculates the mean of the range.
Q28. Since one student can enrol in many courses, and one course can have many students, this is a Many-to-Many relationship. It is typically implemented using a third "linking" (junction) table — e.g., "Enrolment" — containing the Student_ID and Course_ID as foreign keys referring to the Students and Courses tables respectively, with each row representing one student's enrolment in one course.
Q29. Steps: (1) Open the presentation application and choose a suitable design template/theme for consistency. (2) Create a title slide with the topic "Water Conservation" and the student's name. (3) Add a new slide explaining the importance/need for water conservation, using bullet points. (4) Add a slide with images/graphics illustrating water-saving methods. (5) Add slides covering statistics or facts, and a concluding slide summarising key takeaways, ensuring the same theme/design is applied throughout. (6) Review all slides for consistent formatting, spelling and flow, then save the presentation.
Q30. Data validation restricts the type or range of values that can be entered into a spreadsheet cell, helping maintain data accuracy; here, a validation rule can be set on the "Age" cell/column specifying a whole number between 18 and 60 (Data → Validity → Whole Number → between 18 and 60). If a user tries to enter a value outside this range (e.g., 15 or 65), the spreadsheet should display an error/warning message and reject the invalid entry, prompting the user to enter a valid age.
Page 3 of 3 (Answer Key) | www.careerinformationportal.in
