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 typo.
What spreadsheet tool allows you to control what can and cannot be entered in your worksheet in order to avoid typos?
1 / 1 point
Correct
Data validation allows you to control what can and cannot be entered in your worksheet in order to avoid typos. It does this by adding drop-down lists with predetermined options, such as each city name.
Related Questions & Answers:
- Adding descriptive headers to columns of data in a spreadsheet is an example of which analytical skill? 2.Adding descriptive headers to columns of data in a spreadsheet is an example of which analytical skill? 1 / 1 point Data ... Read more...
- Fill in the blank: The data life cycle has six stages, whereas data analysis has six _____. 4.Fill in the blank: The data life cycle has six stages, whereas data analysis has six _____. 1 / 1 point key ... Read more...
- Fill in the blank: A problem is an obstacle to be solved, an issue is a topic to investigate, and a _____ is designed to discover information. 3.Fill in the blank: A problem is an obstacle to be solved, an issue is a topic to investigate, and ... Read more...
- 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...