Virtual Assistant MS Office 4

Question 1

A VA must summarize sales data by region in Excel. Which tool is most efficient?

Accepted Answer

PivotTable

Answer

A PivotTable groups and summarizes large datasets dynamically.

Question 2

In Outlook, which feature lets a VA automatically move incoming newsletters into a specific folder?

Accepted Answer

Rules

Answer

Rules automate actions like moving messages based on criteria.

Question 3

Which Word feature lets a VA send a personalized letter to many recipients using a contact list?

Accepted Answer

Mail Merge

Answer

Mail Merge pulls data from a list to personalize each copy.

Question 4

In Excel, what does the VLOOKUP function do?

Accepted Answer

Searches for a value in the first column and returns a value in the same row

Answer

VLOOKUP finds a value in a table and returns a corresponding value from the same row.

Question 5

A VA wants slides to advance automatically during a self-running presentation. Which PowerPoint setting controls this?

Accepted Answer

Slide Transition timing / Rehearse Timings

Answer

Transition timings or Rehearse Timings set how long each slide displays before advancing.

Virtual Assistant Practice Test