Virtual Assistant Virtual Assistant Data Entry and Research Skills 1 — Questions and Answers
Question 1: What is the standard industry measure of data entry speed?
- Words per minute (WPM)
- Keystrokes per hour (KPH) (Correct answer)
- Characters per second (CPS)
- Entries per day (EPD)
Correct answer: Keystrokes per hour (KPH)
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?
- DOCX
- CSV (Correct answer)
- PNG
Correct answer: CSV
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?
- It automatically deletes duplicate rows
- It restricts cell input to specific types or ranges (Correct answer)
- It converts the spreadsheet to a PDF
- It sorts data alphabetically
Correct answer: It restricts cell input to specific types or ranges
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?
- Single-pass entry with no review
- Auto-archiving completed records
- Double-entry verification (Correct answer)
- Batch deletion of old data
Correct answer: Double-entry verification
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?
- Deletes the selected row
- Fills down (copies the cell above into selected cells) (Correct answer)
- Opens the data validation dialog
- Duplicates the current worksheet
Correct answer: Fills down (copies the cell above into selected cells)
Ctrl+D copies the content and format of the topmost selected cell downward into the cells below, speeding up repetitive data entry.
Question 6: What is a 'wildcard' character most commonly used for in database or spreadsheet searches?
- Encrypting sensitive fields
- Representing unknown or variable characters in a search pattern (Correct answer)
- Locking cells from editing
- Flagging duplicate records
Correct answer: Representing unknown or variable characters in a search pattern
Wildcard characters such as * or ? substitute for unknown characters, allowing flexible pattern-matching searches across records.
Virtual Assistant Virtual Assistant Data Entry and Research Skills 1
What is the standard industry measure of data entry speed?