All of the Following Statements Are TRUE About Data Validation

question 100

Multiple Choice

All of the following statements are TRUE about data validation EXCEPT:

• A)An Error Message appears when a user makes a validated cell active and prompts a user before data is entered with information about data constraints.
• B)Each of the validation criteria can be specified with an Input Message and/or an Error Alert.
• C)Data validation restricts a single validation criteria per cell.
• D)Custom validation can be used to apply multiple validation criteria to a cell, but the formulas required tend to be much more complex.

---

Definitions:

Body Fluids

Liquids within humans and other living organisms that include blood, saliva, semen, and lymph, responsible for transporting nutrients, oxygen, and waste products.

Germicidal Soap

A type of soap containing agents that kill germs and bacteria, commonly used in healthcare settings to prevent infection.

Household Bleach

A common cleaning and disinfecting agent made primarily of sodium hypochlorite, used in homes to sanitize surfaces and fabrics.

Cleaning Surfaces

The act of removing dirt, dust, or other impurities from surfaces to maintain hygiene and reduce the spread of infection.