MS Office Flashcards
7 cards from real Virtual Assistant practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 MS Office flashcards as text
A VA must summarize sales data by region in Excel. Which tool is most efficient?
Answer: PivotTable
A PivotTable groups and summarizes large datasets dynamically.
In Outlook, which feature lets a VA automatically move incoming newsletters into a specific folder?
Answer: Rules
Rules automate actions like moving messages based on criteria.
Which Word feature lets a VA send a personalized letter to many recipients using a contact list?
Answer: Mail Merge
Mail Merge pulls data from a list to personalize each copy.
In Excel, what does the VLOOKUP function do?
Answer: Searches for a value in the first column and returns a value in the same row
VLOOKUP finds a value in a table and returns a corresponding value from the same row.
A VA wants slides to advance automatically during a self-running presentation. Which PowerPoint setting controls this?
Answer: Slide Transition timing / Rehearse Timings
Transition timings or Rehearse Timings set how long each slide displays before advancing.
Which shortcut saves the current document in any MS Office app?
Answer: Ctrl+S
Ctrl+S saves the active file.
In Excel, which feature highlights cells that meet a condition, such as values over 100 turning red?
Answer: Conditional Formatting
Conditional Formatting changes cell appearance based on rules.