Skip to main content
Course

Drop-down list exercises

Five exercises, from a Yes/No list to a full ticket log. Each sheet is checked instantly, with a hint and the explanation if you get stuck.

Read the drop-down list guide

Exercise 1 of 5

A Yes/No list typed by hand

Select B2:B7, open Data Validation, set Allow to List and type the Source Yes,No. Then try the arrow that appears in the cells.

GuestAttending?
Olivia Reed
James Carter
Sofia Patel
Liam Brooks
Emma Hughes
Noah Bennett