All of the following statements regarding the Power Query tool in Excel are true EXCEPT:

Power Query allows a more robust means for merging data than does the VLOOKUP$()$ function.

You need to determine the type of join you want to make when using Power Query to combine tables.

You may return NULL values if you choose the Left, Right, or Outer Join joins in Power Query.

Power Query works only if the tables getting merged both have the exact same number of rows with data.