Virtual Assistant Virtual Assistant Data Entry and Research Skills

Question 1

What is the standard industry measure of data entry speed?

Accepted Answer

Keystrokes per hour (KPH)

Answer

Words per minute (WPM)

Answer

Characters per second (CPS)

Answer

Entries per day (EPD)

Question 2

Which file format is most commonly used for exchanging tabular data between different software systems?

Accepted Answer

CSV

Answer

DOCX

Answer

PDF

Answer

PNG

Question 3

What does 'data validation' accomplish in a spreadsheet?

Accepted Answer

It restricts cell input to specific types or ranges

Answer

It automatically deletes duplicate rows

Answer

It converts the spreadsheet to a PDF

Answer

It sorts data alphabetically

Question 4

Which technique best reduces data entry errors in high-volume tasks?

Accepted Answer

Double-entry verification

Answer

Single-pass entry with no review

Answer

Auto-archiving completed records

Answer

Batch deletion of old data

Question 5

In Excel, what does the keyboard shortcut Ctrl+D do?

Accepted Answer

Fills down (copies the cell above into selected cells)

Answer

Deletes the selected row

Answer

Opens the data validation dialog

Answer

Duplicates the current worksheet

Question 6

What is a 'wildcard' character most commonly used for in database or spreadsheet searches?

Accepted Answer

Representing unknown or variable characters in a search pattern

Answer

Encrypting sensitive fields

Answer

Locking cells from editing

Answer

Flagging duplicate records