GMetrix Exam Microsoft Office Skills — Questions and Answers
Question 1: In Microsoft Word, what keyboard shortcut saves the current document?
- Ctrl+P
- Ctrl+S (Correct answer)
- Ctrl+Z
- Ctrl+C
Correct answer: Ctrl+S
Ctrl+S is the universal shortcut for saving in Microsoft Office applications. Regular saving prevents loss of work.
Question 2: What is mail merge in Microsoft Word used for?
- Combining email accounts
- Creating personalized letters, labels, or envelopes by merging a document with a data source (Correct answer)
- Merging two Word documents
- Sending emails through Word
Correct answer: Creating personalized letters, labels, or envelopes by merging a document with a data source
Mail merge connects a Word template with a data source (like an Excel list) to automatically generate personalized documents for each recipient.
Question 3: In Excel, what function calculates the average of a range of cells?
- =SUM()
- =AVERAGE() (Correct answer)
- =COUNT()
- =MEAN()
Correct answer: =AVERAGE()
The AVERAGE function calculates the arithmetic mean of the values in the specified range. For example, =AVERAGE(A1:A10) averages cells A1 through A10.
Question 4: What is a pivot table in Excel?
- A table that rotates on screen
- A data summarization tool that automatically sorts, counts, totals, or averages data (Correct answer)
- A table with fixed headers
- A table that cannot be edited
Correct answer: A data summarization tool that automatically sorts, counts, totals, or averages data
Pivot tables reorganize and summarize selected data to help users analyze patterns and trends without altering the original data.
Question 5: In PowerPoint, what is the Slide Master used for?
- Creating the first slide only
- Defining consistent formatting, fonts, colors, and layouts that apply to all slides in a presentation (Correct answer)
- Adding animations
- Printing handouts
Correct answer: Defining consistent formatting, fonts, colors, and layouts that apply to all slides in a presentation
The Slide Master controls the overall design and layout templates, ensuring consistency across all slides in the presentation.
Question 6: What does the VLOOKUP function do in Excel?
- Looks up values vertically in the same column
- Searches for a value in the first column of a range and returns a value from a specified column in the same row (Correct answer)
- Validates data entry
- Counts visible cells
Correct answer: Searches for a value in the first column of a range and returns a value from a specified column in the same row
VLOOKUP searches vertically down the first column of a range for a match, then returns the corresponding value from a specified column to the right.
GMetrix Exam Microsoft Office Skills
In Microsoft Word, what keyboard shortcut saves the current document?