Question 3You prepare a project tracker spreadsheet. Next to each project is the name of the team member responsible. What spreadsheet tool will create a drop-down list with team member names to save you time when assigning the projects?1 pointConditional formattingFindPop-up menusData validation

The spreadsheet tool that will create a drop-down list with team member names to save you time when assigning the projects is Data Validation.

Here are the steps to create a drop-down list using Data Validation in Excel:

1. First, you need to have a list of all the team member names. You can put this list on the same sheet or a different sheet.

2. Select the cell where you want the drop-down list.

3. Click on the 'Data' tab in the ribbon.

4. Then click on 'Data Validation'. A dialog box will open.

5. In the dialog box, under the 'Settings' tab, in the 'Allow' box, select 'List'.

6. In the 'Source' box, select the range of cells that contain the names of the team members.

7. Click 'OK'. Now, the selected cell will have a drop-down list of team member names.

You can copy this cell and paste it next to each project to assign team members.