Excel Dropdown Lists Quiz

What is the first step in creating a dropdown list in Excel?

• Insert a table

• Go to the Home tab

• Type the list items directly into the cell

• Select the cell where the list will appear

Which tab in Excel contains the data validation option?

• Home

• Insert

• Data

• View

How can you modify an existing dropdown list to add a new item?

• Delete the cell and start over

• Use the data validation option to edit the list

• Recreate the list from scratch

• Change the cell format

What tool in Excel allows you to copy formatting from one cell to another?

• Cell Styles

• Conditional Formatting

• Data Validation

• Format Painter

What is a quick way to apply the same formatting to multiple cells?

• Use the format painter and double-click it

• Use conditional formatting

• Manually format each cell

• Copy and paste the cell

How can you create a dropdown list that references cells from another worksheet?

• Type the values manually

• Copy and paste the values

• Use a pivot table

• Use the data validation feature to reference the cells

What is the benefit of turning a list into a table for dropdown lists?

• It changes the font style

• It makes the list appear in bold

• It automatically updates the list when items are added or removed

• It locks the list from editing

What should you do if a dropdown list does not automatically update with new items?

• Change the font size

• Use a different worksheet

• Recreate the list

• Convert the list to a table

How can you allow users to input a custom value in a dropdown list?

• Use a macro

• Change the cell color

• Disable the error alert option

• Enable the error alert option

What feature allows a dropdown list to change based on another list's selection?

• Cell linking

• Data validation

• Conditional formatting

• Dependent dropdown lists