All categories

3 years ago

What Are The Steps For Subtotaling Data

Business

1 answer:

vovikov84 [41]3 years ago

7 0

Answer:

Follow these steps to add subtotals to a list in a worksheet:

Sort the list on the field for which you want subtotals inserted.

Click the Subtotal button in the Outline group on the Data tab. ...

Select the field for which the subtotals are to be calculated in the At Each Change In drop-down list.

Explanation:

google hope this helps you

You might be interested in

What is delinquency? How does this affect your credit score?

Naya [18.7K]

<span>Minor crime, especially that committed by young people.I think i have thought is it affect by even can young people can not do the committed crime.</span>

8 0

4 years ago

The stock of ABD, Inc. has a beta a 1.5 and an expected return of 11.6 percent. The expected return on the market is 11 percent.

GaryK [48]

Answer:

im sorry

Explanation:

8 0

3 years ago

Why is using cash unhelpful when a person wants to apply for a loan in the near future?

____ [38]

It is unhelpful and non-beneficial because always using cash will result in you having no credit history so banks would not be able to see how reliable you are in paying back a loan

7 0

3 years ago

cost $24,000 with a six-year life and no salvage value. The company expects to sell the machine's output of 3,000 units evenly t

Vikentia [17]

Answer:

4 years

Explanation:

The computation of the payback period is shown below:

Payback period is

= Cost of a Machine ÷ Annual cash flow

where,

Cost of a machine = $24,000

And, the annual cash flow is

= Net Income + Depreciation expense

= $2,000 + $4,000

= $6,000

Now placing these values to the above formula

So, the payback period is

= $24,000 ÷ $6,000

= 4 years

7 0

3 years ago

g If you could reinvest the cash flow stream of $798, $508, $509, $967, $503, $1,362, $1,015, and $1,387 at 8.6% interest, how m

s2008m [1.1K]

Answer:

$4,707.92

Explanation:

Present value is the sum of discounted cash flows

Present value can be calculated using a financial calculator

Cash flow in year 1 = $798

Cash flow in year 2 = $508

Cash flow in year 3 = $509

Cash flow in year 4 = $967

Cash flow in year 5= $503

Cash flow in year 6 = $1,362

Cash flow in year 7 = $1,015

Cash flow in year 8 = $1,387

I = 8.6%

Present value = $4,707.92

To find the PV using a financial calculator:

1. Input the cash flow values by pressing the CF button. After inputting the value, press enter and the arrow facing a downward direction.

2. after inputting all the cash flows, press the NPV button, input the value for I, press enter and the arrow facing a downward direction.

3. Press compute

5 0

3 years ago