Virtual Assistant MS Office 5

Question 1

A VA notices duplicate client entries in an Excel list. Which feature removes them quickly?

Accepted Answer

Remove Duplicates

Answer

Remove Duplicates deletes repeated rows based on selected columns.

Question 2

In Word, which feature lets a VA insert reusable blocks of text like a standard email signature?

Accepted Answer

Quick Parts / AutoText

Answer

Quick Parts and AutoText store reusable content snippets for fast insertion.

Question 3

Which Outlook tool helps a VA find an open meeting time across several attendees' calendars?

Accepted Answer

Scheduling Assistant

Answer

Scheduling Assistant displays attendees' availability to find a common free slot.

Question 4

In Excel, the IF function is used to:

Accepted Answer

Return one value if a condition is true and another if false

Answer

IF evaluates a condition and returns different results based on the outcome.

Question 5

A VA wants a PowerPoint object to fly in when clicked during the presentation. Which feature does this?

Accepted Answer

Animations

Answer

Animations control how individual objects appear or move on a slide.

Virtual Assistant Practice Test