If You Use the Text to Columns Wizard to Separate

question 50

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:

Efficiency Wages

Wages set above the market-clearing level by employers to increase worker productivity, discourage turnover, and reduce shirking.

Nutritious Diet

A diet that provides all the essential nutrients in correct proportions for healthy living.

Market Power

The ability of a firm or group of firms to control prices or exclude competition in a market.

Respond Efficiently

The ability of entities or systems to adjust and react promptly and effectively to changes or challenges.