SECTION A: MULTIPLE CHOICE QUESTIONS (MCQs)

1. Question: In Word, which shortcut key is used to underline text?

   Example: Underlining important headings in a report.

   Answer: Ctrl + U
2. Question: In Excel, which function calculates the smallest number in a range?

   Example: Finding the lowest exam score in a class.

   Answer: =MIN()
3. Question: Which of the following is used to create relationships between tables in Access?

   Example: Linking student ID in the student table with marks in the results table.

   Answer: Relationships tool
4. Question: In PowerPoint, which feature allows you to animate text or objects?

   Example: Making a school logo fade in during a presentation.

   Answer: Animations tab
5. Question: In Word, the area showing the number of pages and word count is called:

   Example: Checking word count before submitting an essay.

   Answer: Status Bar
6. Question: In Excel, what does the formula =IF(A1>50,"Pass","Fail") do?

   Example: Determining if a student passes a subject.

   Answer: Checks a condition and returns "Pass" or "Fail"
7. Question: In Access, a form is mainly used for:

   Example: Entering student data easily instead of typing in the table directly.

   Answer: Data entry
8. Question: In PowerPoint, which view shows how slides will look in a presentation?

   Example: Reviewing the presentation before showing it to teachers.

   Answer: Slide Show view
9. Question: Which Excel feature is used to quickly fill a series of numbers or dates?

   Example: Auto-filling days of the week for a schedule.

   Answer: Fill Handle
10. Question: In Word, what is the purpose of the "Track Changes" feature?

    Example: Teachers editing students’ essays while showing all modifications.

    Answer: To record and review changes made to a document

SECTION B: MATCHING ITEMS

Match items in List A with List B:

Example: Conditional formatting can highlight students with marks below 50 automatically.

SECTION C: FILL IN THE BLANKS

1. The shortcut key to cut text in Word is Ctrl + X.
2. Excel feature that highlights cells based on rules is called Conditional Formatting.
3. The tab used to insert charts in Excel is Insert.
4. In PowerPoint, the view used to edit master slides is Slide Master.
5. In Access, a report is mainly used for printing or summarizing data.
6. In Word, repeating text or page numbers at the top is done using Header.
7. Excel formula to calculate total marks in cells B1 to B10 is =SUM(B1:B10).
8. PowerPoint feature to apply movement between slides is Slide Transition.
9. Access object used to search or retrieve specific data is called Query.
10. Undo last action in Word or Excel is done by Ctrl + Z.

SECTION D: DIAGRAMS

Question 1: Draw a labeled Excel window showing Ribbon, Formula Bar, Name Box, Worksheet, Columns, and Rows.

Example: Teachers use Excel to organize marks; these elements are always visible.

Question 2: Draw a PowerPoint slide layout showing Title, Content area, and placeholders for images.

Example: Preparing a class presentation with text and pictures.

SECTION E: FORMULAS

1. Calculate the average of scores in cells C1 to C5: =AVERAGE(C1:C5)
2. Find the highest mark in D1:D10: =MAX(D1:D10)
3. Check if a student passed (>50) using cell E2: =IF(E2>50,"Pass","Fail")
4. Multiply attendance in cell F2 by 100: =F2*100
5. Count how many cells in G1:G20 contain numbers: =COUNT(G1:G20)

Example: Teachers use these formulas daily for calculating marks and attendance.

SECTION F: SCENARIO

Scenario: A school administrator wants to track students' assignments using Excel, generate reports with Access, create a presentation in PowerPoint, and write letters in Word.

1. Which application is best for calculating marks? Excel
2. Which application is best for generating official reports? Access
3. Which application is used to present the results to teachers? PowerPoint
4. Which application is used to write official letters? Word
5. Explain why using all four applications together is important: It ensures efficient data management, analysis, reporting, presentation, and documentation in an organized way.

Example: The school can quickly calculate marks, print reports, show presentations to staff, and write letters without switching systems.