MICROSOFT OFFICE SPECIALIST EXAM FLASHCARDS 100% CORRECT *Q&A* 2024/2025
2 vistas 0 veces vendidas
Grado
Microsoft
Institución
Microsoft
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
Los beneficios de comprar resúmenes en Stuvia estan en línea:
Garantiza la calidad de los comentarios
Compradores de Stuvia evaluaron más de 700.000 resúmenes. Así estas seguro que compras los mejores documentos!
Compra fácil y rápido
Puedes pagar rápidamente y en una vez con iDeal, tarjeta de crédito o con tu crédito de Stuvia. Sin tener que hacerte miembro.
Enfócate en lo más importante
Tus compañeros escriben los resúmenes. Por eso tienes la seguridad que tienes un resumen actual y confiable.
Así llegas a la conclusión rapidamente!
Preguntas frecuentes
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.
100% de satisfacción garantizada: ¿Cómo funciona?
Nuestra garantía de satisfacción le asegura que siempre encontrará un documento de estudio a tu medida. Tu rellenas un formulario y nuestro equipo de atención al cliente se encarga del resto.
Who am I buying this summary 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 this summary for $9.50. You're not tied to anything after your purchase.