Q.1 Which of the following is not a component of Microsoft Office Suite?
Word
Excel
Photoshop
PowerPoint
Explanation - Microsoft Office Suite includes Word, Excel, PowerPoint, Outlook, and Access, but Photoshop is an Adobe product.
Correct answer is: Photoshop
Q.2 Which shortcut is used to copy selected text or objects in MS Word?
Ctrl + C
Ctrl + V
Ctrl + X
Ctrl + P
Explanation - Ctrl + C is the standard shortcut for copying selected text or objects in MS Office applications.
Correct answer is: Ctrl + C
Q.3 In Excel, what does the formula =SUM(A1:A5) do?
Adds the values in cells A1 to A5
Counts the number of cells from A1 to A5
Finds the average of cells A1 to A5
Deletes values in cells A1 to A5
Explanation - The SUM function in Excel adds all numeric values in the specified range.
Correct answer is: Adds the values in cells A1 to A5
Q.4 Which tab in MS PowerPoint allows you to add animations to slides?
Home
Insert
Design
Animations
Explanation - The Animations tab in PowerPoint allows users to apply entrance, exit, emphasis, and motion path effects to objects.
Correct answer is: Animations
Q.5 What is the default file extension for a Word document in MS Word 2019?
.doc
.docx
.txt
.pdf
Explanation - Since Word 2007, the default file extension for Word documents is .docx which uses the XML format.
Correct answer is: .docx
Q.6 In Excel, what is the purpose of the 'Freeze Panes' option?
Lock cells to prevent editing
Keep selected rows/columns visible while scrolling
Hide rows and columns
Split the sheet into multiple worksheets
Explanation - 'Freeze Panes' helps users view specific rows or columns even when scrolling through large datasets.
Correct answer is: Keep selected rows/columns visible while scrolling
Q.7 Which feature in MS Word helps in checking spelling and grammatical errors?
Track Changes
Word Count
Spelling & Grammar
AutoFormat
Explanation - The 'Spelling & Grammar' tool in Word checks for spelling mistakes and grammatical issues in the document.
Correct answer is: Spelling & Grammar
Q.8 In MS Excel, which chart type is best suited to show trends over time?
Pie Chart
Line Chart
Bar Chart
Scatter Chart
Explanation - Line charts are used to visualize trends over time or continuous data points in Excel.
Correct answer is: Line Chart
Q.9 What is the purpose of the 'Slide Master' in PowerPoint?
To create animations
To design consistent slide layouts and styles
To insert images
To record presentations
Explanation - Slide Master helps maintain a uniform look and feel across all slides in a PowerPoint presentation.
Correct answer is: To design consistent slide layouts and styles
Q.10 Which MS Word feature automatically completes a word or phrase as you type?
AutoCorrect
Track Changes
Mail Merge
Header & Footer
Explanation - AutoCorrect in Word automatically replaces mistyped words or phrases with correct ones as you type.
Correct answer is: AutoCorrect
Q.11 In Excel, what does the VLOOKUP function do?
Looks up values vertically in a table
Finds the maximum value
Calculates vertical alignment
Summarizes data in rows
Explanation - VLOOKUP searches for a value in the first column of a table and returns a value in the same row from another column.
Correct answer is: Looks up values vertically in a table
Q.12 Which PowerPoint view allows you to see all slides as thumbnails?
Normal View
Slide Sorter View
Reading View
Notes Page View
Explanation - Slide Sorter View displays all slides as thumbnails, making it easy to reorder or organize them.
Correct answer is: Slide Sorter View
Q.13 What does the 'Track Changes' feature in Word allow you to do?
Automatically save changes
Highlight formatting issues
Monitor edits and suggestions made by reviewers
Change font style automatically
Explanation - Track Changes allows multiple users to review and make edits, showing additions, deletions, and comments.
Correct answer is: Monitor edits and suggestions made by reviewers
Q.14 In Excel, which function calculates the average of a set of numbers?
SUM
AVERAGE
COUNT
MAX
Explanation - The AVERAGE function computes the arithmetic mean of a range of numbers in Excel.
Correct answer is: AVERAGE
Q.15 In PowerPoint, which feature allows you to insert predefined graphic elements like diagrams or flowcharts?
SmartArt
Shapes
Icons
Charts
Explanation - SmartArt provides ready-to-use graphic elements to create visually appealing diagrams, lists, and processes.
Correct answer is: SmartArt
Q.16 Which MS Word feature is used to combine letters with a database for mass mailing?
Track Changes
Mail Merge
Table of Contents
Header & Footer
Explanation - Mail Merge allows users to send personalized letters, emails, or labels to multiple recipients using a data source.
Correct answer is: Mail Merge
Q.17 Which shortcut is used to save a document in most MS Office applications?
Ctrl + S
Ctrl + P
Ctrl + O
Ctrl + N
Explanation - Ctrl + S is the standard shortcut to save a document across MS Office applications.
Correct answer is: Ctrl + S
Q.18 In Excel, which feature allows you to visually summarize data using charts and graphs without writing formulas?
Pivot Table
Conditional Formatting
Data Validation
Freeze Panes
Explanation - Pivot Tables allow users to summarize, analyze, and visualize data efficiently without manual calculations.
Correct answer is: Pivot Table
Q.19 What is the use of 'Header & Footer' in Word documents?
To insert images
To add consistent text or page numbers at the top or bottom
To create tables
To format text
Explanation - Headers and Footers allow insertion of information like page numbers, titles, or dates in a consistent manner across all pages.
Correct answer is: To add consistent text or page numbers at the top or bottom
Q.20 In PowerPoint, which feature allows you to add voice narration or background audio to slides?
Slide Show
Animations
Transitions
Insert Audio
Explanation - Insert Audio allows adding sound files for narration or background music in PowerPoint presentations.
Correct answer is: Insert Audio
Q.21 Which Excel feature helps highlight cells that meet specific conditions?
Conditional Formatting
Data Validation
Filter
Freeze Panes
Explanation - Conditional Formatting visually highlights cells based on criteria like values, text, or formulas.
Correct answer is: Conditional Formatting
Q.22 What is the maximum number of rows in Excel 2019 worksheet?
65,536
1,048,576
256
2,000,000
Explanation - Excel 2007 onwards supports up to 1,048,576 rows and 16,384 columns per worksheet.
Correct answer is: 1,048,576
Q.23 Which MS Word tool helps create automatic lists with bullets or numbers?
Paragraph Styles
Bullets and Numbering
Track Changes
Mail Merge
Explanation - Bullets and Numbering automatically formats text as a list in Word documents.
Correct answer is: Bullets and Numbering
Q.24 In Excel, which function returns the current date and time?
TODAY()
NOW()
DATE()
TIME()
Explanation - NOW() function returns the current system date and time, whereas TODAY() returns only the date.
Correct answer is: NOW()
Q.25 Which PowerPoint feature enables smooth movement from one slide to another?
Animations
Slide Transitions
Slide Master
Custom Show
Explanation - Slide Transitions add visual effects between slides to enhance presentation flow.
Correct answer is: Slide Transitions