MOS (Microsoft Office Specialist) Mock
Certification Exam *Q&A* (100% Correct)
2025/2026 |VERIFIED|
What steps would you take to quickly remove all formatting from a cell in Excel?
Select the cell or range, go to the "Home" tab, and click "Clear" in the Editing group, then choose
"Clear F...
MOS (Microsoft Office Specialist) Mock
Certification Exam *Q&A* (100% Correct)
2025/2026 |VERIFIED|
What steps would you take to quickly remove all formatting from a cell in Excel?
Select the cell or range, go to the "Home" tab, and click "Clear" in the Editing group, then choose
"Clear Formats."
How can you change the page background color in Word?
Go to the "Design" tab, click "Page Color," and choose a color from the color palette or select
"More Colors" for additional options.
What is the purpose of the "Freeze Panes" feature in Excel?
The "Freeze Panes" feature allows you to keep specific rows or columns visible while scrolling
through large datasets.
How do you apply a custom number format in Excel?
Select the cells you want to format, right-click and choose "Format Cells," then go to the
"Number" tab and select "Custom" to enter your custom format.
How can you insert a text box in PowerPoint?
Go to the "Insert" tab, click "Text Box," and click anywhere on the slide to start typing.
How can you quickly select an entire column in Excel?
Click on the column letter at the top of the worksheet, or use the keyboard shortcut "Ctrl +
Spacebar."
How do you create a multi-level list in Word?
Highlight the text you want to include in the list, go to the "Home" tab, and click the "Multilevel
List" button to choose a style.
1
, What is the difference between a line chart and a bar chart in Excel?
A line chart displays trends over time using a series of data points connected by lines, while a bar
chart uses rectangular bars to represent data values.
How do you lock cells to prevent editing in Excel?
Select the cells you want to protect, go to the "Review" tab, click "Protect Sheet," and set a
password to prevent editing.
How can you insert a picture into a Word document?
Go to the "Insert" tab, click "Pictures," and choose whether to insert a picture from your
computer or online.
How do you use the SUM function in Excel to add a range of numbers?
Type "=SUM(" and select the range of cells you want to add, then close the parentheses and
press "Enter."
What is the purpose of the "Format Painter" tool in Word and Excel?
The "Format Painter" tool allows you to copy formatting from one part of a document or
worksheet and apply it to another section.
How can you add an automatic page break in Word?
Word automatically adds page breaks when the content exceeds one page, but you can manually
insert one by pressing "Ctrl + Enter."
What does the "COUNTIF" function do in Excel?
The COUNTIF function counts the number of cells in a range that meet a specified condition or
criteria.
How do you change the alignment of text in Word?
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 or Stuvia-credit 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 $9.20. You're not tied to anything after your purchase.
