1. A spreadsheet collects dates of birth from many people. Why is validation useful here?
It stops the same date being written in different ways
It puts the dates into order from oldest to newest
It changes a date that is typed wrongly into the right one
It works out each person's age from their date of birth
2. A cell must only allow the choices Yes or No. Which type of rule is needed?
A text rule that is exactly Yes
A date rule set to after today
A number rule between 0 and 1
A list of items rule