1answer.
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
timofeeve [1]
2 years ago
10

Explain a situation where user would transpose data on a spreadsheet in Microsoft Excel. Give at least one example to illustrate

your reasoning
Business
1 answer:
GuDViN [60]2 years ago
6 0

Answer:

You can do this by copying, pasting, and using the Transpose option. But doing that creates duplicated data. If you don't want that, you can type a formula instead using the TRANSPOSE function. For example, in the following picture the formula =TRANSPOSE(A1:B4) takes the cells A1 through B4 and arranges them horizontally.

Step 1: Select blank cells

First select some blank cells. But make sure to select the same number of cells as the original set of cells, but in the other direction. For example, there are 8 cells here that are arranged vertically:

Cells in A1:B4

So, we need to select eight horizontal cells, like this:

Cells A6:D7 selected

This is where the new, transposed cells will end up.

Step 2: Type =TRANSPOSE(

With those blank cells still selected, type: =TRANSPOSE(

Excel will look similar to this:

=TRANSPOSE(

Notice that the eight cells are still selected even though we have started typing a formula.

Step 3: Type the range of the original cells.

Now type the range of the cells you want to transpose. In this example, we want to transpose cells from A1 to B4. So the formula for this example would be: =TRANSPOSE(A1:B4) -- but don't press ENTER yet! Just stop typing, and go to the next step.

Excel will look similar to this:

=TRANSPOSE(A1:B4)

Step 4: Finally, press CTRL+SHIFT+ENTER

Now press CTRL+SHIFT+ENTER. Why? Because the TRANSPOSE function is only used in array formulas, and that's how you finish an array formula. An array formula, in short, is a formula that gets applied to more than one cell. Because you selected more than one cell in step 1 (you did, didn't you?), the formula will get applied to more than one cell. Here's the result after pressing CTRL+SHIFT+ENTER:

You might be interested in
How much interest is earned in just the third year on a $1,000 deposit that earns 7% interest compounded annually?
Sav [38]

Answer:

Interest earn= $80.14

Explanation:

Giving the following information:

PV= $1,000

i= 7%

n= 3

<u>First, we will calculate the future value at the second year:</u>

FV= PV*(1+i)^n

FV= 1,000*(1.07^2)

FV= 1,144.9

<u>Now, for the third year:</u>

FV= 1,144.9*1.07= 1,225.04

Interest earn= 1,225.04 - 1,144.9= $80.14

4 0
3 years ago
At the beginning of the year, Plummer's Sports Center bought three used fitness machines from Brunswick Corporation. The machine
garri49 [273]

Answer:

(i) $14,000

(ii) $32,000

(iii) $10,000

Explanation:

Cost of the machine that is recorded in the books of accounts is the total cost incurred to make the machine useful and useable.

Cost for each machine:

= amount paid for the assets + installation costs + renovation cost prior to use.

Therefore,

Cost of Machine A = 11,000 + 500 + 2,500

                               = $14,000

Cost of Machine B = 30,000 + 1,000 + 1,000

                               = $32,000

Cost of Machine C = 8000 + 500 + 1500

                               = $10,000

7 0
3 years ago
What is FAFSA? Who is eligible?
marishachu [46]
The Free Application for Federal Student Aid (FAFSA<span>) is used to calculate the Expected Family Contribution (EFC), a somewhat harsh measure of the family's ability to pay for college. The EFC is the sum of a student contribution and a parent contribution.</span>
6 0
3 years ago
Tristan owns a local flower shop. His customers are already finding him online, but he's curious whether Google My Business can
Tema [17]

Answer: By responding to reviews

Explanation:

Google my business can also help Tristan respond to reviews/comments made by customers online about his business. Google my business is a tool which business owners make use of, to make their business easily accessible when searched about online and it provides a section for reviews which a business can respond to.

4 0
3 years ago
Railway Cabooses just paid its annual dividend of $3.10 per share. The company has been reducing the dividends by 10.9 percent e
Vlada [557]

Answer:     Po = Do(1+g)/Ke-g

                  Po = $3.10(1-0.109)/0.13 - (-0.109)

                  Po = $3.10(0.891)/0.13+0.109

                  Po = $3.10(0.891)/0.239

                  Po = $11.56

Explanation: The current market price of the stock equals the current dividend paid multiplied by 1+g divided by the excess of cost of equity over growth rate. The growth rate is negative in this case, thus, the growth rate would be deducted from 1. Moreso, the growth rate will be added to cost of equity since it is negative. Thus, the amount that the investor will be willing to pay is $11.56.

7 0
3 years ago
Other questions:
  • You decide that you need more information on how employees feel about diversity, so you create a paper and pencil survey on empl
    9·1 answer
  • Adair Valley issued $20,000,000 of general obligation bonds to construct a multipurpose arena. These bonds will be serviced by a
    8·1 answer
  • Which two things do benefits tell you about a product
    13·1 answer
  • A company has earned a large profit this year. The company’s president wants to reward certain employees for their exceptional p
    12·1 answer
  • Use the information below for Harding Company to answer the question that follow. Harding Company Accounts payable $ 40,000 Acco
    6·1 answer
  • In a market economy the factors of production are allocated by
    11·1 answer
  • At January 1, Year 1, under its restricted stock unit (RSU) plan, Label Corporation grants RSUs representing 10,000 of its $1 pa
    13·1 answer
  • 50 Points!!
    7·1 answer
  • Assume that if you advertise and your rival advertises, you each will earn $4 million in profits. If neither of you advertises,
    12·1 answer
  • Which of the following of Wegman's motivating factors is an intrinsic motivator?
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!