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

Prepare journal entries to record the following transactions and events, based on the assumption that the nonprofit uses a singl

stira [4]

Answer:

1. Apple Stocks Dr. $75,000

Deferred Donation Income Cr. $75,000

2. Apple Stocks Dr. $1,500

Gain on Apple Stocks Cr. $1,500

3. Cash Dr. $ 76,000

Gain/Loss on Apple stocks Dr.$1,500

Apple Stocks Cr.$76,500

Explanation:

1. when stocks are received subject to a condition that we can't recognize donation income. therefore it is recorded as liability. please note that deferred income is called as liability.

2. When value of stocks increase, asset stock of apple also increase by differential amount.

3. when asset is sold, the loss is recognized and assets are knocked off from books and cash asset is recorded.

5 0

3 years ago

Are the following statements true or false? The difference between savings and investments is that savings is money set aside fo

grigory [225]

Answer:

That statement is true.

Explanation:

Basically, You put your money in saving if you intended to use that money for future consumption. You put your money in investment if you intended to make financial gain out of it.

For example,

Let's say that you want to buy a laptop that cost $700. You only able to spend $350 per month since you have to consider other more important payment such as rent or food. So you set aside $350 for two month and purchase the laptop at the end of the second month. This is an example of saving.

In another case let's say that you put that $350 in Bonds rather than purchasing laptop. You Let that bond mature and take a 3% interest as profit. Two month later, the value of your money is increased. This is an example of an investment.

8 0

3 years ago

Read 2 more answers

What is the best way to help students use materials successfully in learning centers?

astraxan [27]

The best way to help students demonstrate ways to use materials is when introducing them.

<h3>How can learning centers effectively support students in making effective use of the resources there?</h3>

Create, share, and put procedures into action. The complicated choreography of different students, spaces, and materials that centers entail. Teachers are responsible for developing thorough procedures, explaining them to pupils, and giving them enough time to practice them until they become second nature.

The group with purpose: Centers give students the option to work independently, in groups of their choosing based on interests, or in mixed- or leveled-ability groups. All grouping choices must be deliberate and based on the character and goal of each activity.

Give students meaningful tasks: Centers activities in all subject areas should be engaging, difficult, and, whenever possible, give students a chance to practice skills in real-world contexts. This means that activities should assist students in making connections between their classroom learning and real-world situations or in forming practical habits of mind.

To know more about learning centers, visit:

#SPJ4

3 0

1 year ago

A recent study found that the death rate for people who sleep 6 to 7 hours per night is lower than the death rate for people who

vaieri [72.5K]

Type of employment, indicator for chronic illness, drug, or alcohol use these variables are likely useful to add to the regression to control for important omitted variables.

What is sleep pattern?

The word sleep pattern, commonly referred to as a sleep-wake pattern, refers to a person's schedule for going to bed and getting up as well as their napping habits. The frequency and length of sleep disruptions may also be part of the sleep pattern.

Type of employment, Chronic illness and drug/alcohol use they ought to be included in regression since they disturb sleep patterns.

As a result, option (a) Type of employment. (b) Indicator for chronic illness. (c) Drug or alcohol use is correct.

Learn more about on sleep pattern, here:

brainly.com/question/25287169

#SPJ1

3 0

2 years ago

Windhoek Mines, Ltd., of Namibia, is contemplating the purchase of equipment to exploit a mineral deposit on land to which the c

grin007 [14]

Answer:

Windhoek Mines, Ltd.

The net present value of the proposed mining project is:

= ($232,950).

Explanation:

a) Data and Calculations:

Cost of new equipment and timbers = $500,000

Working capital required = $100,000

Annual net cash receipts = $120,000

Cost to construct new roads in three years = $40,000

Salvage value of equipment in four years = $65,000

Estimated useful life of mine = 4 years

Working capital released in four years = $100,000

Required rate of return = 20%

Cash Flows PV factor Present Value

Cost of new equipment and timbers $500,000 1 -$500,000

Working capital required 100,000 1 -100,000

Annual net cash receipts 120,000 2.589 310,680

Cost to construct new roads in 3 years 40,000 0.579 -23,160

Salvage value of equipment in 4 years 65,000 0.482 31,330

Working capital released in 4 years 100,000 0.482 48,200

Net present value ($232,950)

4 0

3 years ago