Virtual Assistant MS Office 2

Question 1

In Microsoft Word, which keyboard shortcut applies bold formatting to selected text?

Accepted Answer

Ctrl+B

Answer

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?

Accepted Answer

CONCATENATE or TEXTJOIN

Answer

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?

Accepted Answer

Delay Delivery

Answer

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?

Accepted Answer

Edit the Slide Master

Answer

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?

Accepted Answer

Freeze Panes

Answer

Freeze Panes keeps selected rows or columns visible during scrolling.

Virtual Assistant Practice Test