Uestion $1(1$ point$)$

You plan to use a data source for different workbooks. Where should you shape your data?

as close to the data source as possible

in the Excel workbooks once they are created

in Power Query when you create the new workbooks

in Power Query when you create the first workbook