Question 1

A(n)________ is defined by the range between a high and low value.

Accepted Answer

The answer of A(n)________ is defined by the range between...

Question 2

________ is a powerful tool that creates engaging,interactive user experiences.

Accepted Answer

The answer of ________ is a powerful tool that creates...

Question 3

Match between columns
                        Premises: Power View
Horizontal multiples
Silverlight
Multiples
Vertical multiples

Accepted Answer

The Answer of Expands across the width and wraps down is...

Question 4

In Excel,the ________ is displayed with a graphic providing a visual indicator of the status of the base value compared to the target value.

Accepted Answer

A) target value 
B) status threshold 
C) KPI 
D) base value 
A) target value 
B) status threshold 
C) KPI 
D) base value

Question 5

The Microsoft Azure Marketplace is a cloud computing platform offering a variety of features and services to individuals and businesses.

Accepted Answer

A) True 
 B)False

Question 6

A positive KPI is when the value becomes worse as it deviates too far from the target value in either direction.

Accepted Answer

A) True 
 B)False

Question 7

An explicit calculated field is created when you drag a field like Sales or Quantity Sold into the Values area of a PivotTable.

Accepted Answer

A) True 
 B)False

Question 8

The Microsoft Azure ________ is a cloud computing platform offering a variety of features and services to individuals and businesses.

Accepted Answer

The answer of The Microsoft Azure ________ is a cloud...

Question 9

The Bing Maps app is more accurate if the state abbreviation is used as opposed to the full name of the state.

Accepted Answer

A) True 
 B)False

Question 10

There are three different types of sparklines: line,pie,and win/loss.

Accepted Answer

A) True 
 B)False

Question 11

A ________ is a calculated field that resolves to a value.

Accepted Answer

A) target value 
B) status threshold 
C) vertical multiple 
D) base value 
A) target value 
B) status threshold 
C) vertical multiple 
D) base value

Question 12

________,or miniature charts,provide a way to graphically summarize a row or column of data in a single cell.

Accepted Answer

A) PivotChart 
B) Sparklines 
C) PowerPivot 
D) Silverlight 
A) PivotChart 
B) Sparklines 
C) PowerPivot 
D) Silverlight

Question 13

Which of the following is not a category of DAX functions?

Accepted Answer

A) Date and Time 
B) Information 
C) Parent/Child 
D) Mathematical and Geometric 
A) Date and Time 
B) Information 
C) Parent/Child 
D) Mathematical and Geometric

Question 14

All of the following statements are TRUE about Power View EXCEPT:

Accepted Answer

A) Power View reports are created from data that have been added to the data model. 
B) Power View uses metadata in the data model to understand the relationships between the different tables and fields used in the report. 
C) Power View also allows for easy sorting of data and switching to full-screen mode for some visualizations. 
D) Sparklines allow you to easily filter the data in multiple visualizations. 
A) Power View reports are created from data that have been added to the data model. 
B) Power View uses metadata in the data model to understand the relationships between the different tables and fields used in the report. 
C) Power View also allows for easy sorting of data and switching to full-screen mode for some visualizations. 
D) Sparklines allow you to easily filter the data in multiple visualizations.

Question 15

The number of sick days in a specific time period is an example of a ________.

Accepted Answer

A) positive KPI 
B) negative KPI 
C) KPI 
D) bidirectional KPI 
A) positive KPI 
B) negative KPI 
C) KPI 
D) bidirectional KPI

Question 16

________ are a series of identical charts with the same x- and y-axes but that contain different values.

Accepted Answer

A) Multiples 
B) Vertical multiples 
C) Horizontal multiples 
D) Bidirectional multiples 
A) Multiples 
B) Vertical multiples 
C) Horizontal multiples 
D) Bidirectional multiples

Question 17

If a company is using a previous version of Excel without PowerPivot,they can use Conditional Formatting ________ instead to indicate proximity to various KPI goals.

Accepted Answer

A) Highlight Cells Rules 
B) Data Bars 
C) Color Scales 
D) Icon Sets 
A) Highlight Cells Rules 
B) Data Bars 
C) Color Scales 
D) Icon Sets

Question 18

PowerPivot allows you to create calculated columns,calculated fields,and establish KPIs all outside of Excel.

