MS Office: A Complete Chapter
Introduction to MS Office
Microsoft Office is a suite of productivity applications developed by Microsoft Corporation. It includes software designed for word processing, spreadsheets, presentations, databases, and communication. The most commonly used programs in MS Office are:
- Microsoft Word
- Microsoft Excel
- Microsoft PowerPoint
- Microsoft Access
- Microsoft Outlook
These applications are widely used in homes, schools, and offices around the world for a variety of professional and personal tasks.
1. Microsoft Word
1.1 Overview
Microsoft Word is a word-processing software used to create, edit, format, and print text documents. It is commonly used for writing letters, reports, resumes, and books.
1.2 Features
- Ribbon Interface: Organized into tabs like Home, Insert, Design, Layout, References, Review, and View.
- Templates: Ready-made templates for resumes, letters, brochures, etc.
- Formatting Tools: Fonts, font size, bold, italics, underline, paragraph spacing, alignment, and bullets.
- Spell Check and Grammar: Helps identify and correct errors.
- Track Changes and Comments: Useful for editing and collaboration.
- Mail Merge: Used for bulk printing of letters, labels, or emails.
- Insert Tools: Allows you to add pictures, shapes, charts, tables, hyperlinks, headers, and footers.
- Table of Contents: Automatically generate based on document headings.
1.3 Common Uses
- Drafting official documents
- Writing academic papers
- Creating reports and summaries
- Resume writing
2. Microsoft Excel
2.1 Overview
Microsoft Excel is a spreadsheet software used for calculations, data organization, analysis, and visualization.
2.2 Features
- Cells and Worksheets: Workbooks contain multiple worksheets made up of rows and columns.
- Formulas and Functions: Perform calculations like
=SUM(),=AVERAGE(),=IF(),=VLOOKUP(),=INDEX(),=MATCH(). - Charts and Graphs: Visual representation of data (bar, pie, line, area, etc.).
- Data Validation: Restrict data input to certain values or formats.
- Pivot Tables: Summarize and analyze large datasets.
- Conditional Formatting: Highlight data based on specific criteria.
- Data Filtering and Sorting: Organize and extract useful information.
- Macros: Automate repetitive tasks using VBA (Visual Basic for Applications).
2.3 Common Uses
- Budgeting and accounting
- Employee salary and attendance tracking
- Data analysis and reporting
- Sales and inventory tracking
3. Microsoft PowerPoint
3.1 Overview
Microsoft PowerPoint is used to create slideshow presentations. It is useful for visual communication in classrooms, meetings, and seminars.
3.2 Features
- Slides and Layouts: Build presentations slide-by-slide.
- Themes and Templates: Built-in designs for professional presentations.
- Transitions and Animations: Add movement between slides and within elements.
- Multimedia Support: Insert audio, video, and images.
- Charts and SmartArt: Represent ideas graphically.
- Slide Master: Customize the design of an entire presentation.
- Presenter View: Gives control tools while presenting.
3.3 Common Uses
- Educational lectures
- Business pitches
- Product demos
- Training sessions
4. Microsoft Access
4.1 Overview
Microsoft Access is a database management system (DBMS) that combines a graphical user interface with software-development tools to store and manage structured data.
4.2 Features
- Tables: Store data in rows and columns.
- Queries: Extract and analyze data using SQL.
- Forms: User-friendly interface for data entry.
- Reports: Generate formatted output for printing or analysis.
- Relationships: Link multiple tables based on key fields.
- Macros and Modules: Automate tasks and add advanced functionality.
- Data Import/Export: Work with data from Excel, SQL Server, or external files.
4.3 Common Uses
- Inventory databases
- Student records management
- Customer relationship management (CRM)
- Small-scale ERP systems
5. Microsoft Outlook
5.1 Overview
Microsoft Outlook is an email client and personal information manager. It integrates with calendar, task, and contact management.
5.2 Features
- Email Management: Send, receive, and organize emails.
- Folders and Rules: Sort incoming messages automatically.
- Calendar: Schedule meetings, events, and reminders.
- Contacts: Store and manage contact details.
- Tasks and To-Do Lists: Organize daily work and deadlines.
- Search Functionality: Quickly locate messages or contacts.
- Integration with Microsoft Teams and OneDrive.
5.3 Common Uses
- Professional and corporate email communication
- Scheduling and meeting management
- Shared calendar for teams
- Managing client contacts and follow-ups
6. MS Office Integration Features
6.1 Cross-Application Features
- Copy-Paste Across Apps: Copy content from Excel to Word or PowerPoint.
- Embedding and Linking: Embed Excel charts into Word or PowerPoint presentations.
- Mail Merge (Word + Outlook): Send bulk personalized emails.
- Scheduling (Excel + Outlook): Use Excel data to set reminders in Outlook.
- Database Reporting (Access + Word/Excel): Use Access data to generate reports in Word or analyze in Excel.
6.2 Cloud and Online Features
- OneDrive Integration: Save and access documents from the cloud.
- Office Online: Use lightweight versions in web browsers.
- Collaboration Tools: Real-time co-authoring and chat features.
- AutoSave: Automatically save work to OneDrive or SharePoint.
7. Security and Accessibility Features
7.1 Document Protection
- Password protection for files
- Restrict editing and formatting
- Digital signatures
7.2 Accessibility Tools
- Narrator: Read text aloud.
- Accessibility Checker: Ensure documents are readable by people with disabilities.
- Translate and Language Tools
8. MS Office Versions and Platforms
8.1 Popular Versions
- MS Office 2010: Introduced ribbon interface improvements.
- MS Office 2013: Cloud features added.
- MS Office 2016: Improved collaboration tools.
- MS Office 2019: Modern interface with new chart types.
- Office 365 (Microsoft 365): Subscription model with regular updates.
8.2 Platforms
- Windows
- macOS
- Android/iOS (mobile apps)
- Web browsers (Office Online)
9. Tips for Effective Use of MS Office
- Learn keyboard shortcuts for speed and efficiency.
- Use templates for consistent formatting.
- Back up documents regularly.
- Enable auto-save with OneDrive.
- Explore advanced features like macros, PivotTables, SmartArt, and mail merge.
- Customize the Ribbon and Quick Access Toolbar.
- Regularly update software for security and new features.
✅ MS Office MCQs (1–50)
Microsoft Word
- Which file extension is used by default in MS Word 2016?
a) .txt
b) .doc
c) .docx
d) .rtf
✅ Answer: c) .docx - What is the shortcut key to save a document in MS Word?
a) Ctrl + C
b) Ctrl + S
c) Ctrl + P
d) Ctrl + V
✅ Answer: b) Ctrl + S - What is the default font in MS Word 2016?
a) Arial
b) Calibri
c) Times New Roman
d) Verdana
✅ Answer: b) Calibri - Which tab contains the ‘Paragraph’ group?
a) Home
b) Insert
c) Layout
d) View
✅ Answer: a) Home - Which feature is used to combine the main document with a data source in Word?
a) Track Changes
b) AutoCorrect
c) Mail Merge
d) Format Painter
✅ Answer: c) Mail Merge
Microsoft Excel
- Which symbol is used before a formula in Excel?
a) @
b) #
c) =
d) $
✅ Answer: c) = - Which function is used to find the average in Excel?
a) =SUM()
b) =TOTAL()
c) =ADD()
d) =AVERAGE()
✅ Answer: d) =AVERAGE() - What is the intersection of a row and column called?
a) Field
b) Box
c) Cell
d) Table
✅ Answer: c) Cell - Which shortcut key is used to insert a new worksheet?
a) Shift + F11
b) Ctrl + W
c) Ctrl + T
d) Alt + Enter
✅ Answer: a) Shift + F11 - Which of the following is not a valid data type in Excel?
a) Number
b) Text
c) Date/Time
d) Character
✅ Answer: d) Character
Microsoft PowerPoint
- Which key is used to start a slide show from the beginning?
a) F5
b) F2
c) F9
d) F11
✅ Answer: a) F5 - Which feature allows you to apply motion effects to text or objects?
a) Transition
b) Animation
c) Template
d) Slide Sorter
✅ Answer: b) Animation - What is the default slide layout when a new slide is added?
a) Title Only
b) Two Content
c) Title and Content
d) Blank
✅ Answer: c) Title and Content - Which pane is used to type speaker notes?
a) Outline Pane
b) Notes Pane
c) Slides Pane
d) Task Pane
✅ Answer: b) Notes Pane - Which tab includes the ‘Slide Master’ option?
a) Insert
b) Design
c) View
d) Animations
✅ Answer: c) View
Microsoft Access
- Which object in Access is used to store data?
a) Form
b) Report
c) Table
d) Query
✅ Answer: c) Table - Which key is used to uniquely identify each record in a table?
a) Foreign Key
b) Unique Key
c) Primary Key
d) Index Key
✅ Answer: c) Primary Key - Which object is used to retrieve specific data by criteria?
a) Table
b) Query
c) Form
d) Macro
✅ Answer: b) Query - Which type of relationship is possible in Access?
a) One-to-One
b) One-to-Many
c) Many-to-Many
d) All of the above
✅ Answer: d) All of the above - What is the default file extension for Access databases?
a) .mdb
b) .accdb
c) .xls
d) .dbf
✅ Answer: b) .accdb
Microsoft Outlook
- What is the default folder for incoming emails in Outlook?
a) Outbox
b) Sent Items
c) Inbox
d) Drafts
✅ Answer: c) Inbox - Which component of Outlook helps schedule meetings?
a) Inbox
b) Calendar
c) Tasks
d) Notes
✅ Answer: b) Calendar - Which tab is used to create a new email message?
a) Home
b) View
c) Insert
d) File
✅ Answer: a) Home - What is the shortcut key to reply to an email in Outlook?
a) Ctrl + R
b) Ctrl + S
c) Ctrl + M
d) Ctrl + E
✅ Answer: a) Ctrl + R - Which feature allows auto-response to emails?
a) Rules
b) Auto Archive
c) Out of Office Assistant
d) Mail Merge
✅ Answer: c) Out of Office Assistant
✅ MS Office MCQs (26–50)
(Word, Excel, PowerPoint, Access, Outlook)
Microsoft Word
- Which feature in Word allows you to copy formatting from one part to another?
a) Format Painter
b) Styles
c) WordArt
d) SmartArt
✅ Answer: a) Format Painter - Which menu is used to insert a table in Word?
a) Home
b) Insert
c) Layout
d) Design
✅ Answer: b) Insert - What is the function of the ‘Ctrl + Enter’ key in MS Word?
a) Line break
b) Page break
c) Paragraph spacing
d) Save document
✅ Answer: b) Page break - Which option is used to create a numbered list in Word?
a) Bullets
b) Columns
c) Numbering
d) Styles
✅ Answer: c) Numbering - Which toolbar provides quick access to commonly used commands?
a) Navigation Bar
b) Quick Access Toolbar
c) Title Bar
d) Formatting Toolbar
✅ Answer: b) Quick Access Toolbar
Microsoft Excel
- Which function returns the highest value in a range?
a) =MAX()
b) =HIGH()
c) =LARGE()
d) =TOP()
✅ Answer: a) =MAX() - What does the CONCATENATE function do?
a) Combines two or more text strings
b) Finds average
c) Sorts data
d) Multiplies numbers
✅ Answer: a) Combines two or more text strings - Which feature shows a preview of how your data will look when printed?
a) Print Setup
b) Print Preview
c) Page Layout
d) Page Break
✅ Answer: b) Print Preview - What is the cell address of the first cell in a worksheet?
a) A0
b) A1
c) 0A
d) 1A
✅ Answer: b) A1 - Which function is used to count only numeric values in a range?
a) =COUNTIF()
b) =COUNTA()
c) =COUNT()
d) =SUM()
✅ Answer: c) =COUNT()
Microsoft PowerPoint
- Which view in PowerPoint shows all slides as thumbnails?
a) Slide Sorter
b) Slide Show
c) Normal View
d) Outline View
✅ Answer: a) Slide Sorter - Which file extension is used for PowerPoint presentations?
a) .pptx
b) .docx
c) .xlsx
d) .mdb
✅ Answer: a) .pptx - What does the Slide Master allow you to do?
a) Add animations
b) Edit individual slides
c) Control the overall design
d) Insert hyperlinks
✅ Answer: c) Control the overall design - Which tab contains the ‘SmartArt’ option?
a) Insert
b) Design
c) Review
d) View
✅ Answer: a) Insert - What is the shortcut key to insert a new slide?
a) Ctrl + N
b) Ctrl + M
c) Ctrl + Enter
d) Ctrl + Shift + N
✅ Answer: b) Ctrl + M
Microsoft Access
- Which object is used for user-friendly data entry in Access?
a) Form
b) Table
c) Report
d) Macro
✅ Answer: a) Form - Which view allows you to enter and modify table data directly?
a) Datasheet View
b) Design View
c) SQL View
d) Layout View
✅ Answer: a) Datasheet View - Which type of query changes data in a table?
a) Append Query
b) Update Query
c) Make Table Query
d) Select Query
✅ Answer: b) Update Query - What does a “foreign key” do?
a) Acts as a unique identifier
b) Connects tables through relationships
c) Deletes duplicate data
d) Creates macros
✅ Answer: b) Connects tables through relationships - What is the default primary key data type?
a) Number
b) AutoNumber
c) Text
d) Date/Time
✅ Answer: b) AutoNumber
Microsoft Outlook
- Which option is used to send a copy of an email to someone else?
a) BCC
b) Draft
c) CC
d) Forward
✅ Answer: c) CC - What does BCC stand for in email terminology?
a) Backup Carbon Copy
b) Blind Carbon Copy
c) Better Contact Copy
d) Bulk Copy Command
✅ Answer: b) Blind Carbon Copy - What is the purpose of the ‘Rules’ option in Outlook?
a) Filter spam
b) Automatically sort emails
c) Block contacts
d) Schedule meetings
✅ Answer: b) Automatically sort emails - Which item type is not found in Outlook?
a) Notes
b) Tasks
c) Spreadsheets
d) Calendar
✅ Answer: c) Spreadsheets - Which shortcut key is used to send an email?
a) Ctrl + S
b) Alt + S
c) Ctrl + M
d) Ctrl + Enter
✅ Answer: b) Alt + S
Absolutely! Here’s the next set:
✅ MS Office MCQs (51–100)
(Word, Excel, PowerPoint, Access, Outlook)
Microsoft Word
- Which option allows changing text orientation in Word?
a) Styles
b) Text Direction
c) Font Dialog Box
d) Themes
✅ Answer: b) Text Direction - Which key is used to make text bold in Word?
a) Ctrl + I
b) Ctrl + U
c) Ctrl + B
d) Ctrl + E
✅ Answer: c) Ctrl + B - Which option is used to check spelling errors in Word?
a) AutoCorrect
b) Word Count
c) Spell Check
d) Review Pane
✅ Answer: c) Spell Check - Which tab contains the ‘Track Changes’ feature?
a) Insert
b) Review
c) Home
d) View
✅ Answer: b) Review - Which feature keeps the header visible at the top of each page?
a) Footer
b) Watermark
c) Header
d) Title Bar
✅ Answer: c) Header
Microsoft Excel
- What does the VLOOKUP function do?
a) Finds data in horizontal cells
b) Returns vertical data from a table
c) Validates data
d) Converts text
✅ Answer: b) Returns vertical data from a table - Which function counts cells with non-empty content?
a) =COUNTBLANK()
b) =COUNTA()
c) =COUNT()
d) =COUNTIF()
✅ Answer: b) =COUNTA() - What does the ‘$’ symbol do in a formula like $A$1?
a) Adds percentage
b) Freezes cell reference
c) Formats currency
d) Adds cell values
✅ Answer: b) Freezes cell reference - What is the name of a predesigned spreadsheet in Excel?
a) Macro
b) Template
c) Workbook
d) Style
✅ Answer: b) Template - Which feature in Excel allows you to view only specific rows based on conditions?
a) Sort
b) Filter
c) Format
d) Data Tool
✅ Answer: b) Filter
Microsoft PowerPoint
- Which tool is used to duplicate an existing slide?
a) Paste Special
b) Duplicate Slide
c) Insert Slide
d) New Slide
✅ Answer: b) Duplicate Slide - What does the Rehearse Timings feature do?
a) Times animations
b) Sets audio
c) Times slide transitions
d) Sets font size
✅ Answer: c) Times slide transitions - Which view is best for rearranging slides?
a) Normal View
b) Slide Show
c) Outline View
d) Slide Sorter
✅ Answer: d) Slide Sorter - Which option applies movement to slide content?
a) Slide Design
b) Animation
c) Transition
d) Slide Master
✅ Answer: b) Animation - Which tab includes slide themes and colors?
a) Home
b) Insert
c) Design
d) Review
✅ Answer: c) Design
Microsoft Access
- Which object displays data from multiple tables?
a) Table
b) Query
c) Form
d) Report
✅ Answer: b) Query - Which Access object allows data analysis and print layout?
a) Form
b) Table
c) Query
d) Report
✅ Answer: d) Report - What is the purpose of macros in Access?
a) Format text
b) Save forms
c) Automate tasks
d) Store data
✅ Answer: c) Automate tasks - Which Access view allows table structure editing?
a) Datasheet View
b) Form View
c) Layout View
d) Design View
✅ Answer: d) Design View - Which tool helps build relationships between tables?
a) Relationship Tool
b) Join Manager
c) Linker
d) Data Connector
✅ Answer: a) Relationship Tool
Microsoft Outlook
- Which item allows setting personal reminders in Outlook?
a) Notes
b) Tasks
c) Journal
d) Mail
✅ Answer: b) Tasks - Which pane shows a list of emails?
a) Navigation Pane
b) Reading Pane
c) Folder Pane
d) Message List
✅ Answer: d) Message List - Which tab includes the option to create a meeting invite?
a) File
b) Home
c) Insert
d) Calendar
✅ Answer: b) Home - Which component shows the schedule by day/week/month?
a) Tasks
b) Calendar
c) Contacts
d) Inbox
✅ Answer: b) Calendar - Which format is used to export contacts from Outlook?
a) .doc
b) .xlsx
c) .pst
d) .txt
✅ Answer: c) .pst
Mixed MS Office
- What does the clipboard feature do?
a) Compresses files
b) Stores copied items temporarily
c) Fixes spelling
d) Adjusts screen size
✅ Answer: b) Stores copied items temporarily - Which MS Office application is best for data analysis?
a) Word
b) Excel
c) PowerPoint
d) Outlook
✅ Answer: b) Excel - Which application is used for writing reports?
a) PowerPoint
b) Excel
c) Word
d) Access
✅ Answer: c) Word - Which shortcut prints a document?
a) Ctrl + P
b) Ctrl + D
c) Ctrl + R
d) Ctrl + S
✅ Answer: a) Ctrl + P - Which shortcut closes the active window?
a) Ctrl + F4
b) Alt + F4
c) Ctrl + W
d) Shift + Esc
✅ Answer: b) Alt + F4 - What is a ‘Suite’ in Microsoft Office?
a) A single software
b) A virus protection tool
c) A group of applications
d) A browser
✅ Answer: c) A group of applications - Which extension is used for Excel 2016 files?
a) .xlsx
b) .xls
c) .xlsm
d) .docx
✅ Answer: a) .xlsx - Which Office tool helps in making charts and graphs?
a) PowerPoint
b) Word
c) Excel
d) Outlook
✅ Answer: c) Excel - Which Microsoft Office version introduced the Ribbon interface?
a) 2003
b) 2007
c) 2010
d) 2013
✅ Answer: b) 2007 - Which feature enables shared editing in real time?
a) AutoSave
b) Co-authoring
c) Mail Merge
d) SmartArt
✅ Answer: b) Co-authoring - What is the cloud version of Office called?
a) Office 360
b) Office Web
c) Microsoft 365
d) Office Online
✅ Answer: c) Microsoft 365 - Which Office app is used for managing emails?
a) Word
b) Outlook
c) Excel
d) Access
✅ Answer: b) Outlook - Which Office tool helps create a database?
a) Word
b) Access
c) Excel
d) PowerPoint
✅ Answer: b) Access - Which Office component helps you present slides?
a) PowerPoint
b) Excel
c) Access
d) Word
✅ Answer: a) PowerPoint - Which feature stores recently opened files in Word?
a) File History
b) Recent Documents
c) Quick Access
d) Open Tab
✅ Answer: b) Recent Documents - Which MS Office program allows macro programming using VBA?
a) Word
b) Excel
c) PowerPoint
d) All of the above
✅ Answer: d) All of the above - Which key combination opens the Find dialog in Office apps?
a) Ctrl + F
b) Ctrl + G
c) Ctrl + H
d) Ctrl + P
✅ Answer: a) Ctrl + F - Which tool protects a document from editing?
a) Bookmark
b) Protect Document
c) Save As
d) Font Lock
✅ Answer: b) Protect Document - Which key refreshes content in Outlook?
a) F9
b) F5
c) Ctrl + R
d) Ctrl + F9
✅ Answer: a) F9 - Which Outlook feature helps categorize emails?
a) Labels
b) Tags
c) Rules
d) All of the above
✅ Answer: d) All of the above - Which component shows preview of a Word doc?
a) Task Pane
b) Reading Pane
c) Preview Pane
d) Print Preview
✅ Answer: d) Print Preview - Which PowerPoint feature sets how one slide replaces another?
a) Transition
b) Animation
c) Slide Design
d) Layout
✅ Answer: a) Transition - Which shortcut selects all content in MS Word?
a) Ctrl + S
b) Ctrl + A
c) Ctrl + E
d) Ctrl + Q
✅ Answer: b) Ctrl + A - Which view shows a document as it will appear when printed?
a) Web Layout
b) Print Layout
c) Draft
d) Outline
✅ Answer: b) Print Layout - Which is a valid use of Excel charts?
a) Editing macros
b) Creating transitions
c) Visualizing data
d) Linking databases
✅ Answer: c) Visualizing data
Absolutely! Here’s the next set:
✅ MS Office MCQs (51–100)
(Word, Excel, PowerPoint, Access, Outlook)
Microsoft Word
- Which option allows changing text orientation in Word?
a) Styles
b) Text Direction
c) Font Dialog Box
d) Themes
✅ Answer: b) Text Direction - Which key is used to make text bold in Word?
a) Ctrl + I
b) Ctrl + U
c) Ctrl + B
d) Ctrl + E
✅ Answer: c) Ctrl + B - Which option is used to check spelling errors in Word?
a) AutoCorrect
b) Word Count
c) Spell Check
d) Review Pane
✅ Answer: c) Spell Check - Which tab contains the ‘Track Changes’ feature?
a) Insert
b) Review
c) Home
d) View
✅ Answer: b) Review - Which feature keeps the header visible at the top of each page?
a) Footer
b) Watermark
c) Header
d) Title Bar
✅ Answer: c) Header
Microsoft Excel
- What does the VLOOKUP function do?
a) Finds data in horizontal cells
b) Returns vertical data from a table
c) Validates data
d) Converts text
✅ Answer: b) Returns vertical data from a table - Which function counts cells with non-empty content?
a) =COUNTBLANK()
b) =COUNTA()
c) =COUNT()
d) =COUNTIF()
✅ Answer: b) =COUNTA() - What does the ‘$’ symbol do in a formula like $A$1?
a) Adds percentage
b) Freezes cell reference
c) Formats currency
d) Adds cell values
✅ Answer: b) Freezes cell reference - What is the name of a predesigned spreadsheet in Excel?
a) Macro
b) Template
c) Workbook
d) Style
✅ Answer: b) Template - Which feature in Excel allows you to view only specific rows based on conditions?
a) Sort
b) Filter
c) Format
d) Data Tool
✅ Answer: b) Filter
Microsoft PowerPoint
- Which tool is used to duplicate an existing slide?
a) Paste Special
b) Duplicate Slide
c) Insert Slide
d) New Slide
✅ Answer: b) Duplicate Slide - What does the Rehearse Timings feature do?
a) Times animations
b) Sets audio
c) Times slide transitions
d) Sets font size
✅ Answer: c) Times slide transitions - Which view is best for rearranging slides?
a) Normal View
b) Slide Show
c) Outline View
d) Slide Sorter
✅ Answer: d) Slide Sorter - Which option applies movement to slide content?
a) Slide Design
b) Animation
c) Transition
d) Slide Master
✅ Answer: b) Animation - Which tab includes slide themes and colors?
a) Home
b) Insert
c) Design
d) Review
✅ Answer: c) Design
Microsoft Access
- Which object displays data from multiple tables?
a) Table
b) Query
c) Form
d) Report
✅ Answer: b) Query - Which Access object allows data analysis and print layout?
a) Form
b) Table
c) Query
d) Report
✅ Answer: d) Report - What is the purpose of macros in Access?
a) Format text
b) Save forms
c) Automate tasks
d) Store data
✅ Answer: c) Automate tasks - Which Access view allows table structure editing?
a) Datasheet View
b) Form View
c) Layout View
d) Design View
✅ Answer: d) Design View - Which tool helps build relationships between tables?
a) Relationship Tool
b) Join Manager
c) Linker
d) Data Connector
✅ Answer: a) Relationship Tool
Microsoft Outlook
- Which item allows setting personal reminders in Outlook?
a) Notes
b) Tasks
c) Journal
d) Mail
✅ Answer: b) Tasks - Which pane shows a list of emails?
a) Navigation Pane
b) Reading Pane
c) Folder Pane
d) Message List
✅ Answer: d) Message List - Which tab includes the option to create a meeting invite?
a) File
b) Home
c) Insert
d) Calendar
✅ Answer: b) Home - Which component shows the schedule by day/week/month?
a) Tasks
b) Calendar
c) Contacts
d) Inbox
✅ Answer: b) Calendar - Which format is used to export contacts from Outlook?
a) .doc
b) .xlsx
c) .pst
d) .txt
✅ Answer: c) .pst
Mixed MS Office
- What does the clipboard feature do?
a) Compresses files
b) Stores copied items temporarily
c) Fixes spelling
d) Adjusts screen size
✅ Answer: b) Stores copied items temporarily - Which MS Office application is best for data analysis?
a) Word
b) Excel
c) PowerPoint
d) Outlook
✅ Answer: b) Excel - Which application is used for writing reports?
a) PowerPoint
b) Excel
c) Word
d) Access
✅ Answer: c) Word - Which shortcut prints a document?
a) Ctrl + P
b) Ctrl + D
c) Ctrl + R
d) Ctrl + S
✅ Answer: a) Ctrl + P - Which shortcut closes the active window?
a) Ctrl + F4
b) Alt + F4
c) Ctrl + W
d) Shift + Esc
✅ Answer: b) Alt + F4 - What is a ‘Suite’ in Microsoft Office?
a) A single software
b) A virus protection tool
c) A group of applications
d) A browser
✅ Answer: c) A group of applications - Which extension is used for Excel 2016 files?
a) .xlsx
b) .xls
c) .xlsm
d) .docx
✅ Answer: a) .xlsx - Which Office tool helps in making charts and graphs?
a) PowerPoint
b) Word
c) Excel
d) Outlook
✅ Answer: c) Excel - Which Microsoft Office version introduced the Ribbon interface?
a) 2003
b) 2007
c) 2010
d) 2013
✅ Answer: b) 2007 - Which feature enables shared editing in real time?
a) AutoSave
b) Co-authoring
c) Mail Merge
d) SmartArt
✅ Answer: b) Co-authoring - What is the cloud version of Office called?
a) Office 360
b) Office Web
c) Microsoft 365
d) Office Online
✅ Answer: c) Microsoft 365 - Which Office app is used for managing emails?
a) Word
b) Outlook
c) Excel
d) Access
✅ Answer: b) Outlook - Which Office tool helps create a database?
a) Word
b) Access
c) Excel
d) PowerPoint
✅ Answer: b) Access - Which Office component helps you present slides?
a) PowerPoint
b) Excel
c) Access
d) Word
✅ Answer: a) PowerPoint - Which feature stores recently opened files in Word?
a) File History
b) Recent Documents
c) Quick Access
d) Open Tab
✅ Answer: b) Recent Documents - Which MS Office program allows macro programming using VBA?
a) Word
b) Excel
c) PowerPoint
d) All of the above
✅ Answer: d) All of the above - Which key combination opens the Find dialog in Office apps?
a) Ctrl + F
b) Ctrl + G
c) Ctrl + H
d) Ctrl + P
✅ Answer: a) Ctrl + F - Which tool protects a document from editing?
a) Bookmark
b) Protect Document
c) Save As
d) Font Lock
✅ Answer: b) Protect Document - Which key refreshes content in Outlook?
a) F9
b) F5
c) Ctrl + R
d) Ctrl + F9
✅ Answer: a) F9 - Which Outlook feature helps categorize emails?
a) Labels
b) Tags
c) Rules
d) All of the above
✅ Answer: d) All of the above - Which component shows preview of a Word doc?
a) Task Pane
b) Reading Pane
c) Preview Pane
d) Print Preview
✅ Answer: d) Print Preview - Which PowerPoint feature sets how one slide replaces another?
a) Transition
b) Animation
c) Slide Design
d) Layout
✅ Answer: a) Transition - Which shortcut selects all content in MS Word?
a) Ctrl + S
b) Ctrl + A
c) Ctrl + E
d) Ctrl + Q
✅ Answer: b) Ctrl + A - Which view shows a document as it will appear when printed?
a) Web Layout
b) Print Layout
c) Draft
d) Outline
✅ Answer: b) Print Layout - Which is a valid use of Excel charts?
a) Editing macros
b) Creating transitions
c) Visualizing data
d) Linking databases
✅ Answer: c) Visualizing data
✅ MS Office MCQs (101–150)
(Word, Excel, PowerPoint, Access, Outlook)
Microsoft Word
- Which shortcut opens the Font dialog box?
a) Ctrl + D
b) Ctrl + F
c) Ctrl + T
d) Ctrl + B
✅ Answer: a) Ctrl + D - Which option allows setting page margins?
a) Layout → Margins
b) Home → Font
c) Insert → Page
d) Review → Spacing
✅ Answer: a) Layout → Margins - What is WordArt used for?
a) Spell Check
b) Adding stylish text
c) Creating macros
d) Formatting tables
✅ Answer: b) Adding stylish text - Which option is used to divide a Word document into multiple columns?
a) Page Layout → Columns
b) Insert → Text Box
c) Design → Columns
d) View → Columns
✅ Answer: a) Page Layout → Columns - Which option helps to add comments in a Word document?
a) Insert → Comment
b) Review → Comment
c) View → Comment
d) File → Comment
✅ Answer: b) Review → Comment
Microsoft Excel
- Which Excel function adds the values in a range?
a) =ADD()
b) =TOTAL()
c) =SUM()
d) =COMBINE()
✅ Answer: c) =SUM() - Which symbol is used before a formula in Excel?
a) =
b) +
c) %
d) @
✅ Answer: a) = - What is the default file extension of Excel workbooks?
a) .xls
b) .xlsm
c) .xlsx
d) .docx
✅ Answer: c) .xlsx - What does the COUNTIF function do?
a) Counts empty cells
b) Counts all numbers
c) Counts cells matching a condition
d) None of the above
✅ Answer: c) Counts cells matching a condition - Which feature allows repeated column headings on every printed page?
a) Header
b) Repeat Labels
c) Print Titles
d) Page Break
✅ Answer: c) Print Titles - What does ‘Wrap Text’ do in Excel?
a) Combines cells
b) Deletes data
c) Fits content in one cell
d) Moves content to the next cell
✅ Answer: c) Fits content in one cell - Which chart type displays trends over time?
a) Pie Chart
b) Bar Chart
c) Line Chart
d) Area Chart
✅ Answer: c) Line Chart - Which function returns the current date and time?
a) =TODAY()
b) =DATE()
c) =NOW()
d) =TIME()
✅ Answer: c) =NOW() - Which feature fills a series automatically in Excel?
a) Smart Fill
b) AutoComplete
c) AutoFill
d) Quick Fill
✅ Answer: c) AutoFill - Which tab contains conditional formatting?
a) Insert
b) Formulas
c) Data
d) Home
✅ Answer: d) Home
Microsoft PowerPoint
- Which transition effect is used for slide changes?
a) Entrance
b) Emphasis
c) Exit
d) Transition
✅ Answer: d) Transition - Which option allows you to insert audio into a slide?
a) Home
b) Design
c) Insert
d) Transitions
✅ Answer: c) Insert - Which menu is used to add slide numbers?
a) Home
b) Insert
c) View
d) Design
✅ Answer: b) Insert - Which file format is used to save a PowerPoint show?
a) .ppt
b) .pptx
c) .ppsx
d) .pdf
✅ Answer: c) .ppsx - What is a placeholder in PowerPoint?
a) A theme
b) A background
c) A text or object box
d) A slide
✅ Answer: c) A text or object box - What is the default orientation of a slide in PowerPoint?
a) Landscape
b) Portrait
c) Vertical
d) Horizontal
✅ Answer: a) Landscape - What does the Slide Show tab help with?
a) Animation settings
b) Spell check
c) Running presentation
d) Slide layout
✅ Answer: c) Running presentation - What is used to animate text on a slide?
a) Slide Transition
b) SmartArt
c) Animation Pane
d) Slide Master
✅ Answer: c) Animation Pane - What shortcut starts a slide show from the beginning?
a) F5
b) F9
c) Shift + F5
d) Alt + F5
✅ Answer: a) F5 - Which feature is used to print multiple slides per page?
a) Print Layout
b) Slide Master
c) Handouts
d) Notes Page
✅ Answer: c) Handouts
Microsoft Access
- Which object is used to summarize and print data?
a) Query
b) Form
c) Report
d) Table
✅ Answer: c) Report - What is a primary key?
a) A unique identifier for records
b) A relationship tool
c) A type of field
d) A form feature
✅ Answer: a) A unique identifier for records - Which query type is used to delete records?
a) Select
b) Delete
c) Update
d) Append
✅ Answer: b) Delete - Which data type is suitable for large text?
a) Text
b) Memo
c) Long Text
d) AutoNumber
✅ Answer: c) Long Text - Which of the following is not an Access object?
a) Form
b) Table
c) Field
d) Slide
✅ Answer: d) Slide - Which database model does MS Access follow?
a) Hierarchical
b) Network
c) Relational
d) Object-Oriented
✅ Answer: c) Relational - What is a form primarily used for?
a) Data entry
b) Table creation
c) Report formatting
d) Code writing
✅ Answer: a) Data entry - Which field type is ideal for prices?
a) Currency
b) Number
c) Text
d) AutoNumber
✅ Answer: a) Currency - What is used to filter records based on conditions?
a) Macro
b) Query
c) Form
d) Table
✅ Answer: b) Query - Which feature establishes table relationships?
a) Relationship Window
b) Form Design
c) Table Wizard
d) Report Builder
✅ Answer: a) Relationship Window
Microsoft Outlook
- What does the Calendar in Outlook help manage?
a) Notes
b) Appointments
c) Tasks
d) Contacts
✅ Answer: b) Appointments - Which Outlook feature helps avoid junk emails?
a) Archive
b) Rules
c) Junk Filter
d) Grouping
✅ Answer: c) Junk Filter - Which feature alerts about new emails?
a) Pop-up
b) Desktop Alert
c) Reminder
d) Flash
✅ Answer: b) Desktop Alert - How can you create a recurring meeting in Outlook?
a) Set Alarm
b) Repeat Button
c) Recurrence Option
d) Weekly Task
✅ Answer: c) Recurrence Option - Which item in Outlook stores unsent emails?
a) Inbox
b) Outbox
c) Drafts
d) Archive
✅ Answer: c) Drafts - What does the ‘Flag’ option do in emails?
a) Blocks sender
b) Marks for follow-up
c) Deletes email
d) Archives email
✅ Answer: b) Marks for follow-up - Which component lets you create contact groups?
a) Tasks
b) Contacts
c) Notes
d) Mail
✅ Answer: b) Contacts - How do you set email signatures in Outlook?
a) File → Options → Mail
b) Home → Insert
c) View → Tools
d) File → Print
✅ Answer: a) File → Options → Mail - Which Outlook feature checks grammar?
a) Spelling & Grammar
b) Proofing
c) Style Checker
d) AutoCorrect
✅ Answer: a) Spelling & Grammar - Which item displays unread email count?
a) Folder Pane
b) Task Bar
c) Navigation Bar
d) To-Do List
✅ Answer: a) Folder Pane
Mixed
- Which command is used to save a new document in MS Word?
a) Ctrl + O
b) Ctrl + N
c) Ctrl + S
d) Ctrl + P
✅ Answer: c) Ctrl + S - In Excel, how can you remove duplicate entries?
a) Sort
b) Filter
c) Remove Duplicates
d) Data Validation
✅ Answer: c) Remove Duplicates - What does Mail Merge do in Word?
a) Merges files
b) Creates bulk personalized letters
c) Formats pages
d) Edits images
✅ Answer: b) Creates bulk personalized letters - Which MS Office tool is best for creating presentations?
a) Excel
b) Word
c) PowerPoint
d) Outlook
✅ Answer: c) PowerPoint - Which Office app helps manage database tables and queries?
a) PowerPoint
b) Excel
c) Access
d) Word
✅ Answer: c) Access
✅ MS Office MCQs (151–200)
(Word, Excel, PowerPoint, Access, Outlook)
Microsoft Word
- Which feature allows the comparison of two versions of a document?
a) Combine
b) Track Changes
c) Compare
d) Merge
✅ Answer: c) Compare - Which menu allows you to apply Themes in Word?
a) Insert
b) Page Layout
c) Design
d) View
✅ Answer: c) Design - What is a section break used for in Word?
a) Start a new page
b) Divide document into parts with different formatting
c) End a paragraph
d) Split text into columns
✅ Answer: b) Divide document into parts with different formatting - Which option enables numbering in Word?
a) Format → Number
b) Insert → Number
c) Home → Numbering
d) View → Number
✅ Answer: c) Home → Numbering - What is the default page orientation in Word?
a) Landscape
b) Portrait
c) Horizontal
d) Vertical
✅ Answer: b) Portrait
Microsoft Excel
- Which of these is NOT a valid function in Excel?
a) VLOOKUP
b) SUMIF
c) GETDATA
d) COUNT
✅ Answer: c) GETDATA - What is the maximum number of rows in Excel 2016?
a) 65,536
b) 1,048,576
c) 2,147,483
d) 100,000
✅ Answer: b) 1,048,576 - Which function returns the highest value?
a) LARGE()
b) MAX()
c) UPPER()
d) BIG()
✅ Answer: b) MAX() - Which Excel feature helps in viewing data from two sheets side by side?
a) Freeze Panes
b) Split
c) New Window
d) View Side by Side
✅ Answer: d) View Side by Side - What is the shortcut key to insert a new worksheet?
a) Ctrl + N
b) Shift + F11
c) Ctrl + W
d) Ctrl + Enter
✅ Answer: b) Shift + F11 - What chart type compares parts to a whole?
a) Line
b) Bar
c) Pie
d) Column
✅ Answer: c) Pie - Which function finds the average?
a) MEAN()
b) AVG()
c) AVERAGE()
d) MID()
✅ Answer: c) AVERAGE() - What happens when you press Ctrl + ; in Excel?
a) Inserts current time
b) Inserts current date
c) Opens formula bar
d) Adds a comment
✅ Answer: b) Inserts current date - Which tab includes Data Validation?
a) Home
b) Data
c) Insert
d) Review
✅ Answer: b) Data - Which Excel function is used to return the position of a value in a range?
a) SEARCH()
b) INDEX()
c) MATCH()
d) LOCATE()
✅ Answer: c) MATCH()
Microsoft PowerPoint
- What does Slide Master control?
a) Layout of individual slides
b) Fonts and background for the entire presentation
c) Animations only
d) Printing layout
✅ Answer: b) Fonts and background for the entire presentation - What is the default file format in PowerPoint 2019?
a) .ppt
b) .pptx
c) .pptm
d) .ppsx
✅ Answer: b) .pptx - Which option allows inserting video in PowerPoint?
a) Home → Video
b) Insert → Video
c) Design → Video
d) View → Video
✅ Answer: b) Insert → Video - What shortcut starts slideshow from current slide?
a) F5
b) Shift + F5
c) Ctrl + F5
d) Alt + F5
✅ Answer: b) Shift + F5 - Which of the following is NOT a slide layout?
a) Title Slide
b) Two Content
c) Picture with Caption
d) Image Slide
✅ Answer: d) Image Slide - Which tab allows setting up slide timings?
a) Home
b) Slide Show
c) Transitions
d) Review
✅ Answer: b) Slide Show - Which pane shows a thumbnail view of slides?
a) Slide Pane
b) Outline Pane
c) Notes Pane
d) Thumbnail Pane
✅ Answer: d) Thumbnail Pane - What is the purpose of the Notes pane?
a) Add comments
b) Add presenter notes
c) Track changes
d) Slide formatting
✅ Answer: b) Add presenter notes - What feature allows adding motion to slide objects?
a) Themes
b) Slide Transition
c) Animation
d) SmartArt
✅ Answer: c) Animation - Which feature combines all objects into one in PowerPoint?
a) Merge Shapes
b) Group
c) Align
d) Layout
✅ Answer: b) Group
Microsoft Access
- What does a query return?
a) Forms
b) Records
c) Fields only
d) Design View
✅ Answer: b) Records - Which data type is best for yes/no questions?
a) Text
b) Number
c) Boolean
d) Memo
✅ Answer: c) Boolean - Which tool helps automate tasks in Access?
a) Macro
b) Query
c) Form
d) Relationship
✅ Answer: a) Macro - What is the use of Form View?
a) Create relationships
b) Modify data structure
c) View and enter data
d) Print data
✅ Answer: c) View and enter data - Which type of relationship connects one record to many others?
a) One-to-Many
b) One-to-One
c) Many-to-Many
d) None
✅ Answer: a) One-to-Many - What is an index in Access used for?
a) Adding styles
b) Speeding up searches
c) Printing reports
d) Creating macros
✅ Answer: b) Speeding up searches - Which view is used to design tables?
a) Datasheet View
b) Design View
c) Layout View
d) Query View
✅ Answer: b) Design View - What is AutoNumber field used for?
a) Manual numbering
b) Automatically increments a number
c) Adds date and time
d) Adds a name
✅ Answer: b) Automatically increments a number - Which field property ensures unique values?
a) Validation Rule
b) Format
c) Indexed (No Duplicates)
d) Input Mask
✅ Answer: c) Indexed (No Duplicates) - Which query updates multiple records?
a) Select Query
b) Update Query
c) Delete Query
d) Append Query
✅ Answer: b) Update Query
Microsoft Outlook
- Where are sent emails stored in Outlook?
a) Inbox
b) Sent Items
c) Drafts
d) Outbox
✅ Answer: b) Sent Items - How can you set rules for incoming emails?
a) Settings → Filter
b) File → Manage Rules & Alerts
c) Home → Clean Up
d) View → Rules
✅ Answer: b) File → Manage Rules & Alerts - How do you create a calendar event?
a) File → Calendar
b) Home → New Appointment
c) Insert → Event
d) Tools → New Task
✅ Answer: b) Home → New Appointment - Which folder contains emails removed from the inbox?
a) Deleted Items
b) Archive
c) Outbox
d) Spam
✅ Answer: a) Deleted Items - Which Outlook element helps manage tasks?
a) Notes
b) To-Do Bar
c) Calendar
d) Folders
✅ Answer: b) To-Do Bar - Which feature delays the sending of an email?
a) Rules
b) Schedule Send
c) Delay Delivery
d) Mail Merge
✅ Answer: c) Delay Delivery - What is a PST file?
a) Program Shortcut Tool
b) Personal Storage Table
c) Power Schedule Time
d) Print Settings Template
✅ Answer: b) Personal Storage Table - Where do meeting requests appear?
a) Task
b) Inbox
c) Notes
d) Sent
✅ Answer: b) Inbox - What does ‘BCC’ stand for?
a) Blind Carbon Copy
b) Background Copy
c) Bulk Copy Content
d) Block Carbon Contact
✅ Answer: a) Blind Carbon Copy - Which option automatically replies to incoming emails when you’re away?
a) Auto Response
b) Out-of-Office Assistant
c) Schedule Reply
d) Email Forwarding
✅ Answer: b) Out-of-Office Assistant
Mixed
- Which Office tool is used for calculations and charts?
a) PowerPoint
b) Excel
c) Access
d) Outlook
✅ Answer: b) Excel - Which Office program is best for email communication?
a) Word
b) Excel
c) Outlook
d) Access
✅ Answer: c) Outlook - Which Office application is used to create resumes?
a) Word
b) Excel
c) PowerPoint
d) Access
✅ Answer: a) Word - Which feature is common to all Office apps?
a) SmartArt
b) Mail Merge
c) Ribbon Interface
d) Conditional Formatting
✅ Answer: c) Ribbon Interface - Which of these apps is mainly for managing databases?
a) Word
b) Excel
c) PowerPoint
d) Access
✅ Answer: d) Access
