Virtual Assistant Core Administrative Skills 4

Question 1

A client asks you to enter 300 contacts into a spreadsheet. What practice most reduces data-entry errors?

Accepted Answer

Use consistent formatting and double-check entries against the source

Answer

Type as fast as possible

Answer

Skip fields that seem unimportant

Answer

Guess missing values

Question 2

In a spreadsheet, what does the SUM function do?

Accepted Answer

Adds the values in a selected range of cells

Answer

Sorts the data alphabetically

Answer

Deletes empty rows

Answer

Counts the words in a cell

Question 3

Why is it important to save documents with clear, descriptive file names?

Accepted Answer

It makes files easy to find and avoids confusion later

Answer

It makes files load faster

Answer

It compresses the file size

Answer

It encrypts the content

Question 4

A client wants a document shared so others can comment but not edit. Which permission setting is correct?

Accepted Answer

'Can comment' (or comment-only) access

Answer

'Can edit' access

Answer

'Owner' access

Answer

No access at all

Question 5

What is the benefit of using a document template for recurring reports?

Accepted Answer

It ensures consistent structure and saves setup time

Answer

It prevents the document from being printed

Answer

It automatically writes the content

Answer

It locks the file permanently

Question 6

When proofreading a client document, which item is MOST critical to verify?

Accepted Answer

Names, dates, figures, and other factual details

Answer

The background color

Answer

The number of pages

Answer

The font's popularity

Question 7

A spreadsheet column shows '#####' instead of numbers. What is the most likely cause?

Accepted Answer

The column is too narrow to display the value

Answer

The data is corrupted

Answer

The file is locked

Answer

The formula is broken