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
Polls to answer :
horsena [70]
Age: 15
oldest age: 16
siblings: 1
7 0
3 years ago
The Next Monet, Inc., operated art schools. At one of its classes, John Picasso (no relation to the great artist) was praised by
Schach [20]

Answer:

Option B                            

Explanation:

In simple words, The given case is related to the conclusion made by the court in the famous case of  Vokes versus Arthur MurrayLinks, in which the jury in the court rules that,  a determination of a party carrying better information about a subject matter may be treated as a matter of fact even though it would be treated as an opinion if the parties were speaking for deal  on equal conditions.

7 0
3 years ago
Marvin was interested in how his target market spends money around the November/December holidays. He first reviewed existing da
andrezito [222]

Answer: secondary data

Explanation:

The type of data above is refered to as a secondary data. Secondary data simply refers to the data that have already been gotten or collected from the past.

Unlike the primary data, which is collected by the individual, secondary data have already been done in the past. Since he first reviewed existing data on seasonal spending collected by the government, this is a secondary data

3 0
2 years ago
Transferring responsibility of operations to another authority (such as, un observers, multinational peacekeeping forces, or nat
Helen [10]

I believe the answer is: Enable phase

During the enable phase, a company would evaluate the progess and determine additional planing necessary to ensure that the operation run smoothly. Often times, transferring responsibilities to another organization that had larger jurisdiction would be seen as a more appropriate decision.

8 0
3 years ago
A nation can achieve higher economic growth if: Select one: a. it devotes more resources to research and development. b. the pro
Evgen [1.6K]

Answer:

The correct answer is A

Explanation:

Economic growth is defined as the rise in the capacity of the economy for producing or manufacturing the goods and services as compared from one year to another.

And the economic growth is determined in terms of GNP (Gross National Product) or in terms of GDP (Gross Domestic Product).

So, if the nation want to accomplish the higher level of economic growth, then the nation should devote more amount of resources in R & D (research and development).

5 0
3 years ago
Other questions:
  • When your Mac is turned on, this application is always running.
    15·2 answers
  • If the government sets out to make home buying easier for more people by forcing lenders to accept ____________ down payments an
    10·1 answer
  • A cartel differs from a monopoly in that
    12·1 answer
  • When oil prices go up, we tend to see less investment by consumers in _____________________.
    15·2 answers
  • t's Manuel again. But now that we are getting to know him, we just call him Manny. So....Manny gets called in to work seven days
    6·1 answer
  • How do my educational choices connect with my long-term goals and vision for life?
    5·1 answer
  • 1. Sharon, a newly engaged woman, saw an advertisement in a bridal magazine for a beautiful pearl necklace priced at $69.99 from
    14·1 answer
  • Write the president (me) a memo explaining your reasoning and suggest a new pricing strategy. (You can decide what kind of busin
    13·1 answer
  • Qué son los anticuerpos <br>​
    9·2 answers
  • If a firm's marginal tax rate is increased, this would, other things held constant, lower the cost of debt used to calculate its
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!