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

Which of the following is true of F a c e b o o k advertisements?

morpeh [17]

They’re affordable and highly targeted.

8 0

3 years ago

Jones Mfg. has current assets of $26,900, net working capital of $8,200, long-term debt of $21,500, and total equity of $57,800.

abruzzese [7]

Answer:

Explanation:

Jones Mfg. has current assets of $26,900, net working capital of $8,200, long-term debt of $21,500, and total equity of $57,800. What is the equity multiplier?

6 0

2 years ago

Shawna wins the lottery and her income increases by 60 percent. she used to buy 10 pints of cottage cheese per month and now she

Dmitriy789 [7]

Answer: Her income elasticity of demand for cottage cheese is 0.3333 making it a normal and necessary good.

The income elasticity of demand is given by :

$\mathbf{YED = \frac{percentage change in demand}{percentage change in income}}$

The percentage change in income is given as 60%. We calculate the percentage change in quantity demanded as follows:

$\mathbf{percentage change in quantity demanded = \frac{Q_{1}-Q_{0}}{Q_{0}}}$

$\mathbf{percentage change in quantity demanded = \frac{12-10}{10}}$

$\mathbf{percentage change in quantity demanded = 0.2}\\$

Substituting the value above in the income elasticity demand formula we get,

$\mathbf{YED = \frac{0.20}{0.60}}$

YED = 0.33333

Since the income elasticity is positive, and since Shawna buys more cottage cheese after an increase in income, we can classify this good as a normal good.

Since the income elasticity is between 0 and 1 we can also conclude that cottage cheese is also a essential good or a necessity.

7 0

3 years ago

Bond issuance: 20% of total funds, requires 15% interest per year Bank loan: 60% of total funds, requires 9.5% interest per year

Anettt [7]

Answer: 28.57%

Explanation:

Average return given the variables will be;

$Average rate of return = \frac{Annual net income}{Average investment}$

Average rate of return = $\frac{1,000,000}{\frac{7,000,000}{2} }$

Average rate of return = 1,000,000/3,500,000

Average rate of return = 28.57%

4 0

3 years ago

The GAP is a global clothing retailer for men, women, children, and babies. The following information is taken from The Sap's fi

Alexxandr [17]

Answer:

The GAP

a. Cost of goods sold = $10,364

b. Cash paid to suppliers = $10,409

Explanation:

a) Data and Calculations:

Selected Balance Sheet Data

($ millions) 2015 2014

Inventories $1,918 $1,844

Accounts Payable 1,157 1,128

Purchases during 2015 = $10,438 million

b) Cost of goods sold:

Beginning inventory $1,844

Purchases 10,438

Goods available $12,282

Ending inventory (1,918)

Cost of goods sold $10,364

c) Accounts Payable:

Beginning balance $1,128

Purchases 10,438

Less ending balance 1,157

Cash paid to suppliers $10,409

3 0

3 years ago