Quizsummary
0 of 50 questions completed
Questions:
 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
Information
Excel Functions Knowledge Quiz (Pass this and you are ready for the next Excel ModelOff)
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 50 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Average score  
Your score 

Categories
 Financial Functions 0%
 General Functions 0%
 Mathematical Functions 0%

Thanks for taking the Excel Functions Knowledge Quiz!
Pos.  Name  Entered on  Points  Result 

Table is loading  
No data available  
 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 Answered
 Review
 Question 1 of 50
1. Question
1 pointsCategory: General FunctionsJoins several text strings into one text string.
Correct
Right, you are Awesome!
Incorrect
Sorry, no you are wrong 🙁 The answer was: CONCATENATE
 Question 2 of 50
2. Question
1 pointsCategory: General FunctionsReturns a specified number of characters from the beginning of a text string.
Correct
Yeah!
Incorrect
No 🙁 The answer was: LEFT
 Question 3 of 50
3. Question
1 pointsCategory: General FunctionsReturns the number of characters in a text string.
Correct
Way to go!
Incorrect
Not so good. The correct answer was: LEN
 Question 4 of 50
4. Question
1 pointsCategory: General FunctionsReturns a specified number of characters from a text string, starting at a specified position.
Correct
YES!
Incorrect
The answer was: MID
 Question 5 of 50
5. Question
1 pointsCategory: General FunctionsCapitalizes the first letter of each word in a text string and converts all other letters to lowercase letters.
Correct
WAHOO!
Incorrect
The answer was: PROPER
 Question 6 of 50
6. Question
1 pointsCategory: General FunctionsReplaces part of a text string with a different text string.
Correct
Good one!
Incorrect
The answer was: REPLACE
 Question 7 of 50
7. Question
1 pointsCategory: General FunctionsReturns a specified number of characters from the end of a text string.
Correct
Oh Yeah!
Incorrect
The answer was: RIGHT
 Question 8 of 50
8. Question
1 pointsCategory: General FunctionsRemoves all extra spaces from a text string except for single spaces between words.
Correct
Great Job!
Incorrect
The answer was: TRIM
 Question 9 of 50
9. Question
1 pointsCategory: General FunctionsReturns the serial number of the date that is a specified number of months before or after the start date.
Correct
OH YEAH!
Incorrect
The answer was: EDATE
 Question 10 of 50
10. Question
1 pointsCategory: General FunctionsReturns the serial number of the last day of the month before or after a specified number of months.
Correct
Right!
Incorrect
The answer was: EOMONTH
 Question 11 of 50
11. Question
1 pointsCategory: General FunctionsReturns the number of whole working days between two dates.
Correct
Yes 🙂
Incorrect
The answer was: NETWORKDAYS
 Question 12 of 50
12. Question
1 pointsCategory: General FunctionsReturns the week number in a year.
Correct
Awesome!
Incorrect
The answer was: WEEKNUM
 Question 13 of 50
13. Question
1 pointsCategory: General FunctionsReturns the serial number of the date before or after a specified number of workdays.
Correct
Yes!
Incorrect
The answer was: WORKDAY
 Question 14 of 50
14. Question
1 pointsCategory: General FunctionsReturns the number of years and fraction of years between two specified dates.
Correct
Way to go!
Incorrect
The answer was: YEARFRAC
 Question 15 of 50
15. Question
1 pointsCategory: General FunctionsExtracts data stored in a PivotTable.
Correct
Correct
Incorrect
The answer was: GETPIVOTDATA
 Question 16 of 50
16. Question
1 pointsCategory: General FunctionsLooks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify.
Correct
Right
Incorrect
The answer was: HLOOKUP
 Question 17 of 50
17. Question
1 pointsCategory: General FunctionsReturns the value or reference to the value of the specified row and column of a table or range.
Correct
Very good.
Incorrect
The answer was: INDEX
 Question 18 of 50
18. Question
1 pointsCategory: General FunctionsReturns the reference specified by a text string.
Correct
Yes
Incorrect
The answer was: INDIRECT
 Question 19 of 50
19. Question
1 pointsCategory: General FunctionsReturns the relative position of an item in a range of contiguous cells in a row or a column that matches a specified value.
Correct
Yes, Yes
Incorrect
The answer was: MATCH
 Question 20 of 50
20. Question
1 pointsCategory: General FunctionsReturns the reference to a single cell or a range of cells that is a specified number of rows and columns from a cell or range of cells.
Correct
Right
Incorrect
The answer was: OFFSET
 Question 21 of 50
21. Question
1 pointsCategory: General FunctionsConverts a vertical range of cells to a horizontal range, or vice versa.
Correct
Yah!
Incorrect
The answer was: TRANSPOSE
 Question 22 of 50
22. Question
1 pointsCategory: General FunctionsReturns TRUE if the value is text.
Correct
Great
Incorrect
The answer was: ISTEXT
 Question 23 of 50
23. Question
1 pointsCategory: Mathematical FunctionsReturns the absolute value of a number.
Correct
Nice
Incorrect
The answer was: ABS
 Question 24 of 50
24. Question
1 pointsCategory: Mathematical FunctionsRounds a number up, to the nearest multiple of significance.
Correct
Great one!
Incorrect
The answer was: CEILING
 Question 25 of 50
25. Question
1 pointsCategory: Mathematical FunctionsReturns the possible number of combinations for a given number of items.
Correct
Right
Incorrect
The answer was: COMBIN
 Question 26 of 50
26. Question
1 pointsCategory: Mathematical FunctionsReturns a number rounded to the nearest even integer away from zero.
Correct
Yes
Incorrect
The answer was: EVEN
 Question 27 of 50
