Adding a data extension in an Excel document means connecting to an external data source, such as a database or…