SEBA Class 9 Computer Science Chapter 3 Question Bank | Office Applications (MS Word, Excel & PowerPoint)

Computer Guide Team
June 28, 2026
Class IX Chapter 3 Office Application Question Bank
📑 Quick Navigation
⭐ Very Short 📝 Short 📚 Long 🎤 Viva ✍ Fill in the Blanks ✅ True / False 🎯 Important Questions ⚡ Revision
⭐ Very Short Answer Questions
Q1. What is MS Word?
Answer: MS Word is a word processing software developed by Microsoft used to create, edit, format and print documents.
Q2. What is formatted text?
Answer: Formatted text is text whose appearance has been changed using options like bold, italic, underline, font size, colour or alignment.
Q3. What is Mail Merge?
Answer: Mail Merge is a feature of MS Word used to create multiple personalized documents by combining a main document with a data source.
Q4. What is a Data Source?
Answer: A data source is a file or location that stores names, addresses or other information used in Mail Merge.
Q5. What are Table Styles?
Answer: Table Styles are ready-made formatting designs used to make tables attractive.
Q6. Name the four text alignments available in MS Word.
Answer:
  • Left
  • Center
  • Right
  • Justify
Q7. What is a Workbook?
Answer: A workbook is an Excel file that contains one or more worksheets.
Q8. What is a Worksheet?
Answer: A worksheet is a spreadsheet page inside a workbook where data is entered and processed.
Q9. What is an Active Cell?
Answer: The active cell is the currently selected cell in Excel where data can be entered.
Q10. What is a Formula in Excel?
Answer: A formula is an expression beginning with "=" that performs calculations in Excel.
Q11. What is Cell Referencing?
Answer: Cell referencing means referring to a cell address in a worksheet while writing formulas.
Q12. Name the three types of Cell Referencing.
Answer:
  • Relative Referencing
  • Absolute Referencing
  • Mixed Referencing
Q13. What is a Presentation?
Answer: A presentation is a collection of slides arranged to present information to an audience.
Q14. What is a Slide?
Answer: A slide is a single page of a PowerPoint presentation.
Q15. What is Animation?
Answer: Animation is a visual effect applied to text or objects to make them move during a presentation.
Q16. What is Slide Transition?
Answer: Slide Transition is the visual effect shown when moving from one slide to another.
Q17. What is Normal View in PowerPoint?
Answer: Normal View is the default editing view used to create and modify slides.
Q18. What is Slide Sorter View?
Answer: Slide Sorter View displays all slides together as thumbnails for easy arrangement.
📝 Short Answer Questions
Q19. What is Word Processing? Mention any four features of MS Word.
Answer:

Word Processing is the process of creating, editing, formatting, saving and printing documents using a computer. Features of MS Word:
  • Text Formatting
  • Spell & Grammar Check
  • Mail Merge
  • Table Creation
Q20. What is Mail Merge? Mention its advantages.
Answer:

Mail Merge is a feature of MS Word used to create multiple personalized documents such as letters, certificates and invitations by combining a main document with a data source. Advantages:
  • Saves time.
  • Creates multiple documents automatically.
  • Reduces typing errors.
  • Useful for letters, certificates and notices.
Q21. What is a Workbook? Differentiate between Workbook and Worksheet.
Answer:
Workbook Worksheet
A workbook is an Excel file. A worksheet is a single spreadsheet inside the workbook.
Contains one or more worksheets. Contains rows and columns.
Q22. Explain Cell Referencing.
Answer:

Cell Referencing means referring to the address of a cell while writing formulas. Types:
  • Relative Reference
  • Absolute Reference
  • Mixed Reference
Q23. What is Formula? Write any four Arithmetic Operators used in Excel.
Answer: A Formula is an expression beginning with "=" used to perform calculations. Arithmetic Operators:
  • +
  • -
  • *
  • /
Q24. Explain Relative, Absolute and Mixed Referencing.
Answer:
  • Relative Reference: Changes automatically when copied.
  • Absolute Reference: Remains fixed using the "$" symbol.
  • Mixed Reference: One part remains fixed while the other changes.
Q25. What is a Presentation? Mention the advantages of MS PowerPoint.
Answer: A Presentation is a collection of slides used to present information. Advantages:
  • Easy to present information.
  • Supports images, videos and charts.
  • Makes learning interesting.
  • Easy to edit and update.
Q26. What is the difference between Slide Transition and Animation?
Slide Transition Animation
Applied to the entire slide. Applied to objects inside a slide.
Occurs when changing slides. Occurs while objects appear or move.
Q27. Explain the different views of PowerPoint.
Answer:
  • Normal View
  • Outline View
  • Slide Sorter View
  • Reading View
  • Slide Show View
