MICROSOFT OFFICE SPECIALIST EXAM
FLASHCARDS 100% CORRECT *Q&A*
2024/2025
What is the keyboard shortcut to bold selected text in Microsoft Word?
Ctrl + B
How can you add a header in Excel?
Go to the "Insert" tab, click "Header & Footer," and choose a header style.
In PowerPoint, how do...
MICROSOFT OFFICE SPECIALIST EXAM
FLASHCARDS 100% CORRECT *Q&A*
2024/2025
What is the keyboard shortcut to bold selected text in Microsoft Word?
Ctrl + B
How can you add a header in Excel?
Go to the "Insert" tab, click "Header & Footer," and choose a header style.
In PowerPoint, how do you change the slide layout?
Click on the "Home" tab, then choose "Layout" from the Slide section.
Which formula would you use in Excel to calculate the sum of a range of cells from A1 to A10?
=SUM(A1:A10)
In Microsoft Word, how can you quickly insert a page break?
Press Ctrl + Enter.
How can you remove a hyperlink in Excel?
Right-click the hyperlink, then select "Remove Hyperlink."
What is the purpose of the "Paste Special" function in Excel?
It allows you to paste specific attributes of copied data, such as values, formats, or formulas.
How do you insert a chart in Excel?
Select the data, go to the "Insert" tab, and choose the chart type from the Charts group.
1
,In PowerPoint, how can you add transitions between slides?
Go to the "Transitions" tab, select a transition effect, and apply it to the slides.
What is the function of the "Wrap Text" option in Excel?
It allows text within a cell to be displayed on multiple lines if it is too long to fit in one.
How can you create a new slide in PowerPoint using the keyboard shortcut?
Press Ctrl + M.
What does the "Freeze Panes" feature do in Excel?
It keeps a specific row or column visible while you scroll through the rest of the spreadsheet.
In Word, how do you insert a footnote?
Go to the "References" tab and click on "Insert Footnote."
How can you change the font size in Excel?
Select the cells, go to the "Home" tab, and adjust the font size in the Font group.
In PowerPoint, how do you animate text or objects on a slide?
Select the text or object, go to the "Animations" tab, and choose an animation style.
What is the default file extension for a Word 2016 document?
.docx
In Excel, how do you create a hyperlink to a website?
Select a cell, press Ctrl + K, and enter the URL.
What is the purpose of the "Conditional Formatting" feature in Excel?
2
, It allows you to format cells based on certain conditions or criteria, such as changing cell color
when a value meets specific thresholds.
How do you insert a table in Word?
Go to the "Insert" tab and click "Table," then select the desired number of rows and columns.
In PowerPoint, how do you insert a video from your computer?
Go to the "Insert" tab, click "Video," then select "Video on my PC."
How do you use the "VLOOKUP" function in Excel?
The VLOOKUP function is used to search for a value in the first column of a range and return a
value in the same row from a specified column.
What is the purpose of the "Track Changes" feature in Word?
It allows you to track edits made to a document, showing additions, deletions, and comments.
How can you remove duplicates in Excel?
Select the data, go to the "Data" tab, and click "Remove Duplicates."
What is the function of the "Sum" button in Excel's Quick Access Toolbar?
It automatically inserts a SUM formula to add the values of the selected cells.
How do you merge cells in Excel?
Select the cells, right-click, and choose "Merge Cells" from the context menu.
What is the default font used in Microsoft Word 2016?
Calibri
In PowerPoint, how do you add a new slide with a specific layout?
3
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.50. You're not tied to anything after your purchase.