27. Question
1 pointsCategory: Mathematical FunctionsReturns e raised to a power.
Correct
Correct.
Incorrect
The answer was: EXP
 Question 28 of 50
28. Question
1 pointsCategory: Mathematical FunctionsReturns the factorial of a number.
Correct
Yes
Incorrect
The answer was: FACT
 Question 29 of 50
29. Question
1 pointsCategory: Mathematical FunctionsReturns a number rounded towards zero to the nearest multiple of a specified number.
Correct
Way to Go! Yes
Incorrect
The answer was: FLOOR
 Question 30 of 50
30. Question
1 pointsCategory: Mathematical FunctionsRounds a number down to the nearest integer.
Correct
Right!!
Incorrect
The answer was: INT
 Question 31 of 50
31. Question
1 pointsCategory: Mathematical FunctionsReturns the natural logarithm of a number.
Correct
Yes!
Incorrect
The answer was: LN
 Question 32 of 50
32. Question
1 pointsCategory: Mathematical FunctionsReturns the logarithm of a number to the base specified.
Correct
Correct.
Incorrect
The answer was: LOG
 Question 33 of 50
33. Question
1 pointsCategory: Mathematical FunctionsReturns the remainder after a number is divided by a specified divisor.
Correct
Right!
Incorrect
The answer was: MOD
 Question 34 of 50
34. Question
1 pointsCategory: Mathematical FunctionsReturns a number rounded up or down to the nearest multiple of a specified number.
Correct
Awesome!
Incorrect
The answer was: MROUND
 Question 35 of 50
35. Question
1 pointsCategory: Mathematical FunctionsReturns a number rounded to the nearest odd integer away from zero.
Correct
Incorrect
The answer was: ODD
 Question 36 of 50
36. Question
1 pointsCategory: Mathematical FunctionsReturns the value of pi.
Correct
Good one!
Incorrect
The answer was: PI
 Question 37 of 50
37. Question
1 pointsCategory: Mathematical FunctionsReturns the result of a number raised to a specified power.
Correct
Right
Incorrect
The answer was: POWER
 Question 38 of 50
38. Question
1 pointsCategory: Mathematical FunctionsReturns a random draw from a uniform distribution between two specified numbers.
Correct
Right! Good job!
Incorrect
The answer was: RANDBETWEEN
 Question 39 of 50
39. Question
1 pointsCategory: Financial FunctionsReturns the accrued interest for a security that pays periodic interest.
Correct
Yes
Incorrect
The answer was: ACCRINT
 Question 40 of 50
40. Question
1 pointsCategory: Financial FunctionsReturns the depreciation of an asset for a specified period using the fixed–‐declining balance method.
Correct
Right
Incorrect
The answer was: DB
 Question 41 of 50
41. Question
1 pointsCategory: Financial FunctionsConverts the dollar price expressed as a fraction into a dollar price expressed as a decimal number.
Correct
Yes, great answer.
Incorrect
The answer was: DOLLARDE
 Question 42 of 50
42. Question
1 pointsCategory: Financial FunctionsReturns the effective annual interest rate given the nominal annual interest rate and the number of compounding periods per year.
Correct
Yes
Incorrect
The answer was: EFFECT
 Question 43 of 50
43. Question
1 pointsCategory: Financial FunctionsReturns the future value of a constant annuity.
Correct
Right.
Incorrect
The answer was: FV
 Question 44 of 50
44. Question
1 pointsCategory: Financial FunctionsReturns the interest payment for a specified period of an annuity.
Correct
Great answer, Right.
Incorrect
The answer was: IPMT
 Question 45 of 50
45. Question
1 pointsCategory: Financial FunctionsReturns the internal rate of return for a series of cash flows that occur at equal intervals but are not necessarily equal.
Correct
Right, great one!
Incorrect
The answer was: IRR
 Question 46 of 50
46. Question
1 pointsCategory: Financial FunctionsReturns the modified internal rate of return for a series of cash flows that occur at equal intervals but are not necessarily equal.
Correct
Right.
Incorrect
The answer was: MIRR
 Question 47 of 50
47. Question
1 pointsCategory: Financial FunctionsReturns the price per $100 face value of a coupon paying security at a specified yield.
Correct
Good one, right!
Incorrect
The answer was: PRICE
 Question 48 of 50
48. Question
1 pointsCategory: Financial FunctionsReturns the interest rate per period for a constant annuity.
Correct
Yes
Incorrect
The answer was: RATE
 Question 49 of 50
49. Question
1 pointsCategory: Financial FunctionsReturns the internal rate of return for a series of cash flows that are not necessarily equal or periodic.
Correct
Awesome job, that was a tough one!
Incorrect
The answer was: XIRR
 Question 50 of 50
50. Question
1 pointsCategory: Financial FunctionsReturns the present value of a series of unequal future cash flows that occur at equal intervals starting one period in the future.
Correct
Yes
Incorrect
The answer was: NPV
.
Hi Sandra, perhaps do one of the...
Steve I can't get the negative numbers...
Hi Shamsheer, i am not sure how to help....
I'm trying to do option two in excel...
Hi Chris, i would guess that you have...
Great tutorial. When I change the gap...
Hi Wyn, if you mean how can i change a...
Hi Brian, i have sent you a file to...
How do we activate the slider on the bar...
Afternoon Steve, I have come across your...
Thanks Eric!!!
Hi Barb, hope you got it fixed. I don't...
Very Good explanation, Thank you very...
Hi, Did this (horizontal) on my Excel...
Hi Alex, I have sent you an email to see...
Hi Rob, thanks for your nice comment. ...