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
What are the three main goals of monetary policy?
MakcuM [25]
The three objectives of monetary policy are :
-controlling inflation
-managing employment levels
-maintaining long term interest rates.

Don't forget click ”thanks”♥️ for me
6 0
2 years ago
A company fails to record one storeroom full of inventory in its year-end inventory records. as a result, this will cause:
kirza4 [7]
They will think they don't have enough invintory and order more and will have no room to store the knew orders
3 0
3 years ago
briefly,explain why the depth of floatation of a ship changes when it sails from the Arabian sea to the lndian ocean​
REY [17]

Answer:

change in density of sea water

7 0
3 years ago
Read 2 more answers
A manager's operation had sales this period of $89,775. last period sales were $85,500. what was the manager's percentage sales
alexandr402 [8]

A manager's operation had sales this period of $89,775. last period sales were $85,500. So the manager's percentage sales increase for this period when compared to last period was 5% .

The percentage increase is the measure of the percentage change. The percentage increase is defined as the ratio of increased value to the original value and then multiplied by 100. Here the increased value can be calculated by taking the difference between the final value and the initial value. The formula to calculate increase is given by -

Percentage Increase = [(Final value – Original value) × 100] / Original value %

In this case,  original value is $85500 and the final value is $89775, then the percentage increase is:

Percentage Increase = [(89775-85500) ×100]/85500

= 427500/85500

= 5%

So, the percentage increase  will be 5% .

To learn more about percentage increase here

brainly.com/question/23040788

#SPJ4

5 0
1 year ago
Checking account A charges a monthly service fee of $20 and a wire transfer fee of $3, while checking account B charges a monthl
natali 33 [55]
 the answer should be  
D. 10 
3 0
3 years ago
Read 2 more answers
Other questions:
  • In a financial statement audit performed following AICPA Professional Standards, how frequently must an auditor test operating e
    8·1 answer
  • Suppose Indiana produces only steel and corn, with fixed amounts of land, labor, and capital resources. Which scenario best sets
    12·1 answer
  • A security firm is offered​ $80,000 in one year for providing cctv coverage of a property. the cost of providing this coverage t
    10·1 answer
  • Some of the mangos from your neighbor's mango tree drop into your yard. You don't like mangos and the fallen mangos make it hard
    6·1 answer
  • What is the spirit behind the Federal Sentencing Guidelines for Organizations?
    15·1 answer
  • Supporters of increased social responsibility would most likely say that the goal of a firm is to:_______
    9·2 answers
  • Which of the following will usually be found on an income statement prepared using absorption costing? Contribution Margin Gross
    9·1 answer
  • Discuss the different roles played by the qualitative and quantitative approaches to managerial decision making. Why is it impor
    9·1 answer
  • Headland Company loans Sarasota Company $2,190,000 at 6% for 3 years on January 1, 2020. Headland intends to hold this loan to m
    15·1 answer
  • Knapp Industries began business on January 1, 2018 by issuing all of its 1,550,000 authorized shares of its $1 par value common
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!