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
One of the most explosive areas of growth in recent years has been cellular phone networks
Firlakuza [10]
That is a true sentence.
4 0
3 years ago
Read 2 more answers
Brief exercise 1-9 at the beginning of the year, morales company had total assets of $816,000 and total liabilities of $526,000.
kramer

<u>Calculation of amount of stockholders' equity at the end of the year:</u>


At the beginning of the year, Morales Company had total assets of $816,000 and total assets increased $178,000 during the year, hence Total Assets at the end of the year shall be 816000+178000 = $994,000


At the beginning of the year, Morales Company had total liabilities of $526,000 and total liabilities decreased $82,000 during the year. Hence Total Liabilities at the end of the year shall be 526000-82000 = $444,000


Now we can calculate amount of stockholders' equity at the end of the year as follows:

Equity = Assets – Liabilities

= 994,000-444,000

= $550,000


Hence, the amount of stockholders' equity at the end of the year shall be <u>$550,000</u>


6 0
3 years ago
Documentation is necessary to establish educational accommodations. true or false​
Karolina [17]

Answer:

True

Explanation:

6 0
3 years ago
Which two advantages do home buyers have over renters?
Snowcat [4.5K]
Answers A and E seem correct. B makes no sense. C makes no sense. and my renters insurance was very cheap vs property insurance.
5 0
3 years ago
Read 2 more answers
By how much does the current GDP rise in the following scenario? A real estate agent sells a house for $250,000 that the previou
Aloiza [94]

Answer:

c. $10,000.

Explanation:

Gross domestic product is the sum total of all goods produced in a country in a given period. Sale of used good are not considered in GDP because the original value of the used item would have been recorded previously as GDP when it was first produced.

Therefore in this scenario the money paid for the house ($250,000) is not considered to be part of GDP since the original value of $90,000 would have been recorded as GDP 10 years ago.

However the commission of $10,000 that the real estate agent collected for his services is considered a contribution to GDP.

8 0
3 years ago
Other questions:
  • Question 2--/1 View Policies Current Attempt in Progress This information relates to Cullumber Co.. 1. On April 5, purchased mer
    6·1 answer
  • Assume that the risk-free rate is 3.5% and that the market risk premium is 4%.What is the required rate of return on a stock wit
    11·1 answer
  • "Carmen owns a 2009 Toyota Camry that has been driven 24,000 miles and, to his knowledge, has no mechanical problems. He offers
    12·2 answers
  • "A ________ is a characteristic providing a legitimate reason why an employer can exclude persons on otherwise illegal bases of
    6·1 answer
  • Americans spend the largest portion of their budget on _____
    13·1 answer
  • Real GDP per capita in the U.S. grew from about​ $6,000 in the year 1900 to about​ $51,500 in​ 2016, an average growth rate of​
    6·1 answer
  • Hannah Roberts owns and operates Hannah's Pool Service Company. On January 1, Hannah Roberts, Capital had a balance of $309,170.
    12·1 answer
  • Beth is a college student looking for summer employment. She has two options. Firm X is employing lifeguards to patrol the beach
    13·1 answer
  • Croissants Corporation and Donuts Company transfer their assets to Edibles Inc., which manages the assets and distributes the pr
    10·1 answer
  • A division reports the following figures: Sales = $14,000; Net income = $2,800; Average assets = $28,000. The division's profit
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!