Microsoft Office Skills Flashcards
7 cards from real GMetrix Exam practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Microsoft Office Skills flashcards as text
In Excel, which chart type is best suited for showing trends over time?
Answer: Line chart
Line charts connect data points chronologically, making them ideal for displaying trends over time.
In Word, what is the purpose of a 'Table of Contents'?
Answer: To provide navigable links to document headings and sections
A Table of Contents lists document headings with page numbers and can include hyperlinks for navigation.
In PowerPoint, what is the purpose of 'Slide Master'?
Answer: To set a uniform layout, theme, and formatting for all slides
Slide Master controls the overall design and layout so changes apply consistently across all slides in the presentation.
In Excel, which of the following is a relative cell reference?
Answer: A1
A relative reference like A1 adjusts automatically when a formula is copied to another cell.
In Outlook, what does 'Out of Office' (Automatic Replies) do?
Answer: Sends an automatic reply to incoming messages when you are unavailable
Automatic Replies sends a predefined response to incoming emails to inform senders you are temporarily unavailable.
In Word, which feature lets you insert reusable blocks of text or content?
Answer: Quick Parts (AutoText)
Quick Parts stores and inserts reusable text, fields, or document properties with a few clicks.
In Excel, what does the IFERROR function do?
Answer: Returns a specified value instead of an error message when a formula produces an error
IFERROR catches errors in a formula and returns a custom value (such as 0 or blank) instead of displaying an error.