Virtual Assistant MS Office 3

Question 1

A VA needs to track changes made to a shared Word contract. Which feature should be enabled?

Accepted Answer

Track Changes

Answer

Track Changes records all edits so they can be reviewed and accepted or rejected.

Question 2

Which Excel function returns the average of a range of numbers?

Accepted Answer

AVERAGE

Answer

AVERAGE calculates the arithmetic mean of the supplied values.

Question 3

In Outlook, what is the purpose of the BCC field when emailing a list of clients?

Accepted Answer

Hide recipients' addresses from each other

Answer

BCC sends the email without revealing those addresses to other recipients.

Question 4

Which PowerPoint view is best for rearranging the order of slides quickly?

Accepted Answer

Slide Sorter

Answer

Slide Sorter shows thumbnails so slides can be dragged into a new order.

Question 5

A VA wants to turn a column of numbers in Excel into a quick visual chart. Which feature creates a tiny in-cell chart?

Accepted Answer

Sparklines

Answer

Sparklines are mini charts that fit inside a single cell.

Virtual Assistant Practice Test