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

Spell Check

Answer

Header & Footer

Answer

Page Break Preview

Question 2

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

Accepted Answer

Rules

Answer

Signatures

Answer

Categories

Answer

Voting Buttons

Question 3

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

Accepted Answer

Mail Merge

Answer

Track Changes

Answer

Compare Documents

Answer

Smart Lookup

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

Counts blank cells

Answer

Converts text to uppercase

Answer

Sorts a column alphabetically

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

Animation Pane only

Answer

Slide Master

Answer

Design Ideas

Question 6

Which shortcut saves the current document in any MS Office app?

Accepted Answer

Ctrl+S

Answer

Ctrl+O

Answer

Ctrl+N

Answer

Ctrl+W

Question 7

In Excel, which feature highlights cells that meet a condition, such as values over 100 turning red?

Accepted Answer

Conditional Formatting

Answer

Data Validation

Answer

Flash Fill

Answer

Goal Seek