Excel Trivia #2 Answers

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

  1. How many nested IF statements can you include in a single formula?
    • 64
  2. What is the maximum amount of decimal places Excel can display?
    • 30
  3. 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.
  4. 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
  5. 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.
  6. 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
  7. 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
  8. What is the maximum number of points a row can be in Excel?
    • 409
  9. What is the maximum amount of undo levels?
    • 100
  10. What is the maximum number of items than can be displayed in a filter drop-down list?
    • 10,000
  11. In billions, what is the maximum number of formulas that can depend on a single cell? Hint: Answer between 0-10
    • 4 billion

Comments are closed.