subject

Your coworker created a workbook with a list of names and addresses. The state abbreviation and ZIP code are stored in one cell per customer, such as NC 27215. You need to be able to sort these data by postal code to use bulk-rate mailing. The appropriate Excel action is to: (a) Type 27215 in the cell to the right of NC 27215 and use Flash Fill.

(b) Copy the data to another column and edit each cell to delete the state abbreviations.

(c) Use the BREAK APART function to separate the state abbreviation and zip code.

(d) Insert a new column and retype the postal codes.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 16:30
Corey set up his presentation for delivery to his team.the information he had to convey was critical to their job performance.he knew he would need a lot of time to explain each point
Answers: 3
question
Computers and Technology, 22.06.2019 19:20
Write a program that prompts the user to input a string. the program then uses the function substr to remove all the vowels from the string. for example, if str = "there", then after removing all the vowels, str = "thr". after removing all the vowels, output the string. your program must contain a function to remove all the vowels and a function to determine whether a character is a vowel.
Answers: 2
question
Computers and Technology, 23.06.2019 01:30
1. which of the following is a search engine? a) mozilla firefox b)internet explorer c)google d)safari 2. which of the following statements is true? a) all search engines will provide the same results when you enter the same query. b) all search engines use the same amount of advertisements. c) some search engines are also browsers. d) search engines often provide different results, even when you enter the same query.
Answers: 2
question
Computers and Technology, 24.06.2019 13:00
George heard about the benefits of a data warehouse. he wants to try implementing one for his organization. however, he is afraid that transferring data to the data warehouse will affect transaction time. which element ensures that transactions are not affected when moving data to a warehouse? when data is transferred to a data warehouse, the a area frees the source system to continue transaction processing.
Answers: 2
You know the right answer?
Your coworker created a workbook with a list of names and addresses. The state abbreviation and ZIP...
Questions
question
Physics, 24.03.2020 00:14
question
Mathematics, 24.03.2020 00:15
question
History, 24.03.2020 00:15
question
Mathematics, 24.03.2020 00:15
question
Health, 24.03.2020 00:16