All categories

3 years ago

Carlos needs to combine words in a First Name and a Last Name column. Which of the following functions should he use

Business

1 answer:

pantera1 [17]3 years ago

4 0

Answer:

with space: =A2&" "&B2

without space: =CONCATENATE(A2,B2)

Explanation:

When using Microsoft Excel the function that you would want to use would be the following

=A2&" "&B2

In this function, you will be combining the text in cell A2 and B2 with a space in the middle, you can change to the cells that you want and simply add &" "& in between them to combine them with a space.

If you simply want to combine the words with no space in between them you can use the concantenate function which combines words in two cells into one but without space.

=CONCATENATE(A2,B2)

You might be interested in

Consider a household consisting of four college friends. The friends have made a commitment to live together for the next five y

noname [10]

Answer:

move
none are tied

Explanation:

See the attached for a spreadsheet of the values given in the problem statement. We have simply added the salary to the value of the preference and subtracted the one-time moving expense.

The right-most column shows the net increase in value of moving to Miami for each of the householders. Bonnie achieves so much more value that her net value outweighs the rather significant hit in value that Donna experiences.

If the vote is by net value to the householders, they must vote to move. There are no householders that have a net zero change in value.

_____

<em>Comment on democracy</em>

A decision based on net value does not account for the rather significant cost to Donna. If the household values mental health and interpersonal relationships, the fact that one member suffers badly from the move should be enough to sway the decision against it.

5 0

3 years ago

Roberto Designers was organized on January 1, 2018. The firm was authorized to issue 140,000 shares of $5 par value common stock

Phoenix [80]

Answer:

The total stockholder's equity at the end of the year will be $352,000.

Explanation:

The issue of common stock at $7/share= 14,000*$7=$98,000

The issue of common stock at $8/share= 28,000*$8=$224,000

The net income is $140,000.

The dividends paid= $70,000.

Purchase of treasury stock= 4000*$10=$40,000

The total stockholder's equity

=The issue of common stock at $7/share+The issue of common stock at $8/share+The net income-The dividends paid-Purchase of treasury stock

=$98,000+$224,000+$140,000- $70,000-$40,000

=$352,000.

7 0

3 years ago

h. After a promising start, Mercosur, the major Latin American trade agreement, has faltered and made little progress since 2000

Scilla [17]

Answer:

idk

Explanation:

5 0

3 years ago

A machine with a cost of $142,000 and accumulated depreciation of $97,000 is sold for $56,000 cash. The amount that should be re

Temka [501]

A machine would cost $142,000 and the depreciation of $98,000

6 0

3 years ago

Two types of cars (Deluxe and Limited) were produced by a car manufacturer last year. Quantities sold, price per unit, and labor

Damm [24]

Answer:

Labor productivity in units per labor hour for Deluxe car = 0.19 per hour

Labor productivity in units per labor hour for Limited car = 0.24 per hour

Labor productivity in dollar of output per dollar of labor expense for Deluxe car = $98.75

Labor productivity in dollar of output per dollar of labor expense for Limited car = $128.69

Explanation:

Note: This question is not complete and its data are merged together. The complete question with the sorted data is therefore provided before answering the question as follows:

Two types of cars (Deluxe and Limited) were produced by a car manufacturer last year. Quantities sold, price per unit, and labor hours are given below.

QUANTITY $/UNIT

Deluxe car 3,655 units sold $7,700/car

Limited car 5,850 units sold $9,200/car

Labor, Deluxe 19,000 hours $15/hour

Labor, Limited 24,600 hours $17/hour

What is the labor productivity for each car? Provide two sets of figures: units per labor hour, and dollar of output per dollar of labor expense. (Round your answers to 2 decimal places.)

The explanation of the answers is now provided as follows:

For each type of car, the following formulae can be used:

Labor productivity in units per labor hour = Units sold / Labor hours ……. (1)

Labor productivity in dollar of output per dollar of labor expense = (Units sold * Price per car) / (Labor hours / Labor rate per hour) ……………. (2)

Using equation (1), we have:

Labor productivity in units per labor hour for Deluxe car = 3,655 / 19,000 = 0.19 per hour

Labor productivity in units per labor hour for Limited car = 5,850 / 24,600 = 0.24 per hour

Using equation (2), we have:

Labor productivity in dollar of output per dollar of labor expense for Deluxe car = (3,655 * $7,700) / (19,000 * $15) = $98.75

Labor productivity in dollar of output per dollar of labor expense for Limited car = (5,850 * $9,200) / (24,600 * $17) = $128.69

These can be translated into a table as follows:

Labor Productivity

Units/hour Dollars

Deluxe Car 0.19/hour $98.75

Limited Car 0.24/hour $128.69

5 0

3 years ago