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

On December 31, 2017, Extreme Fitness has adjusted balances of $960,000 in Accounts Receivable and $87,000 in Allowance for Doub

Paladinen [302]

Answer:

What amount would the company report as its net accounts receivable on December 31, 2017?

Accounts Receivable $873,000

Prepare the journal entry to write off the accounts on January 2, 2018.

Allowance for Uncollectible Accounts $ 26,000

Accounts Receivable $ 26,000

Assuming no other transactions occurred between December 31, 2017, and January 3, 2018, what amount would the company report as its net accounts receivable on January 3, 2018?

The same amount reported on December 31, 2017, if the company doesn't report any movement with the credit debtor there is nothing to do.

Has net accounts receivable changed from December 31, 2017?

The net accounts are the same there is not change in the balance because the write-off it's just a reclassification between the accounts, so the balance keep the same as before.

Explanation:

Accounts Receivable $873,000

The company reports as net accounts receivable the total amount on Accounts Receivable minus the total amount on the Allowance for Uncollectible Accounts which represent the amount of credit that won't be possible to collect, the result it's the total value on net accounts receivable.

Allowance for Uncollectible Accounts $ 26,000

Accounts Receivable $ 26,000

As the company just recognized the accounts not collectible, at the moment of the write off it's just a reclasification between the accounts of Allowance for Uncollectible Accounts and Accounts Receivable.

At this moment it's a certainly that the accounts won't be collected, that is why the entry is recorded.

6 0

3 years ago

Pureform, Inc., manufactures a product that passes through two departments. Data for a recent month for the first department fol

8_murik_8 [283]

Explanation:

Equivalent units

Materials Labor Overhead

Work in process inventory, 23,100.00 34,650.00 34,650.00

beginning

Units started and completed 6,73,000.00 6,73,000.00 6,73,000.00

Work in process inventory, 28,000.00 14,000.00 14,000.00

ending

Equivalent units 7,24,100.00 7,21,650.00 7,21,650.00

First department cost per unit for first department

Materials Labor Overhead Total

Current costs 11,94,765.00 2,88,660.00 5,05,155.00 19,88,580.00

Equivalent units 7,24,100.00 7,21,650.00 7,21,650.00

Cost per Equivalent unit 1.65 0.40 0.70 2.75

The equivalent units for materials,labor and overhead are as follows:

Equivalent units

Materials 724,000

Labor 721,650

Overhead 721,650

In addition,the cost per unit for equivalent units are as follows:

Materials 1.65

Labor 0.40

Overhead 0.70

Total 2.75

7 0

3 years ago

Henry bakes loaves of bread, which he sells for $4 each. He is considering purchasing additional mixers (capital) for his bakery

babunello [35]

Answer: The complete table is as follows:

Explanation:

The following are the formulas for calculating marginal product , total revenue and marginal revenue product:

Marginal product = $\frac{Change\ in\ Total\ Product}{Change\ in\ Capital}$

Total revenue = Price × Quantity

Marginal revenue Product = Marginal product × Price

By using these formulas, I have completed the following table:

6 0

3 years ago

In a properly designed internal accounting control system, the same employee should not be permitted to:

yawa3891 [41]

In a business world, segregation of duties is important to have a sound internal control. The employee handing cash/check collection is prohibited from updating its customer's subsidiary ledger and recording of transactions in the books. This will eliminate fraud and misappropriation of funds.

8 0

3 years ago

In 2018, the Barton and Barton Company changed its method of valuing inventory from the FIFO method to the average cost method.

Sati [7]

Answer:

In Barton and Barton Company's general journal, entry required include:

Debit Retained Earnings Account with $8.2 million

Credit Opening Inventory with $8.2 million

Being reversal of overstated inventory due to change from FIFO to Average cost method.

Explanation:

The debit entry to the Retained Earnings Account will reduce the balance by $8.2 million. The effect of overstating the closing inventory is overstatement of the net income because the cost of sales was understated as a result of the inventory overstatement.

The credit entry to the Opening Inventory reduces the balance to the new balance based on the average cost method of $23.8 million.

The FIFO cost method or First-In, First-Out method is an inventory costing method that assumes that goods that were bought first were the ones to be sold first. The inventory cost is therefore valued with the most recent quantity and cost price.

On the other hand, the Average Cost Method, also called the Weighted Average Cost Method, calculates the inventory cost by adding all the period's inventory and dividing it by the quantity for the period. This gives an average cost which is in turn used to multiply the quantity of inventory at the end of the period to obtain the inventory cost.

Both methods are estimates that produce different results and affect the reported net income differently. There is always the need for consistency in choosing the method to apply so that reported net income is not unduly distorted.

3 0

3 years ago