Abby created a scatter chart showing her company's annual expenses for the past $15$ years. She also wants to highlight the general pattern of expense amounts. What can she add to the scatter chart?

Question $1$Answer

a$.$

secondary axis

b$.$

data labels

c$.$

trendline

d$.$

gridlines

Question $2$

Not yet answered

Marked out of $1\mathrm{.}00$

Flag question

Question text

After clicking the Get Data button on the Data tab, what do you select to import an Access database table into Excel?

Question $2$Answer

a$.$

Click Navigate and then click Microsoft Access.

b$.$

Click Access Database Wizard.

c$.$

Click Import and then click Access.

d$.$

Point to From Database and then click From Microsoft Access Database.

Question $3$

Not yet answered

Marked out of $1\mathrm{.}00$

Flag question

Question text

A $\_\_\_\_\_$ is a structured collection of data values, often organized into tables with each table focusing on a single subject.

Question $3$Answer

a$.$

webpage,

b$.$

CSV text file

c$.$

database

d$.$

form

Question $4$

Not yet answered

Marked out of $1\mathrm{.}00$

Flag question

Question text

Andrea wants to import data from a file that contains numbers organized in columns separated by tab characters. Which option should she select in the Get & Transform group on the Data tab?

Question $4$Answer

a$.$

From Text$/$CSV

b$.$

From Web

c$.$

From Table$/$Range

d$.$

From Delimited

Question $5$

Not yet answered

Marked out of $1\mathrm{.}00$

Flag question

Question text

A single PivotTable can draw information from two tables if the tables are $\_\_\_\_\_.$

Question $5$Answer

a$.$

from the same source

b$.$

related,

c$.$

similar

d$.$

filtered

Question $6$

Not yet answered

Marked out of $1\mathrm{.}00$

Flag question

Question text

Because loading data from a query creates a snapshot of the data, you need to $\_\_\_\_\_$ the connection if the values in the data source change.

Question $6$Answer

a$.$

refresh

b$.$

delete

c$.$

freeze

d$.$

save

Question $7$

Not yet answered

Marked out of $1\mathrm{.}00$

Flag question

Question text

Davis wants to remove a column from the Climate Data query he created. To do so$,$ he can point to the Climate Data query in the Queries & Connections pane, and then click the $\_\_\_\_\_$ button in the Climate Data dialog box.

Question $7$Answer

a$.$

Restructure

b$.$

Edit

c$.$

Load

d$.$

Refresh

Question $8$

Not yet answered

Marked out of $1\mathrm{.}00$

Flag question

Question text

How can you display all the queries in the current workbook?

Question $8$Answer

a$.$

Open the Power Query Editor window.

b$.$

Open the Queries & Connections pane.

c$.$

Open the Business Intelligence pane.

d$.$

Open the Get Data dialog box.

Question $9$

Not yet answered

Marked out of $1\mathrm{.}00$

Flag question

Question text

If you are importing financial data from a text file that uses commas in currency values, make sure it uses $\_\_\_\_\_$ to separate the columns of values.

Question $9$Answer

a$.$

periods

b$.$

commas

c$.$

paragraph marks

d$.$

tab characters

Question $10$

Not yet answered

Marked out of $1\mathrm{.}00$

Flag question

Question text

In what Power Pivot view can you define a relationship by dragging a common field between two tables to connect them?

Question $10$Answer

a$.$

Design view

b$.$

Query view

c$.$

Datasheet view

d$.$

Diagram view

Previous activity