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
choose a real or made-up example of a company, and describe at least three variable costs the company has. (1-3 sentences.
Solnce55 [7]
For a restaurant, some variable costs could be labor costs/ worker wages, raw product/ purchasing food to cook, and energy and fuel/ utilities.
7 0
3 years ago
Selected operating data for two divisions of Outback Brewing, Ltd., of Australia are given below: Division Queensland New South
Svet_ta [14]

Answer:

1. Quuen Land Division

Margin 6.50%

ROI 11.70%

New South Wale Division Margin

Margin 3.50%

ROI 15.75%

2. New South wale Division

Explanation:

1. Computation for each division's margin, turnover, and return on investment (ROI)

QUUEN LAND DIVISION MARGIN

Using this formula

Margin =Net operating income/Total Sales

Let plug in the formula

Margin =$70,200/ $ 1,080,000

Margin=6.50%

QUUEN LAND DIVISION ROI

First step is to determine the Turnover using this formula

Turnover=Total sales/Average Asset

Let plug in the formula

Turnover= $ 1,080,000 /$600,000

Turnover =1.8 times

Now let determine the ROI using this formula

ROI =Margin * Turnover

Let plug in the formula

ROI=6.50%*1.8

ROI=11.70%

NEW SOUTH WALE DIVISION MARGIN

Margin =$ 83,475 / $ 2,385,000

Margin=3.5%

NEW SOUTH WALE DIVISION ROI

First step is to determine the Turnover using this formula

Turnover=Total sales/Average Asset

Let plug in the formula

Turnover= $ 2,385,000 /$530,000

Turnover =4.5 times

Now let determine the ROI using this formula

ROI =Margin * Turnover

Let plug in the formula

ROI=3.5%*4.5

RO1=15.75%

2. Based on the above calculation the divisional manager that seems to be doing the better job

Is NEW SOUTH WALE DIVISION because the ROI is greater.

3 0
3 years ago
Punitive damages: a. are a small amount of compensation given to the plaintiff. b. are like actual damages but do not seek to de
lukranit [14]

Answer:

The correct answer is letter "D": are damages in excess of the plaintiff's injuries, awarded to punish the defendant.

Explanation:

Punitive Damages are penalties passed to the defendant of court cases on top of compensations they must pay to plaintiffs because of the faults they committed. The punitive damage is not provided to the plaintiffs but is imposed to punish defendants when their faults are negligent and should not be repeated.  

Thus, <em>punish damages are imposed in an attempt to avoid other individuals to commit the same gross faults.</em>

6 0
3 years ago
Identify the three components of retained earnings.
Hoochie [10]
The beginning period retained earnings, net profit/net loss made during the accounting period, and cash and stock dividends paid during the accounting period. (i may be wrong because there was no picture but i this is right)
5 0
2 years ago
Mitch, a single taxpayer, earns $100,000 in taxable income and $10,000 in interest from an investment in city of Birmingham Bond
Ivan

Answer:

The answer is: $18,289.50

Explanation:

The interest earned from the investment in Birmingham Bonds is not included in Mitch's gross income.

If Mitch earned $100,000, so he will fall under the fourth bracket for single filers.

He will have to pay $14,089.50 plus 24% of any income over $82,500.

taxes due = $14,089.50 + [($100,000 - $82,500) x 24%]

taxes due = $14,089.50 + $4,200 = $18,289.50

6 0
3 years ago
Other questions:
  • Which of the following subjects should you study uif your seeking a career in agriculture or natural resources select all that a
    5·1 answer
  • During the first two years, Supplies, Inc. drove the company truck 15,000 and 22,000 miles, respectively, to deliver merchandise
    7·1 answer
  • If the seller fails to provide the property disclosure statement to the buyer before the buyer signs the purchase contract,
    7·1 answer
  • King corporation owns machinery with a book value of $760,000. It is estimated that the machinery will generate future cash flow
    14·1 answer
  • what is the first action you should take if you suspect there has been a fraudulent charge on your credit card?
    7·2 answers
  • Levi Corporation (a U.S. company) has several transactions with foreign entities. Each transaction is denominated in the local c
    13·1 answer
  • Bob's electronics company has quite a buzz around a new television they're launching, called UltraView1000. This television is e
    10·1 answer
  • Both individuals and organizations can be consumers.<br> O True<br> O False
    10·1 answer
  • Suppose there were several large outstanding checks on the year-end bank reconciliation that did not clear the bank by the cutof
    8·1 answer
  • When manufacturing companies sell their finished products, the costs of those finished products are removed from inventory and e
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!