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

Read Aloud

Answer

Translate

Answer

Word Count

Question 2

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

Accepted Answer

AVERAGE

Answer

MEDIAN

Answer

MODE

Answer

COUNT

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

Add a subject line

Answer

Attach a file

Answer

Set message priority

Question 4

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

Accepted Answer

Slide Sorter

Answer

Reading View

Answer

Normal View

Answer

Presenter View

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

Conditional Formatting

Answer

Data Validation

Answer

Pivot Table

Question 6

Which keyboard shortcut undoes the last action in most MS Office applications?

Accepted Answer

Ctrl+Z

Answer

Ctrl+Y

Answer

Ctrl+P

Answer

Ctrl+S

Question 7

In Word, which feature automatically generates a clickable list of headings at the start of a long document?

Accepted Answer

Table of Contents

Answer

Footnotes

Answer

Bibliography

Answer

Index