GMetrix Exam Microsoft Office Skills

Question 1

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

Accepted Answer

Ctrl+S

Answer

Ctrl+P

Answer

Ctrl+Z

Answer

Ctrl+C

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

Combining email accounts

Answer

Merging two Word documents

Answer

Sending emails through Word

Question 3

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

Accepted Answer

=AVERAGE()

Answer

=SUM()

Answer

=COUNT()

Answer

=MEAN()

Question 4

What is a pivot table in Excel?

Accepted Answer

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

Answer

A table that rotates on screen

Answer

A table with fixed headers

Answer

A table that cannot be edited

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

Creating the first slide only

Answer

Adding animations

Answer

Printing handouts

Question 6

What does the VLOOKUP function do in Excel?

Accepted Answer

Searches for a value in the first column of a range and returns a value from a specified column in the same row

Answer

Looks up values vertically in the same column

Answer

Validates data entry

Answer

Counts visible cells