here is the exercise:
A bank makes an announcement for an HP Compaq notebook with the following offer:
Repayment in 36 monthly installments of USD 57
or Repayment in 24 monthly installments of USD 82.
What is Cash Value of this Notebook? (PV)
I need to use functions to get the annual rate and the present value, functions such as (=rate ; =pmt ; etc,...)
You can use the Excel plugin 'Solver' tp to solve transportation problems which will then be available under Tools menu in Excel
my answer was 53
With Microsoft Excel, you can solve math problems (basic and scientific) and use and create graphs. If you have Word, than you should have Excel.
A formula is a statement. It's not a problem or an exercise to which a solution is needed.
A formula is a statement. It's not a problem or an exercise to which a solution is needed.
Give us the problem, and we'll help you solve it.
It depends on what you are trying to solve. There are many thousands of remedies to various problems using MS Excel. Maybe you should use a word other than "remedies" for this question.
it is a problem because an exercise is something that you do to get good practice with it, while a problem is more like a puzzle that you need to solve.
It ia a update of Microsoft Excel 2003. A spreadsheet program that will also create graphs and solve equations
These questions are meant to be used as a school-wide exercise. Your teacher should explain the solution after everyone has had a chance to solve it.
Because if you are around other people when performing the exercise, that is an excellent opportunity to interact and enjoy friendly contact with others; if you should excel or attain high scores during the exercise, that would indeed be a boost to your self-image and self-esteem.
Excel has a category of functions that deal with statistics. There are a large amount of functions in that category. Some are very simple, like the AVERAGE function and some are much more specialised and complex. Those functions cover a wide range of statistical areas and can be used to solve many statistical problems. Dealing with statistics is a large area of what Excel does.