Power Excel Post Test

Power Excel Post Test

Professional Development

15 Qs

quiz-placeholder

Similar activities

Quizzz 25 Mei 2021

Quizzz 25 Mei 2021

Professional Development

16 Qs

Show & Tell A70

Show & Tell A70

Professional Development

20 Qs

Lean Six Sigma Green Belt

Lean Six Sigma Green Belt

Professional Development

14 Qs

Microsoft Excel

Microsoft Excel

KG - Professional Development

20 Qs

Nurse Professional 2

Nurse Professional 2

Professional Development

15 Qs

DatabaseDesign

DatabaseDesign

Professional Development

10 Qs

Endokrinologi April 2020

Endokrinologi April 2020

KG - Professional Development

10 Qs

Kurikulum 2013

Kurikulum 2013

Professional Development

10 Qs

Power Excel Post Test

Power Excel Post Test

Assessment

Quiz

Professional Development

Professional Development

Practice Problem

Easy

Created by

Shahadatuliskandar Rosli

Used 9+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

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

Home
Insert
View
Data

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

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.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

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.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

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.

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

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.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

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.

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?

Discover more resources for Professional Development