answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
kicyunya [14]
2 years ago
11

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

Business
1 answer:
Salsk061 [2.6K]2 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
On October 29, 2017, Lobo Co. began operations by purchasing razors for resale. Lobo uses the perpetual inventory method. The ra
sveta [45]

Answer:

a. Nov 11, 2017

Dr Cash $4,900

Cr sales $4,900

Nov 30, 2017

Dr Warranty expense $294

Cr Estimated warranty Liabilities $294

Dec 9, 2017

Dr Estimated warranty Liabilities $196

Cr Cash $196

Dec 16, 2017

Dr Cash $14,700

Cr sales $14,700

Dec 29, 2017

Dr Estimated warranty Liabilities $392

Cr Cash $392

Dec 31, 2017

Dr Warranty expense $882

Cr Estimated warranty Liabilities $882

b. Jan 5,2018

Dr Cash $9,800

Cr Sales$9,800

Jan 17,2018

Dr Estimated warranty Liabilities $462

Cr Cash $462

Dec 31,2018

Dr Warranty expense $588

Cr Cash $588

Explanation:

a. Preparation of the journal entries to record above transactions and adjustments for 2017

Nov 11, 2017

Dr Cash $4,900

Cr sales $4,900

(Being to record razors sold for cash)

Nov 30, 2017

Dr Warranty expense $294

Cr Estimated warranty Liabilities $294

($4900*6%)

(Being to record warranty expense)

Dec 9, 2017

Dr Estimated warranty Liabilities $196

Cr Cash $196

(14 razors*14)

(Being to replaced 14 razors)

Dec 16, 2017

Dr Cash $14,700

Cr sales $14,700

(Being razors sold for cash)

Dec 29, 2017

Dr Estimated warranty Liabilities $392

Cr Cash $392

(28 razors*14)

(Being to replaced 28 razors)

Dec 31, 2017

Dr Warranty expense $882

Cr Estimated warranty Liabilities $882

($14,700*6%)

(Being to record warranty expense)

b. Preparation of the journal entries to record above transactions and adjustments for 2018

Jan 5,2018

Dr Cash $9,800

Cr Sales$9,800

(Being to record razors sold for cash)

Jan 17,2018

Dr Estimated warranty Liabilities $462

Cr Cash $462

(33 razors*14)

(Being to replaced 33 razors)

Dec 31,2018

Dr Warranty expense $588

Cr Cash

(6%*$9,800) $588

(Being to record warranty expense)

5 0
2 years ago
You are evaluating two different silicon wafer milling machines. The Techron I costs $285,000, has a three-year life, and has pr
KonstantinChe [14]

Answer:

EAC Techron I = -$141,050

EAC Techron II = -$138,181

Explanation:

Techron I costs $285,000, has a three-year life, and has pretax operating costs of $78,000 per year. Salvage value $55,000, use straight line depreciation.

annuity factor = [1 - 1/(1 + r)ⁿ] / r = [1 - 1/(1 + 0.11)³] / 0.11 = 2.4437

depreciation expense per year = ($285,000 - $55,000) / 3 = $76,667

cash outflow years 1 and 2 = [($78,000 + $76,667) x (1 - 24%)] - $76,667 = ($154,667 x 0.76) - $76,667 = $40,880

cash outflow year 3 = [($78,000 + $76,667) x (1 - 24%)] - $76,667 - $55,000 = ($154,667 x 0.76) - $76,667 - $55,000 = -$14,120

NPV = -285,000 - 40,880/1.11 - 40,880/1.11² + 14,120/1.11³ = -285,000 - 36,829 - 33,179 + 10,324 = -344,684

EAC = NPV / annuity factor = -344,684 / 2.4437 = -$141,050

Techron II costs $495,000, has a five-year life, and has pretax operating costs of $45,000 per year. Salvage value $55,000, use straight line depreciation.

annuity factor = [1 - 1/(1 + r)ⁿ] / r = [1 - 1/(1 + 0.11)⁵] / 0.11 = 3.6959

depreciation expense per year = ($495,000 - $55,000) / 5 = $88,000

cash outflow years 1 through 4 = [($45,000 + $88,000) x (1 - 24%)] - $88,000 = ($133,000 x 0.76) - $88,000 = $13,080

cash outflow year 5 = [($45,000 + $88,000) x (1 - 24%)] - $88,000 - $55,000 = ($133,000 x 0.76) - $88,000 - $55,000 = -$41,920

NPV = -495,000 - 13,080/1.11 - 13,080/1.11² - 13,080/1.11³ - 13,080/1.11⁴ + 41,920/1.11⁵ = -495,000 - 11,784 - 10,616 - 9,564 - 8,616 + 24,877 = -510,703

EAC = NPV / annuity factor = -510,703 / 3.6959 = -$138,181

4 0
2 years ago
Describe a company that has gotten publicity from the news media. Why did the company get publicity? Was it positive or negative
Dmitrij [34]
Samsung, for having lithium ion batteries in their new phones the samsung galaxy 7, negative because they were burning up and hurting people.
8 0
1 year ago
Read 2 more answers
Which of the following is a persuasive title for a proposal that aims to persuade a business to hire a lawn care service?
Nadusha1986 [10]
I think the correct answer from the choices listed above is option B. A persuasive title for a proposal that aims to persuade a business to hire a lawn care service would be "<span>How Professional Lawn Care Can Save You Money</span>". It would draw attention to the one you are presenting it. Hope this answers the question. Have a nice day.
5 0
2 years ago
Read 2 more answers
Austrian Airlines was sued by a 51-year-old former director of sales who charged that he was dismissed and replaced by an employ
Angelina_Jolie [31]

Answer:

the correct answer is True

good luck ❤

7 0
2 years ago
Other questions:
  • Helen is keen on creating her own company when she graduates from college. She has researched the sector and developed contacts
    12·2 answers
  • Gingerbread Inc. reported the following selected financial information for 2019: Net Sales $850,000 Gross Profit 450,000 Net Inc
    8·1 answer
  • You recently were hired as a front line debt collection agent for a debt collection service in Michigan. Your boss assigns you t
    12·1 answer
  • A factory produces short-sleeved and long-sleeved shirts. A short-sleeved shirt requires 30 minutes of labor, a long-sleeved shi
    9·1 answer
  • On January 1, Borge Inc. issued $3,000,000, 8% bonds for $2,817,000. The market rate of interest for these bonds is 9%. Interest
    14·2 answers
  • For 2014, Bakers Manufacturing uses machine-hours as the only overhead cost-allocation base. The direct cost rate is $3.00 per u
    8·1 answer
  • 8. Which type of credit requires that borrowers carefully manage the debt so it doesn't get out of
    5·2 answers
  • Colleague responsibilities related to compliance include which of the following:________. A. Report if you have been placed on a
    10·1 answer
  • When Marilyn Monroe died, ex-husband Joe DiMaggio vowed to place fresh flowers on her grave every Sunday as long as he lived. Th
    9·1 answer
  • Sue now has $125. How much would she have after 8 years if she leaves it invested at 8.5% with annual compounding
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!