April 27

# Excel Tables – What name did they used to go by? – Excel Challenge

First off let’s chat about the previous episode’s challenge.  Jordan asked

What function sounds like a number but returns a date

If you are the type of person that enjoys a trip down memory lane, you can find the previous episode’s challenge here

Here’s the thing.  Nobody won.  No one.  Nada.   Zilch.

It appears that the answer was SECOND.  Get it?  SECOND.

Yea – Me neither.

Which means we likely have a problem with our question selection matrix that we use at Excel.TV headquarters.  There was some questionable sriracha sauce found near the machinery.

## But today is another day

Yes you have another chance.

Now, we all love Excel Tables.  It is rare for an episode goes by where we aren’t hawking one of our favorite books by Zack Barresse and Kevin Jones on Excel Tables <— just did it again

Jordan’s Excel Challenge matrix came back with a doozie this time.

### Before they were called Excel Tables, What name did they go by?

Hint… the answer isn’t SECOND

## Leave Your Guess in the Comments Section

You could win a slightly used beer coozie.  Or possibly something completely different. 🙂

Tags

## 51: Oz du Soleil & the Global Excel Summit 2021

51: Oz du Soleil & the Global Excel Summit 2021

## Global Excel Summit 2021

Global Excel Summit 2021
• In 2003, the precursor to Tables were introduced as Lists, and in VBA they’re still known as ListObjects.

• Ahhh……you beat me to it Jon. Well, nothing wrong with losing to an Excel legend I guess.

• Reminder: The prize is awarded randomly from all those who answered correctly.
My computer says the answer is 42

• Ryan Tretter says:

They were previously known as Lists.

• Congratulations! You are the challenge winner! Please email jpo645 (@) gmail (.com) to collect your prize.

• {"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.