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

Comments are closed.