_____ is used to prevent invalid data from being entered into cell.
AData validation
Bwhat if analysis
CConsolidate
DProofing
AData validation
Bwhat if analysis
CConsolidate
DProofing
Related Questions:
Filter in MS-Excel is used for
i. Calculating formulas
ii. Extracting data that meets the defined criteria
iii. Sorting data in ascending/descending order
iv. Analyzing and managing relevant data