4. Scenario 1, continued
At this point, you notice that the information about state and zip code is in the same cell. However, your company’s mailing list software requires states to be on a separate line from zip codes.
What function do you use to move the 5-digit zip code in cell L2 into its own column?
1 / 1 point
Correct
To move the 5-digit zip codes in Column L into their own column, use =RIGHT(L2,5).
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...
- She asks: Is there a SQL function that can convert data types such as currency, dates, and times in a SQL table? 8. Scenario 2, continued Now, your interviewer explains that the data team usually works with very large amounts of customer ... Read more...
- An analyst notes that the “160” in cell A9 is formatted as text, but it should be Australian dollars. What spreadsheet tool can help them select the right format? 1. An analyst notes that the “160” in cell A9 is formatted as text, but it should be Australian dollars. ... Read more...
- A data analyst wants to be sure all of the numbers in a spreadsheet are numeric. What function should they use to convert text to numeric values? 2. A data analyst wants to be sure all of the numbers in a spreadsheet are numeric. What function should ... Read more...
- This SQL query can be used to identify the percentage of contributions from prospects compared to total donors: 12. Scenario 2, continued The community garden grand opening was a success. In addition to the 55 donors Food Justice ... Read more...