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

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?

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

Tags

August 6, 2019

How to Create a Relative File Path in Power Query

How to Create a Relative File Path in Power Query

June 21, 2012

Interactive Periodic Table of Elements in Excel

Interactive Periodic Table of Elements in Excel

December 5, 2014

A method for quickly importing and working with CSV files (part 2)

A method for quickly importing and working with CSV files (part 2)

April 27, 2015

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

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

December 8, 2015

39: Power Query Book Author Ken Puls

39: Power Query Book Author Ken Puls

January 14, 2016

How To Make A Calendar Table With Power Query – Excel Tips

How To Make A Calendar Table With Power Query – Excel Tips
• 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.

• MF says:

Lists.
But I doubt how many people used that Lists before. @_@