SECTION A: MULTIPLE CHOICE QUESTIONS

1. In MS Word, which shortcut key is used to make text bold? Answer: A. Ctrl + B
2. Which of the following is not a data type in MS Access? Answer: D. Graphics
3. In Excel, the intersection of a row and a column is called: Answer: B. Cell
4. PowerPoint is mainly used for: Answer: B. Presentations
5. The default file extension of MS Word document (2016 and above) is: Answer: C. .docx
6. In MS Access, a primary key is used to: Answer: B. Identify records uniquely
7. In Excel, the function =SUM(A1:A5) will: Answer: B. Add all values in A1 to A5
8. Which tab in PowerPoint is used to insert pictures or shapes? Answer: B. Insert
9. Which of the following is not a view in MS Word? Answer: C. Design View
10. In MS Access, queries are used to: Answer: C. Retrieve specific information

SECTION B: MATCHING ITEMS

Match items from List A with List B:

SECTION C: FILL IN THE BLANKS

1. The shortcut key for copying text in Word is Ctrl + C.
2. In Excel, charts are created to display data in graphical form.
3. The backstage view in MS Word is opened by clicking the File tab.
4. The default view in PowerPoint is Normal view.
5. In Access, a database is made up of one or more tables.
6. The area where you type your text in MS Word is called the document area.
7. In Excel, a formula always starts with the equal (=) sign.
8. The process of arranging data in ascending or descending order is called sorting.
9. The PowerPoint shortcut to start a slide show from the beginning is F5.
10. In Access, to prevent duplicate data, you can use a primary key.

SECTION D: DIAGRAMS

Question 1: Draw a labeled diagram of Microsoft Word window showing at least five parts: Title Bar, Ribbon, Status Bar, Document Area, Scroll Bar.

Question 2: Draw a labeled Excel worksheet showing columns, rows, cell address, and formula bar.

SECTION E: FORMULAS

1. Average of cells A1 to A5: =AVERAGE(A1:A5)
2. Sum of B1, B2, B3: =B1+B2+B3
3. Maximum value in C1:C10: =MAX(C1:C10)
4. Count numeric cells in D1:D20: =COUNT(D1:D20)
5. Multiply value in A2 by 10: =A2*10

SECTION F: SCENARIO

Scenario: A school secretary uses Microsoft Access to record student information such as Student ID, Name, Class, and Marks. She later uses Excel to calculate the average marks and PowerPoint to present the results to teachers. Finally, she writes a report in Word to summarize student performance.

1. Which application is best for data storage? MS Access
2. Which application is used for data analysis and calculations? Excel
3. Which application helps to present the findings visually? PowerPoint
4. Which application can be used to write the final report? Word
5. Explain why using these applications together is important in an office: They allow efficient data storage, analysis, presentation, and reporting, saving time and reducing errors.