In this video, you will use data validation to assign task owners and track the status
of each task. Data validation enables you to create a drop-down
list of possible choices within a cell. Limiting choices to a list saves time and reduces the
possibility of errors when organizing your club.
As your group organizes a club, you will use the drop-down list to track each task and
view whether it has been started, is in progress, or is finished. You will also use a drop-down
list to assign who is responsible for completing tasks.
To begin, select one group member to add data validation to the status column.
Next, type the text that you want to use to describe the different stages of your project.
Now, use the drop-down list to change the status of tasks. The data validation acts
as a checklist to ensure each task is completed on time and nothing is forgotten.
As your group continues to organize your club, update the status of each task.
Data validation can also be used when assigning task owners. The owner is the person responsible
for completing each task. Use data validation again, this time listing
each group member’s name. Add “All” to the list of names for tasks that everyone
will work on, such as brainstorming your club’s topic.
Use the drop-down list to assign an owner to each task.
Now, it’s your turn: Use data validation to update the status of
each task. And use data validation to assign an owner
to each task.