All Subjects Topic Wise MCQs
PPSC Papers (All Departments)
OTHERS Past Papers FPSC, NTS etc.
Which feature is used to control what type of data can be entered into a cell?

Which feature is used to control what type of data can be entered into a cell?

  • (A) Error checking
  • (B) Data validation
  • (C) Go to special
  • (D) Evaluate formula
You can use Data Validation in Microsoft Excel as a way of controlling/restricting what types of data users may enter into a cell. Through this function, Data Validation allows you to define multiple rules, for example, allowing only whole numbers in a certain range; allowing only specific date(s); or allowing only selection(s) from a list of items defined by you on a drop down list. If a user attempts to enter a datum that does not fit into the criteria you have predefined, then you can have Excel prohibit that entry completely or give the user a warning message.
Facebook
WhatsApp
Related MCQs:

 ‘NATO’ is an abbreviation of:

March 18, 2026 No Comments
  • (A) North Atlantic Treaty Organization
  • (B) Non-Aligned Treaty Organization
  • (C) Non-Aligned Trading Organization
  • (D) North American Transport Organization

You May Like

Comment

All Subjects

PPSC PAST PAPERS

PPSC

SPSC PAST PAPERS

FPSC PAST PAPERS

KKPSC PAST PAPERS

You cannot copy content of this page

Scroll to Top