
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 11 - data validation
Interactive Video
•
Information Technology (IT), Architecture
•
University
•
Practice Problem
•
Hard
Wayground Content
FREE Resource
Read more
7 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to determine the length of the part number?
MID
LEN
LEFT
RIGHT
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function is used to extract the first three characters of the part number?
LEN
LEFT
MID
RIGHT
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to combine all validation checks?
NOT
IF
OR
AND
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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.
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
29 questions
Alg. 1 Section 5.1 Coordinate Plane
Quiz
•
9th Grade
22 questions
fractions
Quiz
•
3rd Grade
11 questions
FOREST Effective communication
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Information Technology (IT)
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
7 questions
Fragments, Run-ons, and Complete Sentences
Interactive video
•
4th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
10 questions
DNA Structure and Replication: Crash Course Biology
Interactive video
•
11th Grade - University
5 questions
Inherited and Acquired Traits of Animals
Interactive video
•
4th Grade - University
5 questions
Examining Theme
Interactive video
•
4th Grade - University
20 questions
Implicit vs. Explicit
Quiz
•
6th Grade - University
7 questions
Comparing Fractions
Interactive video
•
1st Grade - University