Microsoft Excel 2021365 - Beginner to Advanced - Exercise 11 - data validation

The video tutorial covers data validation for part numbers, requiring them to be six characters long with the first three as letters and the last three as numbers. It explains how to use Excel formulas to check these conditions, convert results to true or false, and combine them using the AND function. The tutorial also demonstrates applying the validation rule to a cell and suggests adding an error message for incorrect entries.

What are the conditions for a valid part number in this exercise?

• It must be 5 characters long with any characters.

• It must be 6 characters long with the first three as letters and the last three as numbers.

• It must be 6 characters long with the first three as numbers and the last three as letters.

• It must be 8 characters long with any characters.

Which function is used to determine the length of the part number?

• MID

• LEN

• LEFT

• RIGHT

How do you convert the length check into a logical formula?

• By using the OR function.

• By checking if the length is equal to six.

• By using the AND function.

• By using the IF function.

What function is used to extract the first three characters of the part number?

• LEN

• LEFT

• MID

• RIGHT

How do you ensure the first three characters are letters?

• By using the AND function.

• By using the VALUE function directly.

• By using the NOT function with ISNUMBER.

• By using the ISNUMBER function directly.

Which function is used to combine all validation checks?

• NOT

• IF

• OR

• AND

What is the final step after creating the validation formula?

• Email the formula to a colleague.

• Save the formula in a text file.

• Apply it to a cell using data validation.

• Print the formula for reference.