Test - 12 Data Validation

Where is the Data Validation button located?

• In the right-click context menu.

• On the Data tab.

• On the Home tab.

• On the Formula tab.

'Any Value' in the Data Validation dialog means 'No Validation'.

• True

• False

Using Data Validation, which option can assist the user to enter valid data by showing a message beside the cell?

• 'Error Message' under the Input Message tab.

• 'Error Message' under the Settings tab.

• 'Input Message' under the Settings tab.

• 'Input Message' under the Input Message tab.

The error alert style 'Stop' will deliver a warning message to users when they attempt to enter invalid data. User can decide whether or not to enter the intended data anyway.

• True

• False

After applying Data Validation to existing data, any invalid data will be fixed automatically.

• True

• False

Which should be selected under the Settings tab of the Data Validation dialog if the numbers 100, 200, 300, 400, 500 are allowed to be entered in a cell?

• 'Any Value' under the Allow options.

• 'Decimal' under the Allow options.

• 'Whole Number' under the Allow options.

• 'Text Length' under the Allow options.

"Enter a value that is between 0 and 0.03 (inclusive)."

Based on the input message above, which validation criteria are correct?

• Allow: Decimal

  Data: Between

  Minimum: 0

  Maximum: 0.03

• Allow: Any value

  Data: Between

  Minimum: 0

  Maximum: 0.03

• Allow: Whole Number

  Data: Between

  Minimum: 0

  Maximum: 0.03

• Allow: Decimal

  Data: Less than

  Maximum: 0.03

Based on the Validation Criteria in the screenshot, what can you expect to see in your Drop-down list?

• Accepted

  Under Review

  Rejected

  On Hold

• accepted

  Under review

  Rejected

  on Hold

• accepted

  on Hold

  Rejected

  Under review

The values that appear in a drop-down list will always appear in alphabetical order.

• True

• False

What is the advantage of converting your lookup list into a named range and table?

• The advantage is that there is no need to update the validation criteria as the look-up list changes.

• The advantage is that the drop-down list will automatically appear in alphabetical order.

• There is no particular advantage in doing this.