Skip to content
Exercise 1
I want to bring in all of our team information so I can reference it.
Reveal Answer
Row
Team
Motto
Dog Team
Dog Team
Will sit for treats
Cat Team
Cat Team
Birds are yummy
Bird Team
Bird Team
Nest building is our thing
Squirrel Team
Squirrel Team
We climb trees
There are no rows in this table
Exercise 2
I want every team to have access to their tasks, but I don’t want them to see the other team’s work.
Reveal Answer
Row
Project
Owning Team
Budget
Progress
Play area improvements
Play area improvements
Dog Team
$9.00
Kibble Review
Kibble Review
Dog Team
$500.00
There are no rows in this table
Exercise 3
I want to use the project information in a task table.
Reveal Answer
Project
Task
Complete?
Play area improvements
4
Evaluate tennis ball vendors
Paint fences
Bring your kong program
Paw washing station
Kibble Review
2
Create kibble shortlist
Schedule taste test
Exercise 4
I want to update our progress in the source doc from our team doc.
Reveal Answer
Row
Project
Owning Team
Budget
Progress
Update Progress
Play area improvements
Play area improvements
Dog Team
$9.00
Update progress
Kibble Review
Kibble Review
Dog Team
$500.00
Update progress
There are no rows in this table
Project
Task
Complete?
Play area improvements
4
Evaluate tennis ball vendors
Paint fences
Bring your kong program
Paw washing station
Kibble Review
2
Create kibble shortlist
Schedule taste test
Exercise 5
I want to add new projects to our source doc.
Reveal Answer
Proposed project
Team
Why we should do it
Budget
Fund project
Cat Alliance
Dog Team
We’re better together!
$640.00
Fund project
Birdcall Training
Bird Team
We’d like to learn from each other
$1,500.00
Fund project
Nut Nutrition Education
Squirrel Team
Are peanuts healthy?
$4,000.00
Fund project
There are no rows in this table
Exercise 6
When projects complete, I want to delete a row in the source doc for the project.
Reveal Answer
Row
Project
Owning Team
Budget
Progress
Archive Project
Play area improvements
Play area improvements
Dog Team
$9.00
Archive Project
Kibble Review
Kibble Review
Dog Team
$500.00
Archive Project
There are no rows in this table
Exercise 7
I want to push a button that notifies our project leads with a request for more budget.
Reveal Answer
Row
Project
Owning Team
Budget
Progress
Request more budget
Update Progress
Play area improvements
Play area improvements
Dog Team
$9.00
Request more budget
Update progress
Kibble Review
Kibble Review
Dog Team
$500.00
Request more budget
Update progress
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.