All categories

3 years ago

What formula would you enter in C4 that combines A4 and B4 to

Business

1 answer:

Salsk061 [2.6K]3 years ago

5 0

Answer:

Since the question is missing the contents of A4, B4, and C2, see below the explanations for two possible cases.

Explanation:

The command that is used in excel worksheets to combine the content of two (or more) cells into other cell is &.

The content on the resulting cell is will be a text, independent on whether the starting cells had text or numbers.

If you do not want to add any character or blank space in between the content of the starging cells, just use &.

The procedure is:

Select the cell where you want to put the combined data: C2 in your case.

Type = or + and select the first cell you want to combine: A4 in your case.

Type &

Select the other cell that you want to combine: B4 in your case

Press enter.

Done.

Thus, if you do not want to add any character, the answer would be:

=A4&B4. That is not a choice. But notice that =A4&""&B4 yields the same result.

If you want to add some characters or blank space in between the content of the starging cells, use &" whatever you want to add in between"&

The procedure is:

Select the cell where you want to put the combined data: C2 in your case.

Type = or + and select the first cell you want to combine: A4 in your case.

Type &

Type "

Type whatever you want to add in betwen

Type "

Type &

Select the other cell that you want to combine: B4 in your case

Press enter.

Done.

If you you want to add a blank space the answer would be:

=A4&" "&B4.

You might be interested in

Which value gap refers to a company’s failure to accurately assess what customers really want?

fiasKO [112]

Answer:

The correct answer is: Service Quality Gap.

Explanation:

The Service Quality Gap refers to the difference between what a company understands a customer's desires and what must be really done to satisfy that consumer. Firms should make all the efforts in their hands to close that breach and provide the customer with the good or service they need to keep their businesses going. When the gap is not closed, the customer's loyalty fails, pushing them to look for different options in other organizations.

5 0

3 years ago

Robert hitchcock is 40 years old today and he wishes to accumulate $500,000 by his 65th birthday so he can retire to his summer

Anni [7]

The problem wants to find out the cash flow per period that Robert will make from his 40th birthday until his 65th birthday. We know that he wants to get $500,000 by his 65th birthday thus this is the future value of his money. To solve for the cash flow per period, the equation is Future value = Annuity * [((1+i)^n-1)/i]. The n is the number of payments Robert would make which is 25. The answer would be $3749.98.

3 0

3 years ago

Felton Co. produces rubber bands for commercial and home use. Felton reported $8 million residual income (RI) with $25 million n

BaLLatris [955]

Answer:

Residual income = Operating income - (r x Asset invested)

$8 million = $13 million - (r x 25 million)

$8 million = $13 million - r25 million

r25 million = $13 million - $8 million

r25 million = $5 million

r = $5 million/25 million

r = 0.2 = 20%

Thus, required rate of return is 20%

Explanation:

In this case, we need to apply the residual income formula. Operating income, asset invested and residual income have been given with the exception of rate of return. Thus, rate of return becomes the subject of the formula.

6 0

4 years ago

Yard Tools manufactures lawnmowers, weed-trimmers, and chainsaws. Its sales mix and unit contribution margin are as follows.

MAXImum [283]

Answer:

Lawnmowers= 30,000

Weed-trimmers= 75,000

Chainsaws= 45,000

Explanation:

First, we need to calculate the weighted average contribution margin:

Weighted average contribution margin= sales proportion*unitary contribution margin

Weighted average contribution margin= (0.2*30) + (0.5*20) + (0.3*40)

Weighted average contribution margin= $28

Now, the break-even point in units for the whole company:

Break-even point (units)= Total fixed costs / Weighted average contribution margin

Break-even point (units)= 4,200,000 / 28

Break-even point (units)= 150,000

Finally, the number of units to be sold for each product:

Lawnmowers= 0.20*150,000= 30,000

Weed-trimmers= 0.5*150,000= 75,000

Chainsaws= 0.3*150,000= 45,000

6 0

3 years ago

You are considering a project which will provide annual cash inflows of $7,500, $3,000, $9,000, and $12,430 at the end of each y

Blababa [14]

Answer:

$25,161.15

Explanation:

The computation of the present value of the cash flows is presented below:

Years Cash flows Discount factor Present value

1 $7,500.00 0.9174311927 $6,880.73

2 $3,000.00 0.8416799933 $2,525.04

3 $9,000.00 0.7721834801 $6,949.65

4 $12,430.00 0.7084252111 $8,805.73

Present value $25,161.15

The discount factor should be computed below

= 1 ÷ (1 + rate)^years

3 0

4 years ago