Power Excel Post Test

Refer to the picture given. From which Excel ribbon can you get this "Get Data" or "New Query" button?

• Home
• Insert
• View
• Data

Refer to the picture given. What is the function of the "Applied Steps" in Power Query?

• The 'Applied Steps' function is for exporting data to Excel.
• The 'Applied Steps' function is used to create new data sources.
• The 'Applied Steps' function allows users to view and manage the transformations applied to the data.
• The 'Applied Steps' function automatically generates reports.

Refer to the picture given. What can you do if you click on this "Choose Columns" icon?

• You can select which columns to display/remove.

• You can sort the columns alphabetically.
• You can change the color of the columns.
• You can go to a selected column from the table.

What will happen to your data in Power Query Editor if you click on this "Close & Load" button?

• Your data will be deleted permanently.
• Your data will be exported as a CSV file.
• Your data will be copied to a different workbook.
• Your data will be saved and loaded into Excel.

What does the "Remove Rows" option in Power Query allow you to do?

• Delete all rows from the table.

• Remove specific rows based on conditions.

• Sort rows in ascending order.

• Filter rows by data type.

What is the main difference between this "Split Column" button in Power Query Editor with "Text-To-Columns" button in Excel?

• The Split Column button in Power Query cannot handle multiple delimiters at once.

• The Split Column button in Power Query can only split columns by fixed width.

• The Split Column button in Power Query offers more advanced and flexible splitting options.

• The Split Column button in Power Query is only available for numeric data.

What can you do if you click on "Conditional Column" button from the "Add Column" ribbon in Power Query Editor?

• You can create a new column based on conditions applied to existing columns.
• You can change the data type of a column.
• You can merge two tables into one.
• You can delete existing columns from the table.

How to create a table relationship in Excel Power Pivot?

• Import data from Access to establish links.
• Create a new worksheet for each table.
• Drag and drop fields between tables in Diagram View to create relationships.
• Use the VLOOKUP function to find relationships.

How to activate Excel Power Pivot for the first time?

• Power Pivot is automatically activated when Excel is installed.
• Power Pivot can be activated by enabling it in the COM Add-ins under Excel Options.
• Power Pivot is enabled by default in all versions of Excel.
• You can activate Power Pivot by downloading it from the Microsoft website.

What are the differences between Power Pivot and Pivot Table? Choose 2 answers.

• Pivot Tables can create relationships between tables, while Power Pivot cannot.
• Power Pivot supports DAX for advanced calculations, while Pivot Tables do not.

• Pivot Tables allow for real-time data updates, while Power Pivot requires manual refreshes.
• Power Pivot can handle larger datasets than Pivot Tables.