Excel Trivia #2

This week’s Excel trivia questions are as follows:

  1. How many nested IF statements can you include in a single formula?
  2. What is the maximum amount of decimal places Excel can display?
  3. What is the maximum amount of digits Excel can use in its calculations?
  4. Do Excel’s random number generator functions generate pseudo or true random numbers?
  5. What is the difference between the MAX and LARGE functions?
  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?
  7. Row height is measured by “points.” How many points are equal to one (1) inch?
  8. What is the maximum number of points a row can be in Excel?
  9. What is the maximum amount of undo levels?
  10. What is the maximum number of items than can be displayed in a filter drop-down list?
  11. In billions, what is the maximum number of formulas that can depend on a single cell? Hint: Answer between 0-10

Comments are closed.