
IVY-Genpact-Power Query 14-09-2022
Authored by Ivy Professional School
Professional Development
Professional Development
Used 3+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
_______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
2.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Where do you find Power Query in Excel?
Home
Data
Insert
View
3.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
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
4.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
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
5.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
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
6.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
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
7.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
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
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?