MOS Certification- Updated Question
and Answers [100% Correct] 2025/2026
Explain how to create and apply a cell style in Excel.
Select the cells, go to the "Home" tab, click on "Cell Styles," choose a pre-defined style or create a
new one by modifying an existing style.
Describe the process of inserting a page break in Word.
Place the cursor where the break is needed, go to the "Layout" or "Page Layout" tab, and click on
"Breaks" to select "Page Break."
How do you apply conditional formatting based on text in Excel?
Highlight the range, go to "Home" > "Conditional Formatting" > "New Rule," select "Format only
cells that contain," specify the text, and choose a format.
Outline the steps to create a chart in Excel.
Highlight the data range, go to the "Insert" tab, select the desired chart type, and customize using
the Chart Tools.
How do you create a custom table style in Word?
Select a table, go to "Table Design" > "Table Styles," click "New Table Style," customize
formatting, and save it for future use.
Explain how to protect a worksheet with a password in Excel.
Go to the "Review" tab, click "Protect Sheet," set restrictions, enter a password, and confirm the
password.
What is the process for linking an Excel table to a Word document?
Copy the Excel table, go to the Word document, use "Paste Special," select "Link" and choose the
format, ensuring dynamic updates.
1
, Describe how to insert a table of contents in Word.
Place the cursor, go to the "References" tab, click "Table of Contents," and choose a style or
customize.
Explain how to filter data in Excel.
Select the data range, go to the "Data" tab, click "Filter," and use dropdown arrows in headers to
set criteria.
How can you track changes in a Word document?
Go to the "Review" tab, enable "Track Changes," make edits, and use "Accept" or "Reject" to
finalize.
What steps are needed to create a pivot table in Excel?
Select the data, go to the "Insert" tab, click "PivotTable," choose placement, and configure rows,
columns, and values.
How do you add a header or footer in Word?
Go to the "Insert" tab, click "Header" or "Footer," choose a style, and add custom text or fields
like page numbers.
Explain how to create a mail merge in Word.
Go to the "Mailings" tab, select "Start Mail Merge," choose a document type, connect to a data
source, insert merge fields, and complete.
How do you group objects in PowerPoint?
Select multiple objects, right-click, and choose "Group" or use the "Arrange" option on the
"Home" tab.
What is the process for sorting data in Excel by multiple criteria?
2
