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.
Fill in the blank: To add drop-down lists to your worksheet with predetermined options for each city name, you decide to use _____.
1 / 1 point
Correct
You decide to use data validation. 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:
- Select the best description of gut instinct. 4.Select the best description of gut instinct. 1 / 1 point Using your innate ability to analyze results Choosing facts that complement ... Read more...
- Fill in the blank: A query is used to _____ information from a database. Select all that apply. 7.Fill in the blank: A query is used to _____ information from a database. Select all that apply. 1 / ... Read more...
- In the following spreadsheet, where can you find all of the attributes — also known as the observation — of Fayetteville? 2.In the following spreadsheet, where can you find all of the attributes — also known as the observation — of ... Read more...
- What is the process of using facts to guide business strategy? 5. What is the process of using facts to guide business strategy? 1 / 1 point Data-driven decision-making ✓ Data visualization Data ... Read more...
- Which of the following questions make assumptions? Select all that apply. 8. Which of the following questions make assumptions? Select all that apply. 1 / 1 point Keeping employees engaged is ... Read more...
- A metric is a specific type of data that companies use to identify a problem domain. 5. A metric is a specific type of data that companies use to identify a problem domain. 1 / 1 point True ... Read more...
