GMetrix Exam Microsoft Office Skills 3 — Questions and Answers
Question 1: In Excel, which chart type is best suited for showing trends over time?
- Pie chart
- Bar chart
- Line chart (Correct answer)
- Scatter plot
Correct answer: Line chart
Line charts connect data points chronologically, making them ideal for displaying trends over time.
Question 2: In Word, what is the purpose of a 'Table of Contents'?
- To list all images in the document
- To provide navigable links to document headings and sections (Correct answer)
- To summarize the document in bullet points
- To display footnotes at the end of the document
Correct 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.
Question 3: In PowerPoint, what is the purpose of 'Slide Master'?
- To present slides in full screen
- To set a uniform layout, theme, and formatting for all slides (Correct answer)
- To add speaker notes to every slide
- To convert slides to PDF
Correct 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.
Question 4: In Excel, which of the following is a relative cell reference?
- $A$1
- A$1
- $A1
- A1 (Correct answer)
Correct answer: A1
A relative reference like A1 adjusts automatically when a formula is copied to another cell.
Question 5: In Outlook, what does 'Out of Office' (Automatic Replies) do?
- Deletes incoming emails while you are away
- Sends an automatic reply to incoming messages when you are unavailable (Correct answer)
- Forwards all emails to a colleague permanently
- Blocks all incoming emails
Correct 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.
Question 6: In Word, which feature lets you insert reusable blocks of text or content?
- Quick Parts (AutoText) (Correct answer)
- Mail Merge
- Macros
- Cross-reference
Correct answer: Quick Parts (AutoText)
Quick Parts stores and inserts reusable text, fields, or document properties with a few clicks.
Question 7: In Excel, what does the IFERROR function do?
- Prevents a formula from being entered if it contains errors
- Returns a specified value instead of an error message when a formula produces an error (Correct answer)
- Highlights cells containing errors in red
- Deletes rows that produce formula errors
Correct 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.
GMetrix Exam Microsoft Office Skills 3
In Excel, which chart type is best suited for showing trends over time?