IVY-Genpact-Power Query 14-09-2022

_______allows you to import data from many different sources and then clean, transform and reshape your data as needed.

• Power Query

• Power Pivot

• Conditional Formatting

• Macros

Where do you find Power Query in Excel?

• Home

• Data

• Insert

• View

How can we import data from a table range in excel to power query? 

• Data---Get Data---From Database.

• Insert---Get Data---From Other Sources.

• Data---Get Data---From Other Sources.

• None of these

Use of Transform Ribbon in Power Query is______.

• Help to modify & make changes in the original column only

• Help to modify & make changes in the data by adding a new column

• Help to extract data from a database

• None of these

What is the use of applied step in Power Query?

• Show the actions/steps done in the power query

• Show the database tables in the power query

• Help to change the file/table name

• None of these

How to change the Date/Time Zone in Power Query?

• Using Regional Settings to change region time/date

• Go to transform to change region time/date

• Go to add column to change region time/date

• Change the data type of column to Date

Steps required if you want to change all the values in a "Name" column from Lower to Upper Case are______

• Add Column > Format > UPPERCASE

• Transform > Format > lowercase

• Transform > Format > UPPERCASE

• Add Column > Format > Capitalize Each Word

If we want to extract all the characters after "@" from "Email" column into "NewMail" column then steps are______

• Add Column > Extract > Text After Delimiter

• Transform > Extract > Text After Delimiter

• Add Column > Format > Text After Delimiter

• Transform > Extract > Text Before Delimiter

Performing an integer divide on 735/6 returns:

• 122.5

• 123

• 122

• 122.50

True/ False: It is not possible to merge more than two columns in Power Query

• False

• True