In an interview for an internship, I was asked if I knew how to use pivot tables excel, I said "of course". I did not even know what pivot tables were. thought about going home and looking it up, but I never got the internship so I never had to look it up. Still don't know what they are used for. Atleast I know they exist now.