Comprehensive Q&A: MS Word,
PowerPoint, Excel, Git/GitHub, and OOP
🔵 MS Word
Q: What is MS Word used for?
A: MS Word is a word processing software used to create, edit, format, and print text
documents.
Q: How can you insert a table in Word?
A: Go to Insert > Table, then choose the number of rows and columns.
Q: How do you add a header or footer?
A: Go to Insert > Header or Footer, then select the desired style.
Q: What is the use of Mail Merge?
A: Mail Merge allows you to create personalized letters or emails for multiple recipients
using one template and a data source.
Q: How can you add page numbers?
A: Go to Insert > Page Number and choose the position.
Q: How do you check spelling and grammar?
A: Use Review > Spelling & Grammar or press F7.
Q: What is Track Changes?
A: A feature to track edits made in the document for review and collaboration.
Q: How do you protect a Word document?
A: Go to File > Info > Protect Document.
🟣 MS PowerPoint
Q: What is MS PowerPoint used for?
A: MS PowerPoint is used to create presentations using slides containing text, images,
videos, and animations.
Q: How do you insert a new slide?
A: Go to Home > New Slide or press Ctrl + M.
Q: How do you apply a transition to a slide?
A: Select the slide, then go to Transitions tab and choose a transition.
Q: What is the difference between transition and animation?
A: Transition is the effect between slides. Animation is the effect on slide content.
Q: How do you start a slideshow?
A: Press F5 or go to Slide Show > From Beginning.
Q: How to insert audio/video in a slide?
A: Go to Insert > Audio or Video and choose the file.
Q: How to add speaker notes?
A: Click on 'Notes' below the slide and type your notes.
Q: How can you print a presentation?
A: File > Print > Select layout (e.g., slides, handouts).
🟢 MS Excel (IF/ELSE and Functions)
Q: What is MS Excel used for?
A: MS Excel is used for data entry, analysis, calculations, and creating charts using
spreadsheets.
Q: What is the IF function?
A: =IF(condition, value_if_true, value_if_false)
Q: Can we use multiple IF conditions?
A: Yes, it's called nested IF. Example: =IF(A1>90, "A", IF(A1>80, "B", "C"))
Q: What is the IFS function?
A: =IFS(condition1, value1, condition2, value2, ...)
Q: What is the use of VLOOKUP?
A: Used to find a value in a table. Example: =VLOOKUP(101, A2:B10, 2, FALSE)
Q: What is CONCATENATE?
A: Combines values from multiple cells. Example: =CONCATENATE(A1, B1)
Q: How to create a chart in Excel?
A: Select data > Insert > Choose chart type.
Q: What is conditional formatting?
A: It highlights cells that meet certain conditions using color formatting.
⚫ Git & GitHub
Q: What is Git?
A: Git is a version control system that tracks changes in code or files.
Q: What is GitHub?
A: GitHub is a cloud-based platform to store and manage Git repositories.
Q: What is the difference between Git and GitHub?
A: Git is local version control; GitHub is an online hosting service.
Q: What is a commit?
A: A commit is a saved version of your project changes with a message.
Q: What is 'git push'?
A: Uploads local repository content to a remote repository.
Q: What is 'git pull'?
A: Fetches and merges changes from remote to local repository.
Q: What is the purpose of 'git clone'?
A: To download an existing Git repository from GitHub.
Q: What is a branch in Git?
A: A branch lets you work on different versions of a repository independently.
🟠 Object-Oriented Programming (OOP)
Q: What is OOP?
A: OOP is a programming model based on objects that combine data and behavior.
Q: What are the 4 pillars of OOP?
A: Encapsulation, Abstraction, Inheritance, Polymorphism.
Q: What is Encapsulation?
A: Encapsulation hides internal object details and shows only necessary information.
Q: What is Inheritance?
A: A class can inherit properties and methods from another class.
Q: What is Polymorphism?
A: The same function can perform different behaviors based on context.
Q: What is a Class and an Object?
A: Class is a blueprint. Object is an instance of a class.
Q: What is method overloading?
A: Same method name with different parameters.
Q: What is method overriding?
A: Subclass redefines a method of its parent class.