Q28. What is the use of Slide Master?
Answer: Slide Master allows the user to apply the same design, font, colour and layout to all slides in a presentation at once.
📚 Long Answer Questions
Q29. Explain the steps to create and save a document in MS Word.
Answer:
  1. Open MS Word.
  2. Select Blank Document.
  3. Type the required text.
  4. Click File → Save.
  5. Choose the folder.
  6. Enter the file name.
  7. Click Save.
Q30. Explain the Mail Merge process.
Answer: The steps are:
  1. Create the Main Document.
  2. Create the Data Source.
  3. Insert Merge Fields.
  4. Preview the merged document.
  5. Complete the Merge.
  6. Print or Save the documents.
Q31. Explain the components of an Excel worksheet.
Answer: An Excel worksheet consists of:
  • Rows
  • Columns
  • Cells
  • Cell Address
  • Name Box
  • Formula Bar
  • Worksheet Tabs
Q32. Explain Cell Referencing with suitable examples.
Answer:
Reference Type Example
Relative A1
Absolute $A$1
Mixed $A1 or A$1
Relative references change automatically, Absolute references remain fixed, while Mixed references keep either the row or column fixed.
Q33. Explain the different views in MS PowerPoint.
Answer: PowerPoint provides different views to help create and present slides:
  • Normal View: Used for creating and editing slides.
  • Outline View: Displays only slide text.
  • Slide Sorter View: Shows all slides together.
  • Reading View: Displays the presentation in a window.
  • Slide Show View: Used for presenting slides to the audience.
