Chapter 10 - Power Add-Ins

Question 1

Animated segment within a tour

Answer 1

Scene

Question 2

An association between 2 related tables where both tables contain a related field of data, such as IDs.

Answer 2

Relationship

Question 3

A business intelligences tool that can protect and shape data from multiple sources.

Answer 3

Power Query Editor

Question 4

Feature that enables you to integrate data from multiple sources within a workbool.

Answer 4

Data model

Question 5

A file type that uses commas to separate data into columns and a newline character to separate data into rows.

Answer 5

Comma Separated Values (CSV) file

Question 6

Special character (e.g. tab or space) that separate data.

Answer 6

Delimeter

Question 7

Method of importing external data into excel but not maintaining a link to the original data source.

Answer 7

Embed

Question 8

A special character that designates the end of a line and separates data for the next line in row.

Answer 8

Newline character

Question 9

Build-in add-in that offers the key functionality that is included in Excel’s stock PivotTable options, plus variety of useful features for the power user.

Answer 9

Power Pivot

Question 10

A process that updates the linked data in an excel workbook with the most up to date information.

Answer 10

Refresh

Question 11

Process of inserting external data created or stored in another format into the current application

Answer 11

Importing

Question 12

The settings that control how imported data in cells connect to their sources data.

Answer 12

External Data Properties

Question 13

Process of editing info from one or more data sources desired paramenters before importing into application.

Answer 13

Data shaping

Question 14

Online application suite designed to help users manage, supplement, visualize, and analyze data.

Answer 14

Power BI

Question 15

Time-based animation that can display a 3d map from different perspectives.

Answer 15

Tour

Question 16

A file type that users tabs to separate data into columns

Answer 16

Tab-delimited file

Question 17

Data file that contains characters, such as letter number and symbols including punctuation and spaces.

Answer 17

Text file

Question 18

A method of summarizing data visually to better understand the significance of the information.

Answer 18

Data visualization

Question 19

Attributes that contribute to the visualization of data.

Answer 19

Dimension

Question 20

A file which each column contains a specific number of characters.

Answer 20

Filxed width text file