GMetrix Exam Microsoft Office Skills 2 — Questions and Answers
Question 1: In Excel, which function returns the number of cells in a range that meet a specific condition?
- SUMIF
- COUNTIF (Correct answer)
- AVERAGEIF
- VLOOKUP
Correct answer: COUNTIF
COUNTIF counts the number of cells within a range that meet a given criterion.
Question 2: In Word, what does the 'Track Changes' feature do?
- Saves a backup copy of the document
- Records all edits made to the document so they can be reviewed (Correct answer)
- Automatically corrects spelling errors
- Locks the document from further editing
Correct 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.
Question 3: In PowerPoint, which view shows all slides as small thumbnails in a grid for easy reordering?
- Normal View
- Reading View
- Slide Sorter View (Correct answer)
- Presenter View
Correct answer: Slide Sorter View
Slide Sorter View displays all slides as thumbnails, making it easy to rearrange the presentation order.
Question 4: In Excel, what is the keyboard shortcut to apply the SUM function to a selected range?
- Ctrl+S
- Alt+= (Correct answer)
- Ctrl+M
- Shift+F5
Correct answer: Alt+=
Alt+= (AutoSum) automatically inserts a SUM formula for the adjacent range.
Question 5: In Outlook, what does the 'BCC' field do when sending an email?
- Sends a copy to recipients whose addresses are hidden from other recipients (Correct answer)
- Blocks the recipient from replying
- Creates a backup copy in the Drafts folder
- Marks the message as high priority
Correct 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.
Question 6: In Word, the 'Styles' feature is primarily used to do what?
- Insert clip art into the document
- Apply consistent formatting throughout the document (Correct answer)
- Check grammar and spelling
- Add page borders
Correct answer: Apply consistent formatting throughout the document
Styles apply predefined or custom formatting sets (font, size, spacing) consistently across a document.
Question 7: In Excel, what is a 'named range'?
- A range formatted with a specific color
- A cell range assigned a descriptive name for use in formulas (Correct answer)
- A range that spans multiple worksheets
- A locked range that cannot be edited
Correct 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.
GMetrix Exam Microsoft Office Skills 2
In Excel, which function returns the number of cells in a range that meet a specific condition?