Microsoft Office Examination (Word, Excel &
PowerPoint)
Time: 1 Hour 30 Minutes Maximum Marks: 70
Instructions:
1. Attempt all questions.
2. Use appropriate MS Office terminology.
3. Practical work should be saved with your name.
Section A: Multiple Choice Questions (10 × 1 = 10 Marks)
1. Which software is primarily used for creating documents? (a) MS Excel (b) MS Word (c) PowerPoint (d)
Access
2. Which tab in MS Word is used to insert pictures and shapes? (a) Home (b) Insert (c) Review (d) Layout
3. The shortcut Ctrl + B in MS Word is used for __________. (a) Bold (b) Bookmark (c) Break (d)
Background
4. Which Excel feature automatically calculates totals? (a) AutoSum (b) AutoFill (c) Sort (d) Filter
5. Which formula is used to add numbers in Excel? (a) =ADD() (b) =SUM() (c) =TOTAL() (d) =PLUS()
6. Which symbol is used to start a formula in Excel? (a) # (b) @ (c) = (d) $
7. PowerPoint is mainly used for __________. (a) Data analysis (b) Presentations (c) Database
management (d) Programming
8. Which view is commonly used while presenting slides? (a) Normal View (b) Slide Sorter (c) Reading
View (d) Slide Show
9. Which option allows you to apply a consistent design to all slides? (a) Layout (b) Theme (c) Animation
(d) Transition
10. Which shortcut starts a slideshow from the beginning? (a) F1 (b) F5 (c) F7 (d) F9
Section B: Fill in the Blanks (10 × 1 = 10 Marks)
1. MS Word files are commonly saved with the extension __________.
2. __________ feature in Word automatically checks spelling errors.
3. In Excel, a rectangular group of cells is called a __________.
4. The intersection of a row and column in Excel is called a __________.
5. __________ is used to organize data in ascending or descending order.
6. A visual representation of data in Excel is called a __________.
7. PowerPoint presentations consist of multiple __________.
8. __________ tab in PowerPoint is used to add animations.
9. Ctrl + S is the shortcut for __________ a file.
10. MS Office is a collection of __________ software.
Section C: Short Answer Questions (5 × 4 = 20 Marks)
1. Explain the main features of MS Word.
2. What is the difference between a workbook and a worksheet in Excel?
3. Explain the use of formulas and functions in Excel.
4. What are slide transitions and animations in PowerPoint?
5. Explain the importance of formatting in MS Office documents.
Section D: Practical Tasks (30 Marks)
1. MS Word Task: Create a one-page formatted document about 'Importance of Computer Education'.
Include heading, paragraph formatting, bullet points, and insert one image.
2. MS Excel Task: Create a small student marks sheet with at least 5 students and 3 subjects. Use SUM
formula to calculate total marks and create a bar chart.
3. MS PowerPoint Task: Create a 5-slide presentation about 'Digital Marketing Basics'. Include a title slide,
images, bullet points, one transition, and one animation.