if you are someone who works with excel tables regularly, you must have come across…