GMetrix Exam Microsoft Office Skills

Question 1

In Microsoft Word, what keyboard shortcut saves the current document?

Accepted Answer

Ctrl+S

Answer

Ctrl+S is the universal shortcut for saving in Microsoft Office applications. Regular saving prevents loss of work.

Question 2

What is mail merge in Microsoft Word used for?

Accepted Answer

Creating personalized letters, labels, or envelopes by merging a document with a data source

Answer

Mail merge connects a Word template with a data source (like an Excel list) to automatically generate personalized documents for each recipient.

Question 3

In Excel, what function calculates the average of a range of cells?

Accepted Answer

=AVERAGE()

Answer

The AVERAGE function calculates the arithmetic mean of the values in the specified range. For example, =AVERAGE(A1:A10) averages cells A1 through A10.

Question 4

What is a pivot table in Excel?

Accepted Answer

A data summarization tool that automatically sorts, counts, totals, or averages data

Answer

Pivot tables reorganize and summarize selected data to help users analyze patterns and trends without altering the original data.

Question 5

In PowerPoint, what is the Slide Master used for?

Accepted Answer

Defining consistent formatting, fonts, colors, and layouts that apply to all slides in a presentation

Answer

The Slide Master controls the overall design and layout templates, ensuring consistency across all slides in the presentation.

GMetrix Exam Practice Test

GMetrix Exam Practice Test

GMetrix Exam Microsoft Office Skills