The statement "when you get and transform data from an external source, you must add it to a worksheet without any changes" is false.
When you import and transform data from an external source, you can add it to a worksheet with or without modifications.The following are the steps to add the transformed data to a worksheet.
Step 1: To transform the data, choose a data source and transform the data to fit your specifications in the Power Query Editor.
Step 2: Choose Close & Load from the Close & Load drop-down list in the Close & Load drop-down list in the Close & Load group on the Home tab on the Power Query Editor ribbon.
Step 3: The Load To page is where you can specify how the query results are displayed in the Excel workbook. Select Table, PivotTable Report, or PivotChart Report from the options.
Step 4: Select Existing worksheet and choose the location on the worksheet where the data should be placed from the options available.
Step 5: To finish the wizard and add the transformed data to the worksheet, click OK.This process saves a lot of time and helps to keep the data up to date with the source. Data should be updated on a regular basis to keep it current and to aid in making critical decisions based on accurate and current data.
For such more questions on worksheet :
brainly.com/question/8034674
#SPJ11
