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

Text to Columns

Answer

Subtotal

Answer

Consolidate

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

Hyperlink

Answer

Cross-reference

Answer

Drop Cap

Question 3

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

Accepted Answer

Scheduling Assistant

Answer

Quick Steps

Answer

Conversation Cleanup

Answer

Junk Email Filter

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

Add a range of cells

Answer

Find the largest number

Answer

Remove extra spaces

Question 5

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

Accepted Answer

Animations

Answer

Transitions

Answer

Themes

Answer

Sections

Question 6

Which keyboard shortcut copies selected content in MS Office?

Accepted Answer

Ctrl+C

Answer

Ctrl+V

Answer

Ctrl+X

Answer

Ctrl+A

Question 7

In Word, which feature checks a document for spelling and grammar errors?

Accepted Answer

Editor / Spelling & Grammar

Answer

Thesaurus

Answer

Word Count

Answer

Read Aloud