GMetrix Exam Microsoft Office Skills 5

Question 1

In Excel, what does 'Freeze Panes' do?

Accepted Answer

Locks specific rows or columns so they remain visible when scrolling

Answer

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?

Accepted Answer

Slide Show > Set Up Slide Show > Loop continuously until 'Esc'

Answer

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'?

Accepted Answer

To allow different formatting (margins, headers, columns) in different parts of a document

Answer

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?

Accepted Answer

Summarizing, analyzing, and rearranging large datasets interactively

Answer

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?

Accepted Answer

Drafts

Answer

The Drafts folder holds emails that have been saved but not sent, allowing you to return and finish them later.

GMetrix Exam Practice Test