Question $3(1$ point$)$

Quarim has imported data from the company website. He has also applied some tranformations to clean and structure the data before updating his dashboard.

When he loads the spreadsheet and Refr$$shes$,$ what actions are taken by MS Excel?

Connects to the website and reads the data directly off the page, replaces changed values only

Connect to the website, then opens a dialog for users to select transformations that are requried

Connects to the website, applies all transformations at once, updates the spreadsheet

Connects to the website, applies transformations step$-$by$-$step, replaces existing data with the updates

Copies data from the website