Question 1

A(n)________ calculated field is created when a formula is typed in the Calculation Area of the PowerPivot window.

Accepted Answer

The answer of A(n)________ calculated field is created when a...

Question 2

Power View is an interactive data visualization,exploration,and presentation experience that encourages the creation of ad-hoc reports.

Accepted Answer

A) True 
 B)False

Question 3

Calculated Fields can be created in any of the cells in the Calculation Area of the PowerPivot window.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) Silverlight 
B) Azure Marketplace 
C) SkyDrive 
D) Outlook Live 
A) Silverlight 
B) Azure Marketplace 
C) SkyDrive 
D) Outlook Live

Question 5

Once a dashboard has been designed to meet the business requirements,there are several steps you need to take to get it ready for use.

Accepted Answer

A) True 
 B)False

Question 6

All of the following statements are TRUE about the basics of dashboard design EXCEPT:

Accepted Answer

A) Dashboard components typically consist of tables, PivotTables, PivotCharts, conditional formatting, and other features available in Excel. 
B) How a dashboard is designed has just as much of an impact on its effectiveness as the data displayed. 
C) Dashboards that do not include multi-screen, visually oriented user interfaces are poorly designed. 
D) Typically, dashboards are also oriented around specific business activities, such as sales analysis, cash flow, employee productivity, and customer service. 
A) Dashboard components typically consist of tables, PivotTables, PivotCharts, conditional formatting, and other features available in Excel. 
B) How a dashboard is designed has just as much of an impact on its effectiveness as the data displayed. 
C) Dashboards that do not include multi-screen, visually oriented user interfaces are poorly designed. 
D) Typically, dashboards are also oriented around specific business activities, such as sales analysis, cash flow, employee productivity, and customer service.

Question 7

________ multiples will expand across the width of the container and wrap down the container in the available space.

Accepted Answer

The answer of ________ multiples will expand across the width...

Question 8

White space is white and void of content.

Accepted Answer

A) True 
 B)False

Question 9

All of the following statements are TRUE about creating PivotTables and PivotCharts with PowerPivot EXCEPT:

Accepted Answer

A) PowerPivot gives you the same options as a Pivot Table except you can use relational data to build it. 
B) PivotTables and PivotCharts are a major component in any dashboard. 
C) PivotTables and PivotCharts can be created with data from multiple sources without any additional software or add-ins as long as it is relational data. 
D) Not only can you create a single PivotTable or PivotChart on a worksheet with PowerPivot, but you can also create a PivotTable and PivotChart on the same worksheet as well as two PivotCharts arranged vertically or horizontally, or four PivotCharts on the same worksheet. 
A) PowerPivot gives you the same options as a Pivot Table except you can use relational data to build it. 
B) PivotTables and PivotCharts are a major component in any dashboard. 
C) PivotTables and PivotCharts can be created with data from multiple sources without any additional software or add-ins as long as it is relational data. 
D) Not only can you create a single PivotTable or PivotChart on a worksheet with PowerPivot, but you can also create a PivotTable and PivotChart on the same worksheet as well as two PivotCharts arranged vertically or horizontally, or four PivotCharts on the same worksheet.

Question 10

You can increase the success of your dashboard by taking personal preferences into account whenever possible.

Accepted Answer

A) True 
 B)False

Question 11

Following the ________ model can provide the necessary guidance to creating an effective dashboard.

Accepted Answer

A) KPI 
B) SDLC 
C) BI 
D) white space 
A) KPI 
B) SDLC 
C) BI 
D) white space

Question 12

Excel 2013 not only gives you the ability to conduct analyses on data from multiple sources,but you can also do more advanced data modeling ________.

Accepted Answer

A) with slicers 
B) with sparklines 
C) in PowerPivot 
D) in Silverlight 
A) with slicers 
B) with sparklines 
C) in PowerPivot 
D) in Silverlight

Question 13

If users cannot easily interpret your dashboard,then you may have made it too complicated.

Accepted Answer

A) True 
 B)False

Question 14

The role of ________ has increased over the last decade because the amount of data being collected by businesses continues to grow at a rapid rate.

Accepted Answer

business i

Question 15

One of the primary goals of a dashboard is to ensure that managers have ways to quantifiably measure the progress toward short-term and long-term goals.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

Question 16

All of the following statements are TRUE about the benefits to using Microsoft Excel to create digital dashboards EXCEPT:

Accepted Answer

