GMetrix Exam Microsoft Office Skills 5 — Questions and Answers
Question 1: In Excel, what does 'Freeze Panes' do?
- Prevents formulas from recalculating
- Locks specific rows or columns so they remain visible when scrolling (Correct answer)
- Protects a worksheet with a password
- Merges selected cells into one
Correct answer: Locks specific rows or columns so they remain visible when scrolling
Freeze Panes keeps selected rows or columns visible on screen as you scroll through a large spreadsheet.
Question 2: In PowerPoint, which option allows a presentation to loop continuously without manual advancement?
- Slide Show > Set Up Slide Show > Loop continuously until 'Esc' (Correct answer)
- Design > Slide Size > Loop
- Transitions > Apply to All > Auto-loop
- View > Presenter View > Repeat
Correct answer: Slide Show > Set Up Slide Show > Loop continuously until 'Esc'
In Set Up Slide Show, checking 'Loop continuously until Esc' makes the presentation repeat automatically.
Question 3: In Word, what is the purpose of 'Section Breaks'?
- To separate the document into multiple files
- To allow different formatting (margins, headers, columns) in different parts of a document (Correct answer)
- To insert a visual dividing line between paragraphs
- To mark the end of a chapter for the Table of Contents
Correct answer: To allow different formatting (margins, headers, columns) in different parts of a document
Section breaks divide a document into sections, each of which can have its own page orientation, margins, headers, and columns.
Question 4: In Excel, what is a PivotTable primarily used for?
- Creating interactive charts linked to external data
- Summarizing, analyzing, and rearranging large datasets interactively (Correct answer)
- Running macros on large datasets automatically
- Formatting large tables with alternating row colors
Correct answer: Summarizing, analyzing, and rearranging large datasets interactively
PivotTables let users summarize and analyze large amounts of data by dragging fields to rows, columns, and value areas.
Question 5: In Outlook, which folder stores emails that have been written but not yet sent?
- Sent Items
- Outbox
- Drafts (Correct answer)
- Junk Email
Correct answer: Drafts
The Drafts folder holds emails that have been saved but not sent, allowing you to return and finish them later.
Question 6: In Excel, which of the following best describes an 'absolute cell reference'?
- A reference that changes when the formula is copied to another cell
- A reference that always points to the same cell regardless of where the formula is copied (Correct answer)
- A reference to a cell on another worksheet
- A reference to an entire column
Correct answer: A reference that always points to the same cell regardless of where the formula is copied
An absolute reference uses dollar signs (e.g., $A$1) to lock the row and column so the reference does not change when copied.
Question 7: In Word, what does 'Accept All Changes' do when working with tracked changes?
- Deletes all comments in the document
- Accepts every tracked revision and removes all markup from the document (Correct answer)
- Saves the document with all changes highlighted
- Merges the document with the original version
Correct answer: Accepts every tracked revision and removes all markup from the document
Accept All Changes incorporates every tracked insertion and deletion into the document and removes the revision markup.
GMetrix Exam Microsoft Office Skills 5
In Excel, what does 'Freeze Panes' do?