

Excel Dropdown Lists Quiz
Interactive Video
•
Computers
•
6th - 8th Grade
•
Practice Problem
•
Easy
Jennifer Brown
Used 1+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which tab in Excel contains the data validation option?
Home
Insert
Data
View
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What tool in Excel allows you to copy formatting from one cell to another?
Cell Styles
Conditional Formatting
Data Validation
Format Painter
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
29 questions
Alg. 1 Section 5.1 Coordinate Plane
Quiz
•
9th Grade
22 questions
fractions
Quiz
•
3rd Grade
11 questions
FOREST Effective communication
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade