Power Excel Pre-Test

What is the primary function of Power Query?

• Data cleaning and transformation

• Data analysis

• Data visualization

• Data storage

Which function in Power Query is used to remove duplicates from a dataset?

• Remove Duplicates

• Distinct

• Unique

• Filter

What is the purpose of the M language in Power Query?

• To create custom data types

• To define formulas for calculations

• To write queries for data retrieval

• To format data

What is a data model in Power Pivot?

• A collection of related tables

• A visual representation of data relationships

• A set of calculated fields

• A data source

How do you create a relationship between two tables in Power Pivot?

• Using the Data Model tab

• Using the PivotTable field list

• Using the Power Query Editor

• Using the Formulas tab

What is the purpose of a DAX measure in Power Pivot?

• To calculate values based on data in the data model

• To create custom data types

• To define formulas for calculations

• To write queries for data retrieval

What is VBA used for in Excel?

• To automate repetitive tasks

• To create custom functions

• To design user interfaces

• All of the above

What is the correct syntax for declaring a variable named "myVariable" as an integer in VBA?

• Dim myVariable As Integer

• Declare myVariable As Integer

• Set myVariable = 1

• Integer myVariable

Which VBA function is used to open a workbook?

• Workbooks.Open

• OpenWorkbook

• WorkbookOpen

• Open

What is the purpose of a subroutine in VBA?

• To define a custom function

• To create a module

• To execute a series of statements

• To declare variables