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.
To move the 5-digit zip code in cell L2 into its own column, you use the function =LEFT(L2,5).
1 / 1 point
Correct
To move the 5-digit zip codes in Column L into their own column, you use the RIGHT function: =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...
- 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...