GMetrix Exam Microsoft Office Skills 4

Question 1

In Word, what is the function of 'Mail Merge'?

Accepted Answer

Generating personalized documents by merging a template with a data source

Answer

Mail Merge creates multiple personalized documents (letters, labels, envelopes) by pulling data from a spreadsheet or database.

Question 2

In Excel, what is the purpose of 'conditional formatting'?

Accepted Answer

Changing cell appearance based on values or rules

Answer

Conditional formatting changes the visual appearance (color, font, icons) of cells based on their values or custom rules.

Question 3

In PowerPoint, what does the 'Animation Painter' tool do?

Accepted Answer

Copies animation effects from one object and applies them to another

Answer

Animation Painter works like Format Painter but for animations, copying effects from one object to another with one click.

Question 4

In Excel, which function looks up a value in the first column of a table and returns a value in the same row from a specified column?

Accepted Answer

VLOOKUP

Answer

VLOOKUP (Vertical Lookup) searches down the first column of a range and returns the corresponding value from a specified column.

Question 5

In Outlook, what is the purpose of the 'Rules' feature?

Accepted Answer

Automatically organizing, moving, or flagging emails based on conditions

Answer

Rules automatically perform actions (move, flag, forward, delete) on incoming or outgoing messages that meet defined criteria.

GMetrix Exam Practice Test