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 function returns the number of cells in a range that meet a specific condition?
Answer: COUNTIF
COUNTIF counts the number of cells within a range that meet a given criterion.
In Word, what does the 'Track Changes' feature do?
Answer: Records all edits made to the document so they can be reviewed
Track Changes marks insertions, deletions, and formatting changes so reviewers can accept or reject them.
In PowerPoint, which view shows all slides as small thumbnails in a grid for easy reordering?
Answer: Slide Sorter View
Slide Sorter View displays all slides as thumbnails, making it easy to rearrange the presentation order.
In Excel, what is the keyboard shortcut to apply the SUM function to a selected range?
Answer: Alt+=
Alt+= (AutoSum) automatically inserts a SUM formula for the adjacent range.
In Outlook, what does the 'BCC' field do when sending an email?
Answer: Sends a copy to recipients whose addresses are hidden from other recipients
BCC (Blind Carbon Copy) sends the email to recipients without revealing their addresses to other recipients.
In Word, the 'Styles' feature is primarily used to do what?
Answer: Apply consistent formatting throughout the document
Styles apply predefined or custom formatting sets (font, size, spacing) consistently across a document.
In Excel, what is a 'named range'?
Answer: A cell range assigned a descriptive name for use in formulas
A named range assigns a meaningful label to a cell range, making formulas easier to read and maintain.