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
As the executive of a bank or thrift institution you are faced with an intense seasonal demand for loans. Assuming that your loa
solniwko [45]
I believe u should not give put loans at all ,or make the interest rate very low so they 'll have a better chance to pay it off
5 0
3 years ago
Two investment advisers are comparing performance. Adviser A averaged a 20% return with a portfolio beta of 1.5, and adviser B a
Agata [3.3K]

Answer:

Option A is the correct answer.

A. Advisor A was better because he generated a larger alpha.

Explanation:

To determine which adviser would be the better stock selector, we will calculate the required rate of return of each adviser and the return actually averaged. The adviser with the greater abnormal return, which is return in excess of required rate, will be the better stock selector.

Using the CAPM, we can calculate the required rate of return on a stock. This is the minimum return required by the investors to invest in a stock based on its systematic risk, the market's risk premium and the risk free rate.

The formula for required rate of return under CAPM is,

r = rRF + Beta * (rM - rRF)

Where,

  • rRF is the risk free rate
  • rM is the market return

r of Adviser A = 0.05 + 1.5 * (0.13 - 0.05)

r of Adviser A = 0.17 or 17%

Abnormal or excess return of Adviser A = 20% - 17% = 3%

r of Adviser B = 0.05 + 1.2 * (0.13 - 0.05)

r of Adviser B = 0.146 or 14.6%

Abnormal or excess return of Adviser B = 15% - 14.6% = 0.4%

Adviser A performed better as the excessive return or alpha of Adviser A was 3% while that of Adviser B was 0.4%

7 0
2 years ago
____ is called the "first" management function because all other management functions depend on it.
Papessa [141]

Answer:

D

Explanation:

A statement of the basic purpose that makes the organization different from others.

8 0
3 years ago
Read 2 more answers
What is the meaning of statistics??​
Nookie1986 [14]

Explanation:

1 : a branch of mathematics dealing with the collection, analysis, interpretation, and presentation of masses of numerical data. 2 : a collection of quantitative data.

4 0
3 years ago
Read 2 more answers
What is the difference between a nominal value and a real value?a. A nominal value is measured in monetary units adjusted for in
Allushta [10]

Answer:

In economics, nominal value refers to the current monetary value and does not adjust for the effects of inflation

Explanation:

6 0
3 years ago
Other questions:
  • Which one of the following items would you be most likely to keep in a database ?
    15·2 answers
  • A shoe manufacturer pays part of the media bill when a local shoe store features the manufacturer's brand in its advertising. wh
    6·1 answer
  • Failure to prepare an adjusting entry at the end of a period to record an accrued revenue would cause:A)net income to be oversta
    8·1 answer
  • Sox Corporation purchased a 30% interest in Hack Corporation for $ 1,725,000 on January 1, 2018. On November 1, 2018, Hack decla
    12·1 answer
  • Consider the market for Ping golf clubs. Suppose the price of memberships at local golf courses increases. Assume memberships at
    7·1 answer
  • Digital marketing isn't just about selling your products internationally. It can be used to great effect for local businesses. W
    13·1 answer
  • Custom Homebuilders (CH) designs and constructs high-end homes on large lots owned by customers. CH has developed several formul
    7·1 answer
  • Suppose you buy lunch for $15.40 that includes a 8% sales tax. How much did the restaurant charge you for the lunch (excluding a
    6·1 answer
  • The following information is available for the pension plan of Swifty Company for the year 2020.
    8·1 answer
  • ASAP!! Discuss Maslow’s Hierarchy of Needs Theory. In your opinion, is it a good motivator for employees to
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!