Question 2Which item under Allow in the Data Validation dialog do you need to choose to use a formula in your validation?(One or more correct answers are possible. Partial credit will be awarded).1 pointAny valueFormulaListCustom

Question 2'Any Value' in the Data Validation dialog means 'No Validation'.1 pointTrueFalse

Which of these form-field labels are necessary? Select all that apply. 1 pointFail feedbackOptional Required

Which of the following statements are true for Pivot Tables?(Multiple answers possible. Partial credit awarded)1 pointYou can use a text field in the Values area

Using a suitable example, explain in detail four levels of validation.

It is best to have most data validation in Tables rather than forms because ___________________.Group of answer choicesAll the answers are correctdata validation is only required in tabledata validation rules in tables are automatically enforced in formsdata validation does not affect forms so no need to do data validation on forms