2. You are preparing a project tracker spreadsheet. Next to each project task, you need to add the name of the team member responsible. What spreadsheet tool will save you time by enabling you to create a drop-down list with team members’ names as the possible options?
1 / 1 point
Correct
Data validation can be used to add drop-down lists with predetermined options for each team member’s name.
Related Questions & Answers:
- Data and business objectives might not align for a number of reasons. Which of the following issues can prevent alignment? Select all that apply. 8. Data and business objectives might not align for a number of reasons. Which of the following issues can prevent ... Read more...
- In order to extract the five-digit postal code from North Wales, PA, what is the correct function? 4. You are working with the following selection of a spreadsheet: A B 1 Customer Address 2 Sally Stewart ... Read more...
- While verifying cleaned data, a data analyst encounters a misspelled name. Which function can they use to determine if the error is repeated throughout the dataset? 4. While verifying cleaned data, a data analyst encounters a misspelled name. Which function can they use to determine if ... Read more...
- You use a spreadsheet function to divide the text strings in Column G around the commas and put each fragment into a new, separate cell. In this example, what are the commas called? 5. Scenario 1, continued You have finished cleaning the data to ensure it is complete, correct, and relevant to the ... Read more...
- You are performing a calculation during your analysis of a dataset. Which phase of analysis are you in? 3. You are performing a calculation during your analysis of a dataset. Which phase of analysis are you in? 1 ... Read more...
- Spreadsheet cell E13 contains the text string “Database”. To return the substring “Data”, what is the correct syntax? 7. Spreadsheet cell E13 contains the text string “Database”. To return the substring “Data”, what is the correct syntax? 1 ... Read more...