Accepted Answer

A) True 
 B)False

Question 19

According to Aberdeen Group,Inc.,the top factor driving dashboard initiatives is the need for one view of the business date at 37%.

Accepted Answer

A) True 
 B)False

Question 20

One of the primary goals of a dashboard is to stay focused on a specific business problem.This is an example of the ________ design concept.

Accepted Answer

A) Making Sure It Is Well Defined 
B) Keeping It Simple 
C) Knowing Your Users 
D) Defining Crucial KPIs 
A) Making Sure It Is Well Defined 
B) Keeping It Simple 
C) Knowing Your Users 
D) Defining Crucial KPIs

A(n)________ is defined by the range between a high and low value.

________ is a powerful tool that creates engaging,interactive user experiences.

In Excel,the ________ is displayed with a graphic providing a visual indicator of the status of the base value compared to the target value.

The Microsoft Azure Marketplace is a cloud computing platform offering a variety of features and services to individuals and businesses.

A positive KPI is when the value becomes worse as it deviates too far from the target value in either direction.

An explicit calculated field is created when you drag a field like Sales or Quantity Sold into the Values area of a PivotTable.

The Microsoft Azure ________ is a cloud computing platform offering a variety of features and services to individuals and businesses.

The Bing Maps app is more accurate if the state abbreviation is used as opposed to the full name of the state.

There are three different types of sparklines: line,pie,and win/loss.

A ________ is a calculated field that resolves to a value.

________,or miniature charts,provide a way to graphically summarize a row or column of data in a single cell.

Which of the following is not a category of DAX functions?

All of the following statements are TRUE about Power View EXCEPT:

The number of sick days in a specific time period is an example of a ________.

________ are a series of identical charts with the same x- and y-axes but that contain different values.

If a company is using a previous version of Excel without PowerPivot,they can use Conditional Formatting ________ instead to indicate proximity to various KPI goals.

PowerPivot allows you to create calculated columns,calculated fields,and establish KPIs all outside of Excel.

According to Aberdeen Group,Inc.,the top factor driving dashboard initiatives is the need for one view of the business date at 37%.

One of the primary goals of a dashboard is to stay focused on a specific business problem.This is an example of the ________ design concept.

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Complex Conditional and Retrieval Functions

Analyze Data Using Tables

Multiple Worksheets workbooks and Templates

Refine an Excel Application

Organize, import, export, and Cleanse Data Sets

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters

Exam 13: Excels Data Model, Power-pivot, and Power View

A(n)________ is defined by the range between a high and low value.

________ is a powerful tool that creates engaging,interactive user experiences.

In Excel,the ________ is displayed with a graphic providing a visual indicator of the status of the base value compared to the target value.

The Microsoft Azure Marketplace is a cloud computing platform offering a variety of features and services to individuals and businesses.

A positive KPI is when the value becomes worse as it deviates too far from the target value in either direction.

An explicit calculated field is created when you drag a field like Sales or Quantity Sold into the Values area of a PivotTable.

The Microsoft Azure ________ is a cloud computing platform offering a variety of features and services to individuals and businesses.

The Bing Maps app is more accurate if the state abbreviation is used as opposed to the full name of the state.

There are three different types of sparklines: line,pie,and win/loss.

A ________ is a calculated field that resolves to a value.

________,or miniature charts,provide a way to graphically summarize a row or column of data in a single cell.

Which of the following is not a category of DAX functions?

All of the following statements are TRUE about Power View EXCEPT:

The number of sick days in a specific time period is an example of a ________.

________ are a series of identical charts with the same x- and y-axes but that contain different values.

If a company is using a previous version of Excel without PowerPivot,they can use Conditional Formatting ________ instead to indicate proximity to various KPI goals.

PowerPivot allows you to create calculated columns,calculated fields,and establish KPIs all outside of Excel.

According to Aberdeen Group,Inc.,the top factor driving dashboard initiatives is the need for one view of the business date at 37%.

One of the primary goals of a dashboard is to stay focused on a specific business problem.This is an example of the ________ design concept.

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Complex Conditional and Retrieval Functions

Analyze Data Using Tables

Multiple Worksheets workbooks and Templates

Refine an Excel Application

Organize, import, export, and Cleanse Data Sets

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters