GMetrix Exam Microsoft Office Skills 4 — Questions and Answers
Question 1: In Word, what is the function of 'Mail Merge'?
- Combining two Word documents into one
- Sending a bulk email through Outlook
- Generating personalized documents by merging a template with a data source (Correct answer)
- Merging tracked changes from multiple reviewers
Correct answer: Generating personalized documents by merging a template with a data source
Mail Merge creates multiple personalized documents (letters, labels, envelopes) by pulling data from a spreadsheet or database.
Question 2: In Excel, what is the purpose of 'conditional formatting'?
- Automatically formatting new rows as data is entered
- Changing cell appearance based on values or rules (Correct answer)
- Locking cells so they cannot be changed
- Applying the same number format to all cells
Correct answer: Changing cell appearance based on values or rules
Conditional formatting changes the visual appearance (color, font, icons) of cells based on their values or custom rules.
Question 3: In PowerPoint, what does the 'Animation Painter' tool do?
- Copies a slide's color theme to another slide
- Copies animation effects from one object and applies them to another (Correct answer)
- Records a slideshow and saves it as a video
- Applies transitions between slides automatically
Correct answer: Copies animation effects from one object and applies them to another
Animation Painter works like Format Painter but for animations, copying effects from one object to another with one click.
Question 4: In Excel, which function looks up a value in the first column of a table and returns a value in the same row from a specified column?
- HLOOKUP
- INDEX
- VLOOKUP (Correct answer)
- MATCH
Correct answer: VLOOKUP
VLOOKUP (Vertical Lookup) searches down the first column of a range and returns the corresponding value from a specified column.
Question 5: In Outlook, what is the purpose of the 'Rules' feature?
- Setting grammar rules for spell checking
- Automatically organizing, moving, or flagging emails based on conditions (Correct answer)
- Blocking specific email addresses
- Scheduling emails to be sent at a future time
Correct answer: Automatically organizing, moving, or flagging emails based on conditions
Rules automatically perform actions (move, flag, forward, delete) on incoming or outgoing messages that meet defined criteria.
Question 6: In Word, what does 'Show/Hide' (¶) button reveal?
- Hidden text formatted as white on white
- Non-printing characters like spaces, paragraph marks, and tabs (Correct answer)
- Comments and tracked changes
- Watermarks and background elements
Correct answer: Non-printing characters like spaces, paragraph marks, and tabs
The Show/Hide button displays formatting marks such as paragraph breaks, spaces, and tabs that are normally invisible.
Question 7: In Excel, what is the difference between 'Save' and 'Save As'?
- Save creates a backup; Save As saves only the active sheet
- Save updates the existing file; Save As lets you save with a new name, format, or location (Correct answer)
- Save exports to PDF; Save As keeps the Excel format
- There is no functional difference between the two
Correct answer: Save updates the existing file; Save As lets you save with a new name, format, or location
Save overwrites the current file, while Save As allows you to specify a new file name, file type, or save location.
GMetrix Exam Microsoft Office Skills 4
In Word, what is the function of 'Mail Merge'?