If You Use the Text to Columns Wizard to Separate

question 47

Multiple Choice

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)Excel would add a new column to accommodate last names.
• B)The two new columns would be created in a new worksheet.
• C)Excel would return an error message.
• D)The new last name column would overwrite the data in the street address column.

---

Definitions:

Government

The organization or system through which a society or community is governed, typically consisting of various institutions and authorities.

Market

Any structure that allows buyers and sellers to exchange any type of goods, services, and information.

Perfectly Inelastic

A situation in demand where the quantity demanded does not change regardless of changes in price.

Price Elasticity of Demand

A measure of how much the quantity demanded of a good responds to a change in the price of that good, computed as the percentage change in quantity demanded divided by the percentage change in price.