Which command can be set to prohibit or allow a cell entry?

Which command can be set to prohibit or allow a cell entry?

  • (A) Back ground error checking
  • (B) Data validation
  • (C) Go to special
  • (D) Evaluate formula
  • Data validation is a feature of spreadsheet programs, including Microsoft Excel, that determines the data that can be entered into a cell. With specific rules, it is possible to:
  • 1- Deny data entry (for instance, prohibit text entry in a column named "Price").
  • 2- Limit data entry to a particular data type, such as numbers, dates, or a list of values in a dropdown list.
  • 3- Display error messages when users attempt to enter invalid data.
Facebook
WhatsApp
Related MCQs:

 ‘NATO’ is an abbreviation of:

  • (A) North Atlantic Treaty Organization
  • (B) Non-Aligned Treaty Organization
  • (C) Non-Aligned Trading Organization
  • (D) North American Transport Organization

You May Like

Comment

You cannot copy content of this page

Scroll to Top