A) Because companies can get free copies of the full version of Excel for all of their employees, leveraging the capabilities of Microsoft Excel is a very cost-effective solution. 
B) People will spend less time learning how to use the dashboard and more time getting value from what is displayed. 
C) With the appropriate know-how, Excel can be much more flexible in the variety of analytics it can provide in a dashboard than many off-the-shelf solutions. 
D) Having the capability of creating your own reporting mechanisms in Excel can reduce your reliance on the IT department's resources. 
A) Because companies can get free copies of the full version of Excel for all of their employees, leveraging the capabilities of Microsoft Excel is a very cost-effective solution. 
B) People will spend less time learning how to use the dashboard and more time getting value from what is displayed. 
C) With the appropriate know-how, Excel can be much more flexible in the variety of analytics it can provide in a dashboard than many off-the-shelf solutions. 
D) Having the capability of creating your own reporting mechanisms in Excel can reduce your reliance on the IT department's resources.

Question 17

A bidirectional KPI is when the greater the value the better the KPI,such as a company's profit.

Accepted Answer

A) True 
 B)False

Question 18

The ________ window has options to create multiple PivotCharts on the same worksheet using data from all connected data sources.

Accepted Answer

A) PivotTable 
B) Power View 
C) PowerPivot 
D) PivotChart 
A) PivotTable 
B) Power View 
C) PowerPivot 
D) PivotChart

Question 19

Digital dashboards are mechanisms that deliver business intelligence in tabular form.

Accepted Answer

A) True 
 B)False

Question 20

________ provide a dynamic navigation strip allowing you to navigate through a series of charts based on a particular value.

Accepted Answer

The answer of ________ provide a dynamic navigation strip allowing...

A(n)________ calculated field is created when a formula is typed in the Calculation Area of the PowerPivot window.

Power View is an interactive data visualization,exploration,and presentation experience that encourages the creation of ad-hoc reports.

Calculated Fields can be created in any of the cells in the Calculation Area of the PowerPivot window.

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

Once a dashboard has been designed to meet the business requirements,there are several steps you need to take to get it ready for use.

All of the following statements are TRUE about the basics of dashboard design EXCEPT:

________ multiples will expand across the width of the container and wrap down the container in the available space.

White space is white and void of content.

All of the following statements are TRUE about creating PivotTables and PivotCharts with PowerPivot EXCEPT:

You can increase the success of your dashboard by taking personal preferences into account whenever possible.

Following the ________ model can provide the necessary guidance to creating an effective dashboard.

Excel 2013 not only gives you the ability to conduct analyses on data from multiple sources,but you can also do more advanced data modeling ________.

If users cannot easily interpret your dashboard,then you may have made it too complicated.

The role of ________ has increased over the last decade because the amount of data being collected by businesses continues to grow at a rapid rate.

One of the primary goals of a dashboard is to ensure that managers have ways to quantifiably measure the progress toward short-term and long-term goals.This is an example of the ________ design concept.

All of the following statements are TRUE about the benefits to using Microsoft Excel to create digital dashboards EXCEPT:

A bidirectional KPI is when the greater the value the better the KPI,such as a company's profit.

The ________ window has options to create multiple PivotCharts on the same worksheet using data from all connected data sources.

Digital dashboards are mechanisms that deliver business intelligence in tabular form.

________ provide a dynamic navigation strip allowing you to navigate through a series of charts based on a particular value.

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)________ calculated field is created when a formula is typed in the Calculation Area of the PowerPivot window.

Power View is an interactive data visualization,exploration,and presentation experience that encourages the creation of ad-hoc reports.

Calculated Fields can be created in any of the cells in the Calculation Area of the PowerPivot window.

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

Once a dashboard has been designed to meet the business requirements,there are several steps you need to take to get it ready for use.

All of the following statements are TRUE about the basics of dashboard design EXCEPT:

________ multiples will expand across the width of the container and wrap down the container in the available space.

White space is white and void of content.

All of the following statements are TRUE about creating PivotTables and PivotCharts with PowerPivot EXCEPT:

You can increase the success of your dashboard by taking personal preferences into account whenever possible.

Following the ________ model can provide the necessary guidance to creating an effective dashboard.

Excel 2013 not only gives you the ability to conduct analyses on data from multiple sources,but you can also do more advanced data modeling ________.

If users cannot easily interpret your dashboard,then you may have made it too complicated.

The role of ________ has increased over the last decade because the amount of data being collected by businesses continues to grow at a rapid rate.

One of the primary goals of a dashboard is to ensure that managers have ways to quantifiably measure the progress toward short-term and long-term goals.This is an example of the ________ design concept.

All of the following statements are TRUE about the benefits to using Microsoft Excel to create digital dashboards EXCEPT:

A bidirectional KPI is when the greater the value the better the KPI,such as a company's profit.

The ________ window has options to create multiple PivotCharts on the same worksheet using data from all connected data sources.

Digital dashboards are mechanisms that deliver business intelligence in tabular form.

________ provide a dynamic navigation strip allowing you to navigate through a series of charts based on a particular value.

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