GMetrix Exam Microsoft Office Skills 3

Question 1

In Excel, which chart type is best suited for showing trends over time?

Accepted Answer

Line chart

Answer

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

Accepted Answer

To provide navigable links to document headings and sections

Answer

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

Accepted Answer

To set a uniform layout, theme, and formatting for all slides

Answer

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?

Accepted Answer

A1

Answer

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?

Accepted Answer

Sends an automatic reply to incoming messages when you are unavailable

Answer

Automatic Replies sends a predefined response to incoming emails to inform senders you are temporarily unavailable.

GMetrix Exam Practice Test