Computers and Technology, 24.03.2020 18:07 ayoismeisjjjjuan

A worksheet contains addresses in column C. The addresses use commas after the street, city, and state, such as 129 Elm Street, Burlington, NC, 27215. Column D contains the phone number. You use Text to Columns to divide the addresses into multiple columns using comma delimiters. You successfully divide the addresses into four columns. What happens to the phone numbers in column D?(a) Excel inserts new columns for each comma so the phone number will move to column G.
(b) The phone numbers are overwritten by the cities.
(c) Nothing will happen to the phone numbers.
(d) The phone numbers will convert to commas.

Answers: 3

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 03:40

Mary's manager told her she should insert a graphic into her documentwrite mary a brief note describing how to insert a graphicin a word processing document.

Answers: 1

Answer

Computers and Technology, 22.06.2019 19:30

When creating a presentation in libre office impress, where does the editing of slides take place? a. the slides panel b. the center panel c. the tasks panel, under the masters pages tab d. the tasks panel, under the layouts tab

Answers: 1

Answer

Computers and Technology, 22.06.2019 23:30

For her science class, elaine is creating a presentation on weather in the united states. she wants to make the presentation beautiful and interesting by drawing simple cloud or wave shapes. which is the best way for elaine to draw these shapes?

Answers: 1

Answer

Computers and Technology, 23.06.2019 14:30

Select the correct answer. a company wants to use online methods to target more customers. it decides to conduct a market research by collecting the data of a few customers with their consent. they want to track data of the sites that their customers frequently visit. which software can the company? a. spyware b. bots c. adware d. trojan horse e. rootkits

Answers: 1

Answer

You know the right answer?

A worksheet contains addresses in column C. The addresses use commas after the street, city, and sta...

Questions