Excel Quiz 20 Posted on September 5, 2015September 25, 2021 by Vijay A. Verma Quiz 20 This is a general quiz to test your Excel knowledge. There are a total of 10 questions to answer. To pass, you need to answer at least 6 questions correctly. Please fill in your Name & Email to take the Quiz (Name and E Mail are not shared with anybody else. E Mail is used to mail the pdf certificate to you when you pass) 1 / 10 What would be the answer for =DOLLARDE(78.15,2) 78.152 78.075 39.08 78.75 2 / 10 Returns the future value of an investment FV FValue FVal Final 3 / 10 I want to know the annual rate of interest for an amount $1000 to become $2000 in 5 years. Which Excel function can be used? CPMT RRI IR IRR 4 / 10 In below picture, what would be the answer for =MATCH("2012",A1:A8) 3 0 #N/A 8 5 / 10 Which function in Excel is used to calculate EMI? CEMI EMI PMT PMR 6 / 10 This function returns the interest payment for an investment / loan for a given period TIPMT INTR IPMT CINTR 7 / 10 To calculate the number of periods of an investment or a loan which function can be used? NDUR DURATION PER NPER 8 / 10 Returns the net present value of an investment based on a series of periodic cash flows and a discount rate NPV NETPV NIPV FV-PV 9 / 10 Returns the straight-line depreciation of an asset for one period SDP SLN DDB SYN 10 / 10 In the below picture, what would be the answer for =LARGE(B2:B8,3) 41 5 47 23 Your score is LinkedIn Facebook Twitter Retake quiz Exit
