Module 10 Learning Activity | Excel Module 10 Practice Quiz

What is the file extension of a macro-enabled workbook?

.xlsm

Willa wants to display her data in relation to a geographic area on a map. Which of the following should she create?

3D Map.

Johan wants to create a PivotTable using Power Pivot. He clicks a cell in the table containing the source data, and then clicks which of the following buttons on the Power Pivot tab?

Add to Data Model.

Jalen wants to link a heading in a worksheet to a webpage. Where should he enter the webpage address in the Insert Hyperlink dialog box?

Address box.

Arlo creates a rectangular shape and wants to assign a macro to it. He right-clicks the shape and selects which of the following commands on the shortcut menu?

Assign Macro.

Bella wants to insert a hyperlink to the Employees worksheet in the current workbook. Which of the following options should she select in the Insert Hyperlink dialog box?

Create New Document.

To create a video with High-definition quality for a 3D Maps tour, select the Computers & Tablets option in the Create Video dialog box.

False.

To extract data stored in a PivotTable, you can use the EXTRACT function.

False.

Which of the following is a specially formatted word, phrase, or graphic that, when clicked or tapped, lets you display a webpage on the Internet, another file, an email, or another location within the same file?

Hyperlink.

Which of the following is a calculated, named field in Power Pivot created by a data analysis expression (DAX)?

Measure.

Grace imported data from an external source and now wants to access the query for editing. Which of the following panes lists the queries in her workbook?

Queries & Connections pane.

What do you call a request for information from a data source?

Query.

Esperanza wants to save a series of keystrokes so she can replay them and automate a repetitive task. Which of the following should she do?

Record a macro.

Which of the following is a field or column that two data sources have in common?

Relationship.

In which of the following boxes in the Scene Options dialog box will you insert the name for a scene?

Scene Name.

Derek wants to sort the data he is importing from another workbook. To do so, he can use the filter menu in the Power Query Editor.

True.

To create a relationship between two tables, the first step is to click the Relationships button in the Data Tools group on the Data tab.

True.

When you use the Get Data button to connect to data in an external source, you import a local copy of the data as a table, which is also called a query.

True.