Microsoft Excel

There are many kinds of charts you can make with numeric data. The most commons ones are bar charts, line charts, column charts and pie charts. There are many other specialised charts too. It depends on the kind of data you have and what you want to do with it.

That would depend on where your prices are on your sheet and how many you have. You could use the + to add some together, or you could use the SUM function. Say you had just four prices, in cells C2, C3, C4 and C5, then you could do it in either of these ways:

=C2+C3+C4+C5

=SUM(C2:C5)

You would have to adapt that to your own requirements.

You would use the PMT function.

= PMT ( rate , nper , pv , fv , type )

rate - the annual interest rate for the loan.

nper - the total number of payments for the loan.

pv - the present value or the amount borrowed or the "principal of the loan.

fv - future value - for a loan this will be 0.

type - indicates when payments are due:

"0" (or omitted) - at the end of the period ie: end of the month.

"1" - at the beginning of the period ie: beginning of

B12 is a relative reference.

The Undo is done by pressing Ctrl - Z.

A heading to be used like a field in Excel, and a little arrow enabling you to open a dropdown list to choose values to show.

Yes, you can do that. It can be referred to as "What if?" and it can use the Scenario Manager.

Assumptions or variable.

grouping

Press Enter or click somewhere other than the tab you are changing.

On the Internet or viewed by a Web browser.

Type yoT(9) = 540 - 81ur answer here...