222222

222222

Professional Development

33 Qs

quiz-placeholder

Similar activities

PROPERTY LAW WEEK 1

PROPERTY LAW WEEK 1

Professional Development

38 Qs

*Solar System History*

*Solar System History*

KG - Professional Development

38 Qs

PRACTICE TEST 1- HEXAWARE TECHNOLOGIES - 17-8-2020

PRACTICE TEST 1- HEXAWARE TECHNOLOGIES - 17-8-2020

Professional Development

30 Qs

Friday level set | 26th April

Friday level set | 26th April

Professional Development

28 Qs

disney movies

disney movies

KG - Professional Development

30 Qs

roblox quiz

roblox quiz

2nd Grade - Professional Development

29 Qs

BMS CF QUIZ

BMS CF QUIZ

1st Grade - Professional Development

29 Qs

222222

222222

Assessment

Quiz

Other

Professional Development

Medium

Created by

sachin mittal

Used 3+ times

FREE Resource

33 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which excel function returns the loan payment (principal plus interest) per period, assuming constant payment?
Rate
IPMT
PMT
PPMT

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What is correct syntax of IPMT function?
IPMT(rate, per, nper, pv, fv, type)
IPMT(per,rate, nper, pv, fv, type)
IPMT(nper,rate, per, pv, fv, type)
IPMT(pv,rate, nper, per, fv, type)

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of the following PMT function will return the monthly payment amount for a 5,000 loan with a 6 percent annual percentage rate. The loan has a term of four years
PMT(.06, 48, -5000)
PMT(.06, 4, -5000)
PMT(.06/12, 48, 5000)
PMT(.06/12, 48, -5000)

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of the following excel function will help to calculate the CAGR?
NPV
IRR
Rate
PV

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

if a bank has deposit scheme to deposit 1000 for 120 months and on maturity your money will be double. What is the annual rate of interest?
0.1011
0.111
0.1272
0.145

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

if rate of interest on deposit is 10% PA compunding quarterly and if you deposit 10000 in the bank. In approx how many years your money will be double?
6
7
5
8

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

If a maturity amount of a fixed depoist is 20000, duration is 5 year and rate is 12%. What is deposit amount?
10000
11348
12438
12000

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?