Challenger App

No.1 PSC Learning App

1M+ Downloads
What is the purpose of Data Validation in Excel?

ATo automatically fill cells with data

BTo restrict the type of data that can be entered into a cell

CTo create complex formulas

DTo format cells with different styles

Answer:

B. To restrict the type of data that can be entered into a cell

Read Explanation:

Excel offers various criteria for data validation:

  • Whole Numbers: Allows only integer values within a specified range (e.g., between 1 and 100).

  • Decimal Numbers: Permits decimal values within a defined range.

  • List: Restricts entry to a predefined list of items. This is often used for dropdown menus, ensuring users select from approved options.

  • Date: Validates that the entered data is a date and falls within a specified range (e.g., after 01/01/2023).

  • Time: Ensures that the entered data is a valid time and falls within a specified range.

  • Text Length: Limits the number of characters that can be entered (e.g., exactly 10 characters for a phone number).

  • Custom (Formula-based): Allows users to create complex validation rules using Excel formulas.


Related Questions:

Which shortcut can be used to create a new workbook in Excel?
You can group noncontiguous worksheets with
Worksheet protection option is available on which menu in Microsoft excel ?
Address of the first cell in the work sheet is:
The shortcut key used to 'Goto' tab in excel is .....