Question 1

The _______ is part of an OLAP (Online Analytic Processing)database,built to optimize structured data for querying and reporting.​

Accepted Answer

A)  ​Data Cube 
B)  ​Data Model 
C)  ​Encryption Source 
D)  ​Exponential Trendline 
A)  ​Data Cube 
B)  ​Data Model 
C)  ​Encryption Source 
D)  ​Exponential Trendline A

Question 2

Power organization sheets are organized around data visualizations,which are the tables,charts,and maps that present data in a visual way.​

Accepted Answer

A) True 
 B)False  False

Question 3

Loading data from a query into Excel creates a snapshot of that data.

Accepted Answer

A) True 
 B)False  True

Question 4

Power View is a BI tool for visually exploring the data from Power Pivot and is chiefly used for finding hidden relationships within the data.​

Accepted Answer

A) True 
 B)False

Question 5

Databases in which tables can be joined through the use of common fields are known as situational databases.​

Accepted Answer

A) True 
 B)False

Question 6

A data _______ is any file that contains the data you want to retrieve.

Accepted Answer

A)  roster 
B)  link 
C)  dialog 
D)  source 
A)  roster 
B)  link 
C)  dialog 
D)  source

Question 7

A _______ is a collection of fields.​

Accepted Answer

A)  ​Diagram 
B)  ​Record 
C)  ​PivotTable 
D)  Timeline slicer 
A)  ​Diagram 
B)  ​Record 
C)  ​PivotTable 
D)  Timeline slicer

Question 8

Each column of a database table,called a field,stores information about a specific characteristic of a person,place,or thing.​​

Accepted Answer

A) True 
 B)False

Question 9

A(n)_______ is a file that stores a collection of related data.

Accepted Answer

A)  index 
B)  register 
C)  database 
D)  table 
A)  index 
B)  register 
C)  database 
D)  table

Question 10

William works for a nationwide real estate agency.He uses the agency's website to promote the latest homes.He uses Access to store information concerning the home and Excel to analyze the data.Fall open houses include homes in Seattle,Chicago,and Denver.Spring open houses include tours of homes in Washington,D.C.,New Mexico,Alaska,and Montana.Summer home tours include Paris,Rome,Denmark,and Australia.​William wants Excel to automatically refresh the connection between his Excel workbook and his Access database whenever the workbook is opened.He should click the Refresh data when opening the file check box in the Connection Properties dialog box.What steps should he take to open the Connection Properties dialog box?

Accepted Answer

A)  Click the Data tab on the Ribbon, click the Connections button in the Connections group, then click the Connection button. 
B)  Click the Data tab on the Ribbon, click the Connections button in the Connections group, select the database, then click the Properties button. 
C)  Click the Edit tab on the Ribbon, then click the Connections button in the Connections group. 
D)  Click the Edit tab on the Ribbon, click the Connections button in the Connections group, select the database, then click the Properties button. 
A)  Click the Data tab on the Ribbon, click the Connections button in the Connections group, then click the Connection button. 
B)  Click the Data tab on the Ribbon, click the Connections button in the Connections group, select the database, then click the Properties button. 
C)  Click the Edit tab on the Ribbon, then click the Connections button in the Connections group. 
D)  Click the Edit tab on the Ribbon, click the Connections button in the Connections group, select the database, then click the Properties button.

Question 11

A query is a request for information from a data source.​

Accepted Answer

A) True 
 B)False

Question 12

The text from a web query is placed in a worksheet as formatted text.

Accepted Answer

A) True 
 B)False

Question 13

In a query,you can group the data by the values within one of the columns.​

Accepted Answer

A) True 
 B)False

Question 14

For a fixed-width text file to import correctly into Excel,there must be some way for the Text Import Wizard to know where each column begins and ends.

Accepted Answer

A) True 
 B)False

Question 15

Identify the letter of the choice that best matches the phrase or definition.
-Collection of data organized to be easily retrieved and used by the end user

Accepted Answer

A) delimiter 
B) database 
C) record 
D) field 
E) table
F)query
G)common field 
A) delimiter 
B) database 
C) record 
D) field 
E) table
F)query
G)common field

Question 16

You need at least ____ complete years of data to project a seasonal trend for the next year.​

Accepted Answer

A)  ​One 
B)  ​Two 
C)  ​Three 
D)  ​Four 
A)  ​One 
B)  ​Two 
C)  ​Three 
D)  ​Four

Question 17

You can click the ________ View button in Power Pivot to view the structure and relationships of the tables in the Data Model.​

Accepted Answer

A)  ​Data 
B)  ​Diagram 
C)  Database 
D)  None of the above 
A)  ​Data 
B)  ​Diagram 
C)  Database 
D)  None of the above

