2. Scenario 1, continued
You notice that many cells in the city column, Column K, are missing a value. So, you use the zip codes to research the correct cities. Now, you want to add the cities to each donor’s row. However, you are concerned about making a mistake, such as a spelling error.
What spreadsheet tool can you use to add a drop-down list with predetermined options for each city name?
1 / 1 point
Correct
You use data validation to add drop-down lists with predetermined options for each city name. This allows you to control what can and cannot be entered in your worksheet.
Related Questions & Answers:
- Next, you create a slideshow, which includes a data visualization to highlight the Splashtastic sales insights you’ve discovered. You’ve reached which phase of the data analysis process? 5. Scenario 1 continued Next, you create a slideshow, which includes a data visualization to highlight the Splashtastic sales insights ... Read more...
- What is an example of using a metric? Select all that apply. 5. What is an example of using a metric? Select all that apply. 1 / 1 point Using annual profit ... Read more...
- A data analyst might use descriptive column headers in order to achieve what goal? 8. A data analyst might use descriptive column headers in order to achieve what goal? 1 / 1 point Add context to ... Read more...
- A data analytics team is working on a project to measure the success of a company’s new financial strategy. The vice president of finance is most likely to be the _____. 1. A data analytics team is working on a project to measure the success of a company’s new financial strategy. ... Read more...
- Nominal qualitative data has a set order or scale. 3. Nominal qualitative data has a set order or scale. 1 / 1 point True False ✓ CorrectNominal qualitative data does not ... Read more...
- Which of the following are qualities of unreliable data? Select all that apply. 3. Which of the following are qualities of unreliable data? Select all that apply. 1 / 1 point Incomplete ✓ ... Read more...
