Question 1

Identify the letter of the choice that best matches the phrase or definition.
-A question you ask about the data in a database

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 2

One way to identify a trend is by adding a scatterline to a trend chart of the data.​

Accepted Answer

A) True 
 B)False

Question 3

Excel can save a workbook as a text file,preserving only the data values,without any of the formats applied to it.

Accepted Answer

A) True 
 B)False

Question 4

Data sources can be databases,text files,or other Excel workbooks.​​

Accepted Answer

A) True 
 B)False

Question 5

Columns in delimited text files are always vertically aligned as they would be in a spreadsheet.

Accepted Answer

A) True 
 B)False

Question 6

Audra is a manager in the Sales Department for Creative Pastry Gadgets.She needs access to up-to-date financial data and sales reports.Some of this information comes from Excel workbooks,but other information is stored in other software programs.In addition,Creative Pastry Gadgets maintains a database with detailed financial information and sales figures.Audra uses Excel to analyze data from external data sources.​Audra decides to import data so it will be stored in an external data range.She learns that Excel automatically assigns the data range a defined name based on the filename of the _______.

Accepted Answer

A)  open source 
B)  destination file 
C)  data source 
D)  file source 
A)  open source 
B)  destination file 
C)  data source 
D)  file source

Question 7

You should have ____ source(s)of your data.

Accepted Answer

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

Question 8

Power Map is an add-in that presents data geographically on a virtual 3-D globe.​

Accepted Answer

A) True 
 B)False

Question 9

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 his connection files listed in the Existing Connections dialog box.He should save the connections in the _______ folder.

Accepted Answer

A)  My Connections 
B)  My Data Sources 
C)  My Documents 
D)  My Sources 
A)  My Connections 
B)  My Data Sources 
C)  My Documents 
D)  My Sources

Question 10

To create a worksheet containing forecasted values,including values that follow a seasonal pattern,you click the Forecast Sheet button.​

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A)  structured 
B)  relational 
C)  linked 
D)  trusted 
A)  structured 
B)  relational 
C)  linked 
D)  trusted

Question 12

Audra is a manager in the Sales Department for Creative Pastry Gadgets.She needs access to up-to-date financial data and sales reports.Some of this information comes from Excel workbooks,but other information is stored in other software programs.In addition,Creative Pastry Gadgets maintains a database with detailed financial information and sales figures.Audra uses Excel to analyze data from external data sources.​Audra wants the workbook to always display the most current values from a text file used when importing external sales data.What is the advantage of editing the properties of the connection versus editing the properties of the external data range?

Accepted Answer

A)  The choices are applied to all of the external data ranges that use that connection. 
B)  The choices are applied only to the current workbook. 
C)  The choices are only applied the first time the workbook is opened after the properties have been changed. 
D)  There is no advantage-it would be better to edit the properties of the external data range. 
A)  The choices are applied to all of the external data ranges that use that connection. 
B)  The choices are applied only to the current workbook. 
C)  The choices are only applied the first time the workbook is opened after the properties have been changed. 
D)  There is no advantage-it would be better to edit the properties of the external data range.

Question 13

A hierarchy is an organization of fields that start with the most general and go down to the most specific.​

Accepted Answer

A) True 
 B)False

Question 14

A ______ stores information about a specific characteristic of a person,place,or thing,such as a store ID.​

Accepted Answer

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

Question 15

The Power Pivot add-in provides access to the _________.​

Accepted Answer

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

Identify the letter of the choice that best matches the phrase or definition. -A question you ask about the data in a database

One way to identify a trend is by adding a scatterline to a trend chart of the data.

Excel can save a workbook as a text file,preserving only the data values,without any of the formats applied to it.

Data sources can be databases,text files,or other Excel workbooks.

Columns in delimited text files are always vertically aligned as they would be in a spreadsheet.

You should have ____ source(s)of your data.

Power Map is an add-in that presents data geographically on a virtual 3-D globe.

To create a worksheet containing forecasted values,including values that follow a seasonal pattern,you click the Forecast Sheet button.

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

A hierarchy is an organization of fields that start with the most general and go down to the most specific.

A ______ stores information about a specific characteristic of a person,place,or thing,such as a store ID.

The Power Pivot add-in provides access to the _________.

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

Identify the letter of the choice that best matches the phrase or definition. -A question you ask about the data in a database

One way to identify a trend is by adding a scatterline to a trend chart of the data.​

Excel can save a workbook as a text file,preserving only the data values,without any of the formats applied to it.

Data sources can be databases,text files,or other Excel workbooks.​​

Columns in delimited text files are always vertically aligned as they would be in a spreadsheet.

You should have ____ source(s)of your data.

Power Map is an add-in that presents data geographically on a virtual 3-D globe.​

To create a worksheet containing forecasted values,including values that follow a seasonal pattern,you click the Forecast Sheet button.​

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

A hierarchy is an organization of fields that start with the most general and go down to the most specific.​

A ______ stores information about a specific characteristic of a person,place,or thing,such as a store ID.​

The Power Pivot add-in provides access to the _________.​

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

One way to identify a trend is by adding a scatterline to a trend chart of the data.

Data sources can be databases,text files,or other Excel workbooks.

Power Map is an add-in that presents data geographically on a virtual 3-D globe.

To create a worksheet containing forecasted values,including values that follow a seasonal pattern,you click the Forecast Sheet button.

A hierarchy is an organization of fields that start with the most general and go down to the most specific.

A ______ stores information about a specific characteristic of a person,place,or thing,such as a store ID.

The Power Pivot add-in provides access to the _________.