Menu
Flashcards KS3 Computing Spreadsheets

Validation

Card 1 of 21 0 got it 0 still learning
Question
TapClick or press space to see the answer
Answer
All 21 cards in this set
A spreadsheet collects dates of birth from many people. Why is validation useful here?
It stops the same date being written in different ways
A cell must only allow the choices Yes or No. Which type of rule is needed?
A list of items rule
A column should allow only the single letter Y to be typed. Which text rule is needed?
Text is exactly Y
A column holds the ages of members of a club. Which number rule allows only sensible ages?
Number between 0 and 120
A hotel booking form has an arrival date. The date must not be in the past. Which rule is needed?
Date is after today
A hotel booking form has a box for the customer's email address. Which rule only allows a proper email address?
Text is a valid email
A rule is set to Reject the input. What happens when a user types data that breaks the rule?
The data cannot be entered at all
A drop-down validation rule has been added to a cell. How does the cell change?
A small arrow on the right of the cell
A validation rule that is not a drop-down is added to a cell. How does the cell look after the rule is added?
No different from before
A Notes column holds sentences written by staff. No entry may include the word absent. Which rule should be used?
Text does not contain absent
A spreadsheet records how many tickets each pupil has sold. Only numbers above 0 should be allowed. Which rule fits best?
Number greater than 0
Which term describes a spreadsheet tool that sets up rules to check data as it is entered?
Data validation
Which term describes a validation rule that turns a cell into a menu of set choices such as Single,Double,Family?
List of items
What is meant by a number rule in data validation?
A rule that only allows numbers that meet a condition
Which term describes the setting where incorrect data is still allowed but the cell is marked as invalid?
Show a warning
What is meant by a date rule in data validation?
A rule that only allows dates that meet a condition
Which text rule accepts any entry that includes a particular word or phrase?
Text contains
Which term describes data such as dates that are typed in many different ways by different people?
Inconsistent data
In a data validation rule, what is meant by the criteria?
The type of rule, such as text or number
Which term describes data that can never be true, such as an age of -10 or a date of 31 February?
Impossible data
A hotel booking form must accept bookings of between 1 and 6 guests. Which rule keeps the entries sensible?
Number between 1 and 6