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

Boeing’s strategy to become the largest airplane maker in the world included acquiring competitors such as mcdonnell douglas. Th

8_murik_8 [283]

There are different aspect of management. The development of this strategy falls under the planning function of management.

<h3>What is the planning function of management?</h3>

Planning is simply known to be a function of management that entails putting out objectives and knowing the right course of action to achieving the stated objectives.

Planning often needs managers to be very much aware of environmental conditions that faces their organization and predict future conditions.

Conclusively, principles of management is grouped into the four major functions such as;

Planning,
Organizing
Leading
Controlling

Learn more about planning function from

brainly.com/question/16118348

5 0

2 years ago

What is the most important factor to you in choosing a job?

GarryVolchara [31]

Explanation:

1. Salary: Yes it is the salary which comes top most. Everybody needs money and each and everyone expects different salary based on their skills.

2. Career prospects: Career prospects are higher important than the salary. Only if the organization can provide space for growth, then only the job seems to be good.

3. Training and Development: This is one of the important aspect to upskill oneself. The upskill supports both personal growth and the growth of the organization.

4. Flexibility and benefits: Ability to adapt to change and make changes accordingly. Flexibility either way is expected. The additional benefits which one get is really an extra benefit and recognition given to the employee. Eg. Bonus

3 0

3 years ago

Sheffield Company reports the following operating results for the month of August: sales $315,000 (units 5,000); variable costs

frosja888 [35]

Answer:

1. the net income if selling price increased by 10% would be = $59,700

Net income increased by $31,500.

Explanation:

Given,

Sales = $315,000

Variable costs = $216,000

Fixed costs = $70,800

No. of units = 5,000

Sheffield Company

Income Statement (Contribution Margin Format)

Particulars $

Sales 315,000

Less: Variable expenses (216,000)

Contribution Margin 99,000

Less: Fixed costs (70,800)

Net Income 28,200

Since the selling price increased by 10% and no change in variable costs and volume, therefore, we can get -

Sales = $315,000 x (1 + 0.10) = $346,500

In this case, the net income will be as follows:

Sales = $346,500

Less: Variable Costs = (216,000)

Contribution Margin = 130,500

Less: Fixed Costs = (70,800)

Net Income = 59,700

5 0

3 years ago

Assume that a consumer purchases only two products. Suppose that the consumer's money income doubles, and the prices of the two

Vitek1552 [10]

Answer:

Explanation:

A) A shift of the budget line inward to the left

B) A shift of the budget line outward to the right

C) No change in the budget line

D) An increase in the slope of the budget line

5 0

3 years ago

Manny and Irene will be retiring in fifteen years and would like to buy a Mexican villa. The villa costs $500,000 today, and ho

ki77a [65]

Answer:

Annual deposit= $37,714.37

Explanation:

Giving the following information:

The villa costs $500,000 today, and housing prices in Mexico are expected to increase by 6% per year. Manny and Irene want to make fifteen equal annual payments into an account, starting today, so there will be enough money to purchase the villa in fifteen years.

The account earns 10% per year.

First, we need to calculate the final value of the house with the following formula.

FV= PV*(1+i)^n

FV= 500,000*(1.06^15)=$1,198,279.1

Now, we can calculate the annual payments required:

FV= {A*[(1+i)^n-1]}/i

A= annual deposit

Isolating A:

A= (FV*i)/{[(1+i)^n]-1}

A= (1,198,279.1*0.10)/[(1.10^15)-1]

A= $37,714.37

6 0

3 years ago