Archive for June, 2020

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

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

Excel Trivia #1 Answers

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

  1. In 1985, the first Microsoft Excel program was released for what operating system?
    • MacIntosh System Software
    • Excel came out for windows in 1987
  2. What tool within Excel allows a user to split a cell’s information into several columns, either based on a fixed point or based on the occurrence of a character, such as a comma or a space?
    • Text to Columns
  3. The music video for the 2002 song “Dilemma,” features one character attempting to message another via Microsoft Excel on a Nokia 9210 Communicator phone. Name the performers. 1 point for main artist; 1 point for featuring artist.
    • Nelly ft. Kelly Rowland
  4. Beginning with Excel 2007, the default filetype for Excel Workbooks (XML-based files) was changed to .xlsx . What was the previous file extension?
    • .xls
  5. What anthropomorphic object was the default “Office Assistant” introduced with Microsoft Office 1997?
    • Clippit aka Clippy
  6. What is the latest in time Excel’s date range extends to?
    • 12/31/9999
  7. As of Excel 2016, how many functions (SUM, VLOOKUP, IF, etc.) does Excel have?   A) 124 B) 360 C) 484 D) 512    C) 484
  8. What competitor of Microsoft Excel has the limitations of i) 200 tabs maximum; ii) limited functionality of shortcuts and function keys; and iii) a specific email extension is required to create a file?
    • Google Sheets
  9. What fictitious date does Excel include in its programming, for the purpose of bug compatibility with earlier programs?
    • 2/29/1900
    • Leap Day is skipped every 100 years except every 400 years. Competing software Lotus 1-2-3 did not program the skipped Leap Day of 1900 in order to save space. The original Excel did the same to maintain consistency and it still lives on today
  10. Which of the following is NOT a Microsoft Office font: Wingdings, Gulim, Dagoosh, Gadugi?
    • Dagoosh

Excel Trivia #1

Wow your employer (current or prospective) or your peers/spouse with your Excel knowledge.  We are going to post a series of Excel Trivia questions for you and your friends to enjoy (at least this is what geeks like our analysts do on their free time)!  Here you go:

  1. In 1985, the first Microsoft Excel program was released for what operating system?
  2. What tool within Excel allows a user to split a cell’s information into several columns, either based on a fixed point or based on the occurrence of a character, such as a comma or a space?
  3. The music video for the 2002 song “Dilemma,” features one character attempting to message another via Microsoft Excel on a Nokia 9210 Communicator phone. Name the performers. 1 point for main artist; 1 point for featuring artist.
  4. Beginning with Excel 2007, the default filetype for Excel Workbooks (XML-based files) was changed to .xlsx . What was the previous file extension?
  5. What anthropomorphic object was the default “Office Assistant” introduced with Microsoft Office 1997?
  6. What is the latest in time Excel’s date range extends to?
  7. As of Excel 2016, how many functions (SUM, VLOOKUP, IF, etc.) does Excel have?
  8. What competitor of Microsoft Excel has the limitations of i) 200 tabs maximum; ii) limited functionality of shortcuts and function keys; and iii) a specific email extension is required to create a file?
  9. What fictitious date does Excel include in its programming, for the purpose of bug compatibility with earlier programs?
  10. Which of the following is NOT a Microsoft Office font: Wingdings, Gulim, Dagoosh, Gadugi?

Answers will be posted tomorrow!