1. What must you have in order to append queries?

Select an answer:

• tables that have the same set of rows and the same data types

• tables that have the same set of columns and the same data types

• tables that have the same set of rows and do not have blank values

• tables that have the same set of columns and do not have blank values

When you append files by connecting Excel to a folder, which column will Excel automatically add?

Select an answer:

• Append Date

• Folder Path

• Merge Type

• Source Name

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

Select an answer:

• in Power Query when you create the first workbook

• 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