Excel Data Import with Copilot and Power Query

Excel Data Import with Copilot and Power Query

Assessment

Interactive Video

Computers

9th - 10th Grade

Practice Problem

Hard

Created by

Jennifer Brown

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What tool does Kevin introduce for importing various types of data into Excel?

VLOOKUP and HLOOKUP

Power Query and Copilot

Pivot Tables and Charts

Macros and VBA

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which feature allows you to search the web directly within Excel to find public information?

Data Analysis Toolpak

Copilot

Solver

Conditional Formatting

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does Kevin use to find the current exchange rates for different currencies?

External software

Manual entry

Excel formulas

Copilot

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How does Copilot ensure that existing data in a spreadsheet is not overwritten?

By adding new data only

By locking the cells

By creating a backup

By using a password

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What type of internal content does Kevin import into Excel using Copilot?

Tasks

Contacts

Meetings from Outlook

Emails

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Who is identified as the organizer of the meetings imported into Excel?

Kevin

Patti Fernandez

The CEO

Peter White

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

From where does Kevin pull organizational data into Excel?

Dropbox

Local Database

Azure Active Directory

Google Workspace

Create a free account and access millions of resources

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?