Virtual Assistant MS Office 2 — Questions and Answers
Question 1: In Microsoft Word, which keyboard shortcut applies bold formatting to selected text?
- Ctrl+B (Correct answer)
- Ctrl+U
- Ctrl+I
- Ctrl+K
Correct answer: Ctrl+B
Ctrl+B toggles bold formatting on selected text.
Question 2: A client asks you to combine first and last name columns in Excel into one column. Which function works best?
- CONCATENATE or TEXTJOIN (Correct answer)
- VLOOKUP
- SUMIF
- COUNTA
Correct answer: CONCATENATE or TEXTJOIN
CONCATENATE and TEXTJOIN merge text from multiple cells into one.
Question 3: Which Outlook feature lets a VA schedule an email to be sent automatically at a future time?
- Delay Delivery (Correct answer)
- Quick Steps
- Rules
- Conditional Formatting
Correct answer: Delay Delivery
Delay Delivery holds a message and sends it at a specified date and time.
Question 4: In PowerPoint, what is the fastest way to apply a consistent look to every slide in a presentation?
- Edit the Slide Master (Correct answer)
- Change each slide manually
- Use Transitions
- Insert a SmartArt graphic
Correct answer: Edit the Slide Master
The Slide Master controls formatting for all slides at once.
Question 5: Which Excel feature freezes the header row so it stays visible while scrolling a long list?
- Freeze Panes (Correct answer)
- Wrap Text
- Merge Cells
- Group Rows
Correct answer: Freeze Panes
Freeze Panes keeps selected rows or columns visible during scrolling.
Question 6: What file format should a VA use to share a Word document so the recipient cannot easily edit it and formatting is preserved?
- PDF (Correct answer)
- TXT
- CSV
- RTF
Correct answer: PDF
PDF preserves layout and is not easily editable by the recipient.
Question 7: In Excel, which symbol must begin every formula?
- = (equals sign) (Correct answer)
- + (plus sign)
- @ (at sign)
- # (hash sign)
Correct answer: = (equals sign)
Every Excel formula starts with an equals sign.
Virtual Assistant MS Office 2
In Microsoft Word, which keyboard shortcut applies bold formatting to selected text?