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+U

Answer

Ctrl+I

Answer

Ctrl+K

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

VLOOKUP

Answer

SUMIF

Answer

COUNTA

Question 3

Which Outlook feature lets a VA schedule an email to be sent automatically at a future time?

Accepted Answer

Delay Delivery

Answer

Quick Steps

Answer

Rules

Answer

Conditional Formatting

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

Change each slide manually

Answer

Use Transitions

Answer

Insert a SmartArt graphic

Question 5

Which Excel feature freezes the header row so it stays visible while scrolling a long list?

Accepted Answer

Freeze Panes

Answer

Wrap Text

Answer

Merge Cells

Answer

Group Rows

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?

Accepted Answer

PDF

Answer

TXT

Answer

CSV

Answer

RTF

Question 7

In Excel, which symbol must begin every formula?

Accepted Answer

= (equals sign)

Answer

+ (plus sign)

Answer

@ (at sign)

Answer

# (hash sign)