Virtual Assistant MS Office 3 — Questions and Answers
Question 1: A VA needs to track changes made to a shared Word contract. Which feature should be enabled?
- Track Changes (Correct answer)
- Read Aloud
- Translate
- Word Count
Correct answer: Track Changes
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?
- AVERAGE (Correct answer)
- MEDIAN
- MODE
- COUNT
Correct answer: AVERAGE
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?
- Hide recipients' addresses from each other (Correct answer)
- Add a subject line
- Attach a file
- Set message priority
Correct answer: Hide recipients' addresses from each other
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?
- Slide Sorter (Correct answer)
- Reading View
- Normal View
- Presenter View
Correct answer: Slide Sorter
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?
- Sparklines (Correct answer)
- Conditional Formatting
- Data Validation
- Pivot Table
Correct answer: Sparklines
Sparklines are mini charts that fit inside a single cell.
Question 6: Which keyboard shortcut undoes the last action in most MS Office applications?
- Ctrl+Z (Correct answer)
- Ctrl+Y
- Ctrl+P
- Ctrl+S
Correct answer: Ctrl+Z
Ctrl+Z reverses the most recent action.
Question 7: In Word, which feature automatically generates a clickable list of headings at the start of a long document?
- Table of Contents (Correct answer)
- Footnotes
- Bibliography
- Index
Correct answer: Table of Contents
Table of Contents builds a navigable list from heading styles.
Virtual Assistant MS Office 3
A VA needs to track changes made to a shared Word contract.
Which feature should be enabled?