SECTION A: MULTIPLE CHOICE QUESTIONS (MCQs)

1. Question: In Word, which feature is used to create a table of contents automatically?

   Example: Preparing a report with multiple chapters and headings.

   Answer: References tab → Table of Contents
2. Question: Which Excel function calculates the middle value in a set of numbers?

   Example: Finding the median score of students in a test.

   Answer: =MEDIAN()
3. Question: In Access, which object is used to display data in a printable format?

   Example: Printing student results for the school office.

   Answer: Report
4. Question: In PowerPoint, which feature allows you to combine multiple images into one slide layout?

   Example: Showing photos of a school event on a single slide.

   Answer: Insert → SmartArt or Group objects
5. Question: In Word, which feature checks for repeated words, grammar errors, and spelling mistakes?

   Example: Checking a final essay before submission.

   Answer: Review → Spelling & Grammar
6. Question: Excel feature used to automatically fill data based on a pattern is called:

   Example: Filling days of the week or months automatically.

   Answer: AutoFill / Fill Handle
7. Question: In Access, a query can be used to:

   Example: Find all students with marks above 80 and in Form 3.

   Answer: Extract specific data
8. Question: PowerPoint feature that allows text to appear letter by letter is:

   Example: Making titles appear gradually for better effect.

   Answer: Animations → Entrance effect → By Letter
9. Question: In Word, what is the purpose of using Styles?

   Example: Consistent headings, subheadings, and formatting in a report.

   Answer: To apply consistent formatting easily
10. Question: Excel feature to analyze trends and patterns in large datasets is:

    Example: Visualizing sales trends over months using charts.

    Answer: PivotTable / Charts

SECTION B: MATCHING ITEMS

Match items in List A with their correct answers in List B:

Example: Data Validation prevents a student from entering negative marks.

SECTION C: FILL IN THE BLANKS

1. In Word, the feature to combine letters with a list of names is Mail Merge.
2. Excel function to calculate the total of cells B1 to B10 is =SUM(B1:B10).
3. In Access, to prevent duplicate IDs, use Primary Key.
4. PowerPoint feature to see all slides in thumbnail view is Slide Sorter.
5. Excel feature to prevent invalid data entry is Data Validation.
6. Word feature to track document edits is Track Changes.
7. Excel function to calculate average of cells C1:C10 is =AVERAGE(C1:C10).
8. PowerPoint feature to rehearse slide timings is Rehearse Timing.
9. Word tool to check spelling and grammar is Spelling & Grammar.
10. Excel tool to highlight specific cells based on conditions is Conditional Formatting.

SECTION D: DIAGRAMS

Question 1: Draw a labeled Word window showing Ribbon, Document Area, Status Bar, Scroll Bar, and Title Bar.

Example: These are the main areas used when writing letters or reports.

Question 2: Draw a PivotTable in Excel with labels for Rows, Columns, Values, and Filters.

Example: Summarizing student marks by class and subject quickly.

SECTION E: FORMULAS

1. Find the lowest mark in range D1:D10: =MIN(D1:D10)
2. Calculate total sales in B1:B12: =SUM(B1:B12)
3. Check if cell E2 > 50: =IF(E2>50,"Pass","Fail")
4. Multiply quantity in A2 by price in B2: =A2*B2
5. Count numeric entries in C1:C20: =COUNT(C1:C20)

Example: Teachers calculate totals, averages, and evaluate student performance using these formulas.

SECTION F: SCENARIO

Scenario: A teacher wants to record student marks in Excel, create reports in Access, show results in PowerPoint, and write recommendations in Word.

1. Which application is best for calculations? Excel
2. Which application is best for storing detailed student data? Access
3. Which application is used for visual presentation? PowerPoint
4. Which application is used to write recommendations? Word
5. Explain why using all four applications together is important: It allows accurate data management, calculation, presentation, and documentation, saving time and reducing errors.

Example: The teacher can process marks, generate reports, present results to staff, and write recommendations without errors or repeated work.