Question: 1 . Which Excel cell entry will calculate the square root of 1 6 5 ? = SQRT [ 1 6 5 ] SQRT (

1. Which Excel cell entry will calculate the square root of 165?
=SQRT[165]
SQRT(165)
SQR(165)
=SQRT(165)
2. Which statements about Excel's FV function are correct?
The FV function has five arguments, and their abbreviations are rate, nper, pmt, pv, and type.
If the number for the pmt argument is entered as a positive value and the pv value is zero, the FV value is negative.
If the interest rate is 10%, the rate argument can be entered as .1 or 10%.
All of the options are correct.
3. Which fields are required to calculate net present value (NPV) in Excel?
Rate of return and cash flows for each year
Average cash flow and future value
Future value and rate of return

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!