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 Sulan, I would recommend this setup...
Hi Dennis, Are you thinking about a...
Hi Steve, Do you have a way to create...
Thanks for the AWESOME comment Simone. ...
Haters are going to hate, especially...
Hi Shahaf, you should show all 4 axes in...
thanks so much for the tip i tried for...
Thanks for the great comment. Much...
Thanks for this.
Hi Todd, if you have Excel 2013 or 2016,...
Thanks Tara, so glad to help!. I...
Hi Steve, My chart is to show bags...
Thanks Steve! I used method 3 which I...
Is there a way to do that without having...
Thanks for the epic comment Steve! So...
Steve  Steve, here, too... back in...