Question 1

One way to interact with a database is with a query language.The most popular query language is _______.

Accepted Answer

A)  ODC 
B)  UDC 
C)  OLE 
D)  SQL 
A)  ODC 
B)  UDC 
C)  OLE 
D)  SQL

Question 2

Most software programs can both save and retrieve data in a(n)_______ file format.

Accepted Answer

A)  HTML 
B)  text 
C)  spreadsheet 
D)  picture 
A)  HTML 
B)  text 
C)  spreadsheet 
D)  picture

Question 3

Database tables can be inserted directly into PivotCharts and PivotFigures.​​

Accepted Answer

A) True 
 B)False

Question 4

You relate tables to one another by using _______ fields.

Accepted Answer

A)  key 
B)  common 
C)  indexed 
D)  date 
A)  key 
B)  common 
C)  indexed 
D)  date

Question 5

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.​To prevent other users from updating a data source without permission,what should Audra do?

Accepted Answer

A)  Define the data source. 
B)  Remove the connection. 
C)  Require a password. 
D)  Nothing-Excel cannot prevent data from being refreshed. 
A)  Define the data source. 
B)  Remove the connection. 
C)  Require a password. 
D)  Nothing-Excel cannot prevent data from being refreshed.

Question 6

Power and Exponential trendlines cannot be used if the data contains zero or negative values.​

Accepted Answer

A) True 
 B)False

Question 7

One advantage of forecast sheets is that they can be used to analyze annual data in which the values follow a periodic pattern throughout the calendar year.​

Accepted Answer

A) True 
 B)False

Question 8

When no arrow connects a table to any of the other tables in the data model,there is no way to match the records of that table with the other tables.

Accepted Answer

A) True 
 B)False

Question 9

A data connection is like a pipeline from a data source to two or more locations in the workbook.

Accepted Answer

A) True 
 B)False

Question 10

A __________ is a slicer that is applied to date fields.Using the timeline,you can summarize the data for ranges of time intervals from years down to minutes and seconds.​

Accepted Answer

A)  Trendline 
B)  ​Timeline 
C)  ​Scatter line 
D)  ​PivotTable 
A)  Trendline 
B)  ​Timeline 
C)  ​Scatter line 
D)  ​PivotTable

Question 11

Power Map data is placed in tables,which are superimposed on the map.​

Accepted Answer

A) True 
 B)False

Question 12

A delimiter is a symbol that separates one column of data from another.

Accepted Answer

A) True 
 B)False

Question 13

When you create a grouping,the query editor adds a new column to summarize the numeric values within each group by calculating the:​

Accepted Answer

A)  ​Sum, average, median, minimum, or maximum of the data values 
B)  ​Count of rows within each group 
C)  Count of rows with distinct values within each group 
D)  All of the above 
A)  ​Sum, average, median, minimum, or maximum of the data values 
B)  ​Count of rows within each group 
C)  Count of rows with distinct values within each group 
D)  All of the above

Question 14

Which of the following is not a type of trendline?​

Accepted Answer

A)  ​Exponential 
B)  ​Linear 
C)  Horizontal 
D)  ​Power 
A)  ​Exponential 
B)  ​Linear 
C)  Horizontal 
D)  ​Power

Question 15

All steps in Power Query are written in the language P.

Accepted Answer

A) True 
 B)False

Question 16

A ________ is a highly structured collection of data values organized into separate tables.​

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​

Question 17

_______ is a database program.

Accepted Answer

A)  Word 
B)  Access 
C)  PowerPoint 
D)  Outlook 
A)  Word 
B)  Access 
C)  PowerPoint 
D)  Outlook

Question 18

The Query Editor also includes tools to:​

Accepted Answer

A)  ​create new columns 
B)  group data values 
C)  ​calculate summary statistics 
D)  All of the above 
A)  ​create new columns 
B)  group data values 
C)  ​calculate summary statistics 
D)  All of the above

Question 19

A scatterline is a line fitted to a scatter chart showing the relationship between two numerical variables.

Accepted Answer

A) True 
 B)False

Question 20

Power Query is a BI tool used for writing queries to almost any kind of data source,from text files to websites to large database structures.​

Accepted Answer

A) True 
 B)False

One way to interact with a database is with a query language.The most popular query language is _______.

Most software programs can both save and retrieve data in a(n)_______ file format.

Database tables can be inserted directly into PivotCharts and PivotFigures.

You relate tables to one another by using _______ fields.

Power and Exponential trendlines cannot be used if the data contains zero or negative values.

One advantage of forecast sheets is that they can be used to analyze annual data in which the values follow a periodic pattern throughout the calendar year.

When no arrow connects a table to any of the other tables in the data model,there is no way to match the records of that table with the other tables.

A data connection is like a pipeline from a data source to two or more locations in the workbook.

A __________ is a slicer that is applied to date fields.Using the timeline,you can summarize the data for ranges of time intervals from years down to minutes and seconds.

Power Map data is placed in tables,which are superimposed on the map.

A delimiter is a symbol that separates one column of data from another.

When you create a grouping,the query editor adds a new column to summarize the numeric values within each group by calculating the:

Which of the following is not a type of trendline?

All steps in Power Query are written in the language P.

A ________ is a highly structured collection of data values organized into separate tables.

_______ is a database program.

The Query Editor also includes tools to:

A scatterline is a line fitted to a scatter chart showing the relationship between two numerical variables.

Power Query is a BI tool used for writing queries to almost any kind of data source,from text files to websites to large database structures.

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

One way to interact with a database is with a query language.The most popular query language is _______.

Most software programs can both save and retrieve data in a(n)_______ file format.

Database tables can be inserted directly into PivotCharts and PivotFigures.​​

You relate tables to one another by using _______ fields.

Power and Exponential trendlines cannot be used if the data contains zero or negative values.​

One advantage of forecast sheets is that they can be used to analyze annual data in which the values follow a periodic pattern throughout the calendar year.​

When no arrow connects a table to any of the other tables in the data model,there is no way to match the records of that table with the other tables.

A data connection is like a pipeline from a data source to two or more locations in the workbook.

A __________ is a slicer that is applied to date fields.Using the timeline,you can summarize the data for ranges of time intervals from years down to minutes and seconds.​

Power Map data is placed in tables,which are superimposed on the map.​

A delimiter is a symbol that separates one column of data from another.

When you create a grouping,the query editor adds a new column to summarize the numeric values within each group by calculating the:​

Which of the following is not a type of trendline?​

All steps in Power Query are written in the language P.

A ________ is a highly structured collection of data values organized into separate tables.​

_______ is a database program.

The Query Editor also includes tools to:​

A scatterline is a line fitted to a scatter chart showing the relationship between two numerical variables.

Power Query is a BI tool used for writing queries to almost any kind of data source,from text files to websites to large database structures.​

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

Database tables can be inserted directly into PivotCharts and PivotFigures.

Power and Exponential trendlines cannot be used if the data contains zero or negative values.

One advantage of forecast sheets is that they can be used to analyze annual data in which the values follow a periodic pattern throughout the calendar year.

A __________ is a slicer that is applied to date fields.Using the timeline,you can summarize the data for ranges of time intervals from years down to minutes and seconds.

Power Map data is placed in tables,which are superimposed on the map.

When you create a grouping,the query editor adds a new column to summarize the numeric values within each group by calculating the:

Which of the following is not a type of trendline?

A ________ is a highly structured collection of data values organized into separate tables.

The Query Editor also includes tools to:

Power Query is a BI tool used for writing queries to almost any kind of data source,from text files to websites to large database structures.