Here are the answers to yesterday’s Excel trivia questions:

- How many nested IF statements can you include in a single formula?
**64**

- What is the maximum amount of decimal places Excel can display?
**30**

- What is the maximum amount of digits Excel can use in its calculations?
**15****A number can contain more than 15 digits, but Excel only calculates up to 15 significant digits.**

- Do Excel’s random number generator functions generate pseudo or true random numbers?
**Pseudo****Because Excel’s random number generator is a program not dependent on outside factors, if you have the code and the starting point you can predict what the result will be. Also, after a while the outcomes start to result in a pattern. Therefore, not truly random**

- What is the difference between the MAX and LARGE functions?
**MAX returns the maximum value, whereas LARGE can be set to find highest, second highest, etc.**

- The column width corresponds to the number of characters that can be displayed in a cell formatted with the standard font. What is the maximum column width Excel allows?
**255**

- Row height is measured by “points.” How many points are equal to one (1) inch?
**72****The Point unit of measurement is a holdover from typography. The standard adopted for computers is 72 points to an inch**

- What is the maximum number of points a row can be in Excel?
**409**

- What is the maximum amount of undo levels?
**100**

- What is the maximum number of items than can be displayed in a filter drop-down list?
**10,000**

- In billions, what is the maximum number of formulas that can depend on a single cell? Hint: Answer between 0-10
**4 billion**