If you use the Text to Columns wizard to separate the Name Column in the table below into First Name and Last name columns, what would happen if you separated the names at the space between first name and last name without making any other changes to the table?

A B C
1 Name Street Address City
2 Mary Smith 123 Elm St Greensboro

A) The new last name column would overwrite the data in the street address column.
B) Excel would add a new column to accommodate last names.
C) The two new columns would be created in a new worksheet.
D) Excel would return an error message.


A

Computer Science & Information Technology

You might also like to view...

memcmp would return ___________ for the call memcmp("Hi, how are you?", "Hi, how are things?", 6).

a. 1 b. A positive number. c. 0 d. A negative number.

Computer Science & Information Technology

In ________, Excel maximizes the number of cells visible on the screen

A) Page Layout view B) Backstage view C) Chart styles D) Normal view

Computer Science & Information Technology

In the process of checking the values and eliminating errors, it is best to start with formulas that are simple and do not reference other cells that have formulas

Indicate whether the statement is true or false.

Computer Science & Information Technology

Placing the elements in a website layout that's functional, usable, and, ideally, aesthetically pleasing is often the job of a ___________.

A. software engineer B. graphic engineer C. software designer D. graphic designer

Computer Science & Information Technology