How could a custom smart tag make some specific Excel computing tasks easier?

Answer 1

What it means is that a person write a whole bunch of macros, create either a button, custom menu or icon to launch it with a single click. Saves hours and hours of repetitive work plus eliminating operators errors.