How to create and populate a table in Microsoft Excel ... Blank Query as shown in Figure A. Power Query will open the formula bar and name the query Query1, which you can change to Commission ...