Loan payment calculations and net present value calculations are formulas found in the ________ category of functions.
A) logical
B) statistical
C) financial
D) math & trig

Question

Quizplus · Accepted Answer

Loan payment calculations and net present value calculations are commonly used in finance, thus they fall under the financial category of functions in Excel. The logical category deals with formulas related to true/false or yes/no conditions. The statistical category involves formulas related to statistical analysis. The math & trig category includes basic mathematical functions, trigonometry, and logarithmic functions.

Loan Payment Calculations and Net Present Value Calculations Are Formulas