Q34. Explain the importance of MS Word, MS Excel and MS PowerPoint.
Answer:
Application Use
MS Word Create and edit documents.
MS Excel Perform calculations and data analysis.
MS PowerPoint Create presentations using slides.
These Office applications are widely used in schools, offices, businesses and organizations for documentation, calculations and presentations.
🎤 Viva Questions
Q35. What is MS Word?
Answer: MS Word is a word processing software developed by Microsoft.
Q36. What is the use of MS Word?
Answer: It is used to create, edit, format and print documents.
Q37. What is Mail Merge?
Answer: Mail Merge is a feature used to create multiple personalized documents.
Q38. What is a Data Source?
Answer: A data source contains records such as names and addresses used in Mail Merge.
Q39. What is MS Excel?
Answer: MS Excel is a spreadsheet software used for calculations and data analysis.
Q40. What is a Workbook?
Answer: A workbook is an Excel file containing one or more worksheets.
Q41. What is a Worksheet?
Answer: A worksheet is a spreadsheet consisting of rows and columns.
Q42. What is a Cell?
Answer: A cell is the intersection of a row and a column.
Q43. What is Cell Referencing?
Answer: Cell referencing means referring to the address of a cell in a formula.
Q44. Name the three types of Cell Referencing.
Answer: Relative, Absolute and Mixed Referencing.
Q45. What is a Formula?
Answer: A formula is an expression used to perform calculations in Excel.
Q46. What is MS PowerPoint?
Answer: MS PowerPoint is presentation software used to create slide presentations.
Q47. What is a Presentation?
Answer: A presentation is a collection of slides.
Q48. What is a Slide?
Answer: A slide is a single page of a presentation.
Q49. What is Animation?
Answer: Animation is an effect applied to text or objects on a slide.
Q50. What is Slide Transition?
Answer: A Slide Transition is the effect shown when moving from one slide to another.
Q51. What is Slide Show View?
Answer: It displays the presentation in full-screen mode.
Q52. What is Slide Sorter View?
Answer: It displays all slides as thumbnails for easy arrangement.
Q53. What is Normal View?
Answer: It is the default editing view in PowerPoint.
Q54. What is Slide Master?
Answer: Slide Master is used to apply the same design to all slides.
✍ Fill in the Blanks
1. __________ is a word processing software.
Answer: MS Word
2. Mail Merge combines a main document with a __________.
Answer: Data Source
3. MS Excel is a __________ software.
Answer: Spreadsheet
4. A workbook contains one or more __________.
Answer: Worksheets
5. The intersection of a row and a column is called a __________.
Answer: Cell
6. Every Excel formula begins with __________.
Answer: = (Equal Sign)
7. __________ referencing uses the $ symbol.
Answer: Absolute
8. Relative, Absolute and Mixed are types of __________.
Answer: Cell Referencing
9. MS PowerPoint is used to create __________.
Answer: Presentations
10. A presentation consists of many __________.
Answer: Slides
11. Animation is applied to __________ on a slide.
Answer: Objects
12. Transition is applied between __________.
Answer: Slides
13. The default PowerPoint editing mode is __________ View.
Answer: Normal
14. Slide Master provides a common __________ for all slides.
Answer: Design
15. Excel data is arranged in __________ and columns.
Answer: Rows
16. Mail Merge saves __________.
Answer: Time
17. Excel formulas perform __________.
Answer: Calculations
18. PowerPoint presentations are mainly used for __________.
Answer: Presenting Information
19. MS Word is part of Microsoft __________.
Answer: Office
20. A slide contains text, pictures and __________.
Answer: Objects
✅ True / False
1. MS Word is spreadsheet software.
Answer: False
2. Mail Merge is used to prepare personalized letters.
Answer: True
3. A workbook contains worksheets.
Answer: True
4. Excel formulas always begin with =.
Answer: True
5. Cell A1 is an example of Relative Reference.
Answer: True
6. $A$1 is an Absolute Reference.
Answer: True
7. PowerPoint is used to create presentations.
Answer: True
8. A presentation contains slides.
Answer: True
9. Animation and Transition are the same.
Answer: False
10. Slide Transition is applied between slides.
Answer: True
11. Slide Master helps maintain uniform formatting.
Answer: True
12. Excel cannot perform calculations.
Answer: False
13. Mail Merge reduces repetitive typing.
Answer: True
14. A worksheet is larger than a workbook.
Answer: False
15. Animation is applied to text and objects.
Answer: True
16. Slide Show View is used during presentation.
Answer: True
17. MS Word is useful for preparing reports.
Answer: True
18. Excel stores data in rows and columns.
Answer: True
19. PowerPoint cannot insert pictures.
Answer: False
20. MS Office includes Word, Excel and PowerPoint.
Answer: True
🎯 Most Important Exam Questions
Q55. Explain the features of MS Word.
Q56. Explain the steps involved in Mail Merge.
Q57. Differentiate between Workbook and Worksheet.
Q58. Explain Relative, Absolute and Mixed Cell Referencing with examples.
Q59. Explain Formula and Functions in MS Excel with suitable examples.
Q60. Explain the components of an Excel Worksheet.
Q61. Explain the different views available in MS PowerPoint.
Q62. Differentiate between Slide Transition and Animation.
Q63. Explain the uses of Slide Master.
Q64. Explain the advantages of MS Office Applications.
Q65. Explain the uses of MS Word, MS Excel and MS PowerPoint.
Q66. Explain how to create a presentation in MS PowerPoint.
Q67. Explain the different types of Cell Referencing with examples.
Q68. Explain Mail Merge with suitable applications.
Q69. Explain Formula Bar, Name Box and Active Cell in Excel.
⚡ Last Minute Revision Questions
1. What is MS Word?
2. What is Word Processing?
3. What is Mail Merge?
4. What is a Data Source?
5. What are Table Styles?
6. Name the four text alignments in MS Word.
7. What is MS Excel?
8. What is a Workbook?
9. What is a Worksheet?
10. What is an Active Cell?
11. What is Cell Referencing?
12. Name the three types of Cell Referencing.
13. What is a Formula?
14. Name four Arithmetic Operators in Excel.
15. What is MS PowerPoint?
16. What is a Presentation?
17. What is a Slide?
18. What is Animation?
19. What is Slide Transition?
20. What is Slide Master?
21. Name the different views of PowerPoint.
22. Differentiate between Animation and Transition.
23. What is Normal View?
24. What is Slide Sorter View?
25. Which Office application is used for documents, spreadsheets and presentations?

🔥 Exam Focus Topics

  • Features of MS Word
  • Word Processing
  • Mail Merge
  • Data Source
  • Table Styles
  • Workbook and Worksheet
  • Rows, Columns and Cells
  • Formula and Functions
  • Cell Referencing
  • Relative, Absolute and Mixed References
  • Presentation and Slides
  • Animation
  • Slide Transition
  • Slide Master
  • Views of PowerPoint
  • Uses of MS Word, Excel and PowerPoint

🏆 Exam Success Tips

  • Memorize all important definitions from MS Word, Excel and PowerPoint.
  • Practice writing formulas and cell references in MS Excel.
  • Understand the difference between Workbook and Worksheet.
  • Learn the steps of Mail Merge thoroughly.
  • Practice the different views available in PowerPoint.
  • Revise all Viva Questions before the examination.
  • Solve Fill in the Blanks and True/False regularly.
  • Revise the Last Minute Questions one day before the exam.

🌟 Exam Hot Questions

  1. Explain the features of MS Word.
  2. Explain Mail Merge with suitable examples.
  3. Differentiate between Workbook and Worksheet.
  4. Explain Relative, Absolute and Mixed Referencing.
  5. Explain Formula and Functions in Excel.
  6. Explain the components of an Excel Worksheet.
  7. Explain the different views of PowerPoint.
  8. Differentiate between Slide Transition and Animation.
  9. Explain Slide Master.
  10. Write the advantages of MS Office applications.