How do I do the steps above in the Power Query Editor in Excel?

CHO5HW1 GL Apr-Jun Project Description: In your job function, you are asked to take a digital version of a printed report and make it usable for Excel or other business intelligence applications. This same preparation will be done on a regular basls as different quarters in the year end. The GL. Apr-Jun file is maintained by another co-worker, so your work can't be done directly in it. As a result, use the Power Query feature in Excel to accomplish the tasks associated with this project to avold duplication of effort each quarter when these tasks need to be completed. Instructions: For the purpose of grading the project you are required to perform the following tasks: \begin{tabular}{|c|c|c|} \hline Step & Instructions & \begin{tabular}{l} Points \\ Possible \end{tabular} \\ \hline 1 & \begin{tabular}{l} Create the following folder: C:IPQICh05. Download file ChO5HWI GL Apr-Jun.TXT \\ file from the course LMS into the folder. Open Excel and create a new empty file \\ named ChOSHW1 GL Apr-Jun.x/sx in the same folder. \end{tabular} & 2 \\ \hline 2 & \begin{tabular}{l} In this new file, use Excel to import the data from the file downloaded and prepare it \\ as indicated below \end{tabular} & 0 \\ \hline 3 & \begin{tabular}{l} All headers on the report should be removed except those needed to identify the \\ data. \end{tabular} & 3 \\ \hline 4 & \begin{tabular}{l} There should be 5 columns of data when done: Tran Date, Tran Amount, Source, \\ Reference Information, and Vendor Name. \end{tabular} & 5 \\ \hline 5 & The data types should be appropriate for the data in each column. & 2 \\ \hline 6 & \begin{tabular}{l} There should be no spaces to the right or left of any text data and any double \\ spacing between words in text fields should be changed to just one space. \end{tabular} & 3 \\ \hline 7 & \begin{tabular}{l} Apply the changes and retum to Excel. Close Excel and upload your work to the \\ course LMS for grading. \end{tabular} & 0 \\ \hline & Tohat Score & 15 \\ \hline \end{tabular}