MOS Certification- Updated Question and Answers [100% Correct] 2025/2026
4 views 0 purchase
Module
Microsoft
Institution
Microsoft
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 p...
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller StellarGrades. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £7.26. You're not tied to anything after your purchase.
