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

QS 11-9 Recording warranty repairs LO P4 On September 11, 2016, Home Store sells a mower for $490 cash with a one-year warranty

prisoha [69]

Answer:

On September 11, 2016, Home Store sells a mower for $490 cash with a one-year warranty that covers parts

Recording of revenue:

Cash $490 (debit)

Revenue $490 (credit)

Recording of Warranty granted :

Assurance Warranty expense $49.00 (debit)

Warranty Provision $49.00 (credit)

$490 × 10% = $49.00

On July 24, 2017, the mower is brought in for repairs covered under the warranty requiring $34 in materials taken from the Repair Parts Inventory

When warranty is subsequently received:

Warranty Provision $ 34 (debit)

Repair Parts Inventory $ 34 (credit)

Explanation:

On September 11, 2016, Home Store sells a mower for $490 cash with a one-year warranty that covers parts

Recording of revenue:

Cash $490 (debit)

Revenue $490 (credit)

We Recognise Revenue to depict transfer of control of mower

Recording of Warranty granted :

Assurance Warranty expense $49.00 (debit)

Warranty Provision $49.00 (credit)

$490 × 10% = $49.00

There is no option for customer to take the warranty or not, so this is a service warranty.The warranty is measured at the best estimate of expenditure required to settle the obligation that is at 10% of sales.

On July 24, 2017, the mower is brought in for repairs covered under the warranty requiring $34 in materials taken from the Repair Parts Inventory

When warranty is subsequently received:

Warranty Provision $ 34 (debit)

Repair Parts Inventory $ 34 (credit)

Utilise the Warranty Provision when the warranty claim is subsequently received

7 0

3 years ago

Assume that while the budget balance in Conania changes from positive to negative, capital inflow in Conania also decreases. How

Aleks [24]

Answer and Explanation:

In the case when the budget balance of the Conania varies i.e. from positive to negative so the capital inflow would decrease

Now this impact private investment spending in such a way that the situation would become worst and this would lead a serious crowding effect that ultimately reduce the economy

Hence, the same is relevant

4 0

3 years ago

2.- Se hicieron compras de materia prima por $ 50,000.00 más IVA que se pagaron como sigue:

cestrela7 [59]

no entendi nadita pero que larga tu prwgunta

5 0

3 years ago

Malik is the top employee at the local Deloitte office, and he just received a competing offer from PwC. Deloitte is considering

GREYUIT [131]

Answer: Extra Vacation ; Stay

Explanation:

At the Nash equilibrium, Deloitte will choose extra vacation and Malik will respond with stay.

A Nash Equilibrium is the optimal outcome for each player given the decisions of the other player.

Looking at the the sequential game tree, if Deloitte offered a Money Bonus, Malik would leave because it offers him a higher payout. Deloitte would not want this because they gain more when he stays.

If Malik is offered extra vacation however, Malik stands to gain more than every other option if he stays and Deloitte would therefore offer him this because it will still be a gain for them. This is the Nash equilibrium.

8 0

3 years ago

An annuity immediate pays 15 at the end of years 1 and 2, 14 at the end of years 3 and 4 and so on. The payments decrease by 1 e

Inessa05 [86]

Answer:

$138.63

Explanation:

I used an excel spreadsheet and the NPV function to determine the present value of this annuity. The present value of this annuity is $138.63

3 0

3 years ago