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

Data entry speed is typically measured in keystrokes per hour (KPH) to account for all typed characters, not just words.

Question 2

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

Accepted Answer

CSV

Answer

CSV (Comma-Separated Values) is the standard format for transferring structured data between applications because it is plain text and universally supported.

Question 3

What does 'data validation' accomplish in a spreadsheet?

Accepted Answer

It restricts cell input to specific types or ranges

Answer

Data validation rules prevent incorrect data from being entered by restricting cell input to defined types, lists, or numeric ranges.

Question 4

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

Accepted Answer

Double-entry verification

Answer

Double-entry verification requires the same data to be entered twice and compared, catching discrepancies before they are saved.

Question 5

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

Accepted Answer

Fills down (copies the cell above into selected cells)

Answer

Ctrl+D copies the content and format of the topmost selected cell downward into the cells below, speeding up repetitive data entry.

Virtual Assistant Practice Test

Virtual Assistant Practice Test

Virtual Assistant Virtual Assistant Data Entry and Research Skills