Question 18

Use data ________ to prevent hackers from gaining unauthorized access to sensitive information.​

Accepted Answer

A)  ​Encryption 
B)  ​Security 
C)  Privacy 
D)  ​Saving 
A)  ​Encryption 
B)  ​Security 
C)  Privacy 
D)  ​Saving

Question 19

Make sure your data files are set up with password controls to prohibit unauthorized access.​

Accepted Answer

A) True 
 B)False

Question 20

The connection between a workbook and a data source can be lost when one or the other is moved to a new location.​

Accepted Answer

A) True 
 B)False

The _______ is part of an OLAP (Online Analytic Processing)database,built to optimize structured data for querying and reporting.

Power organization sheets are organized around data visualizations,which are the tables,charts,and maps that present data in a visual way.

Loading data from a query into Excel creates a snapshot of that data.

Power View is a BI tool for visually exploring the data from Power Pivot and is chiefly used for finding hidden relationships within the data.

Databases in which tables can be joined through the use of common fields are known as situational databases.

A data _______ is any file that contains the data you want to retrieve.

A _______ is a collection of fields.

Each column of a database table,called a field,stores information about a specific characteristic of a person,place,or thing.

A(n)_______ is a file that stores a collection of related data.

A query is a request for information from a data source.

The text from a web query is placed in a worksheet as formatted text.

In a query,you can group the data by the values within one of the columns.

For a fixed-width text file to import correctly into Excel,there must be some way for the Text Import Wizard to know where each column begins and ends.

Identify the letter of the choice that best matches the phrase or definition. -Collection of data organized to be easily retrieved and used by the end user

You need at least ____ complete years of data to project a seasonal trend for the next year.

You can click the ________ View button in Power Pivot to view the structure and relationships of the tables in the Data Model.

Use data ________ to prevent hackers from gaining unauthorized access to sensitive information.

Make sure your data files are set up with password controls to prohibit unauthorized access.

The connection between a workbook and a data source can be lost when one or the other is moved to a new location.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivottables, and Pivotcharts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What-If Analyses

Collaborating on a Shared Workbook

Working With Text Functions

Filters

Exam 11: Analyzing Data With Business Intelligence

The _______ is part of an OLAP (Online Analytic Processing)database,built to optimize structured data for querying and reporting.​

Power organization sheets are organized around data visualizations,which are the tables,charts,and maps that present data in a visual way.​

Loading data from a query into Excel creates a snapshot of that data.

Power View is a BI tool for visually exploring the data from Power Pivot and is chiefly used for finding hidden relationships within the data.​

Databases in which tables can be joined through the use of common fields are known as situational databases.​

A data _______ is any file that contains the data you want to retrieve.

A _______ is a collection of fields.​

Each column of a database table,called a field,stores information about a specific characteristic of a person,place,or thing.​​

A(n)_______ is a file that stores a collection of related data.

A query is a request for information from a data source.​

The text from a web query is placed in a worksheet as formatted text.

In a query,you can group the data by the values within one of the columns.​

For a fixed-width text file to import correctly into Excel,there must be some way for the Text Import Wizard to know where each column begins and ends.

Identify the letter of the choice that best matches the phrase or definition. -Collection of data organized to be easily retrieved and used by the end user

You need at least ____ complete years of data to project a seasonal trend for the next year.​

You can click the ________ View button in Power Pivot to view the structure and relationships of the tables in the Data Model.​

Use data ________ to prevent hackers from gaining unauthorized access to sensitive information.​

Make sure your data files are set up with password controls to prohibit unauthorized access.​

The connection between a workbook and a data source can be lost when one or the other is moved to a new location.​

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivottables, and Pivotcharts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What-If Analyses

Collaborating on a Shared Workbook

Working With Text Functions

Filters

The _______ is part of an OLAP (Online Analytic Processing)database,built to optimize structured data for querying and reporting.

Power organization sheets are organized around data visualizations,which are the tables,charts,and maps that present data in a visual way.

Power View is a BI tool for visually exploring the data from Power Pivot and is chiefly used for finding hidden relationships within the data.

Databases in which tables can be joined through the use of common fields are known as situational databases.

A _______ is a collection of fields.

Each column of a database table,called a field,stores information about a specific characteristic of a person,place,or thing.

A query is a request for information from a data source.

In a query,you can group the data by the values within one of the columns.

You need at least ____ complete years of data to project a seasonal trend for the next year.

You can click the ________ View button in Power Pivot to view the structure and relationships of the tables in the Data Model.

Use data ________ to prevent hackers from gaining unauthorized access to sensitive information.

Make sure your data files are set up with password controls to prohibit unauthorized access.

The connection between a workbook and a data source can be lost when one or the other is moved to a new location.