Excel Trivia – Quiz about the History of Excel & Spreadsheets

Excel Trivia

Four Excel MVPs test their Excel knowledge in this competition.  Excel trainer and consultant Szilvia Juhasz served as host for the segment titled “Wait, Don’t Excel Me”.

The contestants:

The Trivia Questions

Many of the questions were derived from Bill Jelen’s book “The Spreadsheet at 25”.

  1.  Name these two prominent figures in Excel history?
  2. In the 1960’s, Berkeley Professor Robert Mattessich used what programming language to build a what-if style budgeting application?
    • Fortran
  3. In 1975, the Texas Instruments T1-10 calculator costs _____ ?
    • $50
  4. Describe the hidden events on Chandoo’s History of Excel graph – the Excel version and at least one feature.  The graph indicates 1990 and a993
    • 1990 – Excel 3 with 3-D charts
    • 1993 – Excel 5 with VBA
  5. What is this?  picture indicates early version of Visicalc that looks more like a very old version of Pong.
    • VisiCalc
  6. Match that Excel guy.  Various pictures of from the history of Excel and Spreadsheets including Bob Umlas.
    • C – Charles Simonyi – Lead Excel / Word app developer
    • A – Doug Klunder – Microsoft programmer
    • B – Bob Umlas – Longest running Excel MVP
    • N/A – Dan Bricklin, Inventor of Visicalc
    • G – Bob Frankston, inventor of Visicalc
    • I – Steve Ballmer, former Microsoft executive
  7. =ROWS (A:A) * COLUMNS (1:1) yields _____?
    • 17,179,869,184
  8. What Excel function can be used to replicate alternate row shading effect with conditional formatting?
    • MOD()
  9. Name as many Excel MVPs as you can in the next 30 seconds (excluding yourselves).
  10. Who is dubbed the “Father of the Pivot Table”?
    • C – Pito Salas
  11. Which company famously takes credit for the invention of the Pivot Table?
    • A – Lotus
  12. Before the term “Pivot Table” was invented, the project was originally called _________?
    • Lotus Improv

How would you have answered these questions?

Leave your comments below.


You may also like

February 17, 2022

Edit Excel Formulas in WORD – Spreadsheet Tips and Tricks

February 8, 2021

51: Oz du Soleil & the Global Excel Summit 2021

January 29, 2021

Global Excel Summit 2021

January 22, 2021

50: Randy Austin – Excel for Freelancers

January 8, 2021

49: Theresa Estrada – Microsoft Principal Program Manager Lead

May 26, 2020

All Excel LOOKUPs Explained
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Free Power User Quick Guide

Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.