Virtual Assistant Data Entry and Research Skills Flashcards
6 cards from real Virtual Assistant practice questions. Tap to flip, then mark Knew It or Still Learning โ missed cards come back until you master them.
Read the first 6 Virtual Assistant Data Entry and Research Skills flashcards as text
What is the standard industry measure of data entry speed?
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.
Which file format is most commonly used for exchanging tabular data between different software systems?
Answer: CSV
CSV (Comma-Separated Values) is the standard format for transferring structured data between applications because it is plain text and universally supported.
What does 'data validation' accomplish in a spreadsheet?
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.
Which technique best reduces data entry errors in high-volume tasks?
Answer: Double-entry verification
Double-entry verification requires the same data to be entered twice and compared, catching discrepancies before they are saved.
In Excel, what does the keyboard shortcut Ctrl+D do?
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.
What is a 'wildcard' character most commonly used for in database or spreadsheet searches?
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.