CES Data Validation & Error Handling Flashcards
6 cards from real CES practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 CES Data Validation & Error Handling flashcards as text
How do you copy Data Validation rules from one cell to another in Excel?
Answer: Copy the cell, then Paste Special > Validation
Paste Special with the Validation option pastes only the validation rules without overwriting the destination cell's data.
The #NAME? error in Excel most commonly occurs when:
Answer: A function name is misspelled or a named range doesn't exist
#NAME? indicates Excel cannot recognize the text in a formula, usually due to a typo in a function name or an undefined named range.
Which function checks whether a cell is blank?
Answer: ISBLANK
ISBLANK is the Excel function that returns TRUE if the referenced cell is empty and contains no data.
In Data Validation, which data type option is best for ensuring only dates within a range are accepted?
Answer: Date
The Date option in Data Validation allows you to restrict entries to valid dates and apply between/before/after conditions.
What is a circular reference in Excel?
Answer: A formula that references its own cell directly or indirectly
A circular reference occurs when a formula refers back to its own cell, either directly or through a chain of references.
Which Excel auditing tool draws arrows showing which cells feed into a selected formula cell?
Answer: Trace Precedents
Trace Precedents draws blue arrows from all cells that directly or indirectly supply values to the selected formula cell.