Question 1

All of the following statements are TRUE about preparing a dashboard for production EXCEPT:

Accepted Answer

A) Once a dashboard has been designed to meet the business requirements, it is ready for use. 
B) Because dashboards are designed for the specific needs of an end user, it is important to ensure once the dashboard contains all the required data that certain protections are in place to avoid accidental deletion of various objects or incorrect modifications. 
C) To be able to manipulate Slicers, you must allow users to Edit Objects, which does allow changes to the PivotCharts. 
D) It is preferable to hide any unnecessary objects that may distract the user from the dashboard's content. 
A) Once a dashboard has been designed to meet the business requirements, it is ready for use. 
B) Because dashboards are designed for the specific needs of an end user, it is important to ensure once the dashboard contains all the required data that certain protections are in place to avoid accidental deletion of various objects or incorrect modifications. 
C) To be able to manipulate Slicers, you must allow users to Edit Objects, which does allow changes to the PivotCharts. 
D) It is preferable to hide any unnecessary objects that may distract the user from the dashboard's content. A

Question 2

All of the following statements are TRUE about the Microsoft Azure Marketplace EXCEPT:

Accepted Answer

A) There are a variety of categories based on development date and price. 
B) One of the many services the Microsoft Azure Marketplace provides is access to very large data sets for use in analysis. 
C) There are several data sets available for free, and they can be accessed in the PowerPivot window. 
D) Having access to large data sets allows you to explore all the analysis tools available in Excel 2013. 
A) There are a variety of categories based on development date and price. 
B) One of the many services the Microsoft Azure Marketplace provides is access to very large data sets for use in analysis. 
C) There are several data sets available for free, and they can be accessed in the PowerPivot window. 
D) Having access to large data sets allows you to explore all the analysis tools available in Excel 2013. A

Question 3

All of the following statements are TRUE about using apps for Office for data visualizations EXCEPT:

Accepted Answer

A) The apps for Office platform allows app developers to create new and engaging consumer and enterprise experiences within the Office applications. 
B) Other apps for Word provide advanced analytic capabilities or data visualizations. 
C) An app for Office is essentially a web page that is hosted inside an Office application. 
D) An app for Office can be used to extend the functionality of the application. 
A) The apps for Office platform allows app developers to create new and engaging consumer and enterprise experiences within the Office applications. 
B) Other apps for Word provide advanced analytic capabilities or data visualizations. 
C) An app for Office is essentially a web page that is hosted inside an Office application. 
D) An app for Office can be used to extend the functionality of the application. B

Question 4

The temperature for storing a particular product where damage could occur if the temperature gets too cold or too hot 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 5

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

Accepted Answer

The answer of ________ are a series of identical charts...

Question 6

Sparklines provide a way to graphically summarize a row or column of data in a single cell.

Accepted Answer

A) True 
 B)False

Question 7

You can increase the success of your dashboard by taking personal preferences into account whenever possible.This is an example of the ________ design concept.

Accepted Answer

A) Making Sure It Is Well Defined 
B) Designing with White Space 
C) Knowing Your Users 
D) Defining Crucial KPIs 
A) Making Sure It Is Well Defined 
B) Designing with White Space 
C) Knowing Your Users 
D) Defining Crucial KPIs

Question 8

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

Accepted Answer

The answer of ________ is an interactive data visualization,exploration,and presentation...

Question 9

Which of the following is NOT a pane that is visible when you first insert a Power View report sheet?

Accepted Answer

A) Silverlight pane 
B) Design pane 
C) Power View pane 
D) Filters pane 
A) Silverlight pane 
B) Design pane 
C) Power View pane 
D) Filters pane

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

A typical manager engages in over 300 different tasks and decisions each day.

Accepted Answer

A) True 
 B)False

Question 12

A negative KPI is when the greater the value the worse the KPI,such as the number of sick days in a specific time period.

Accepted Answer

A) True 
 B)False

Question 13

A(n)________ is a collection of tables and their relationships reflecting the real-world relationships between business functions and processes.

Accepted Answer

The answer of A(n)________ is a collection of tables and...

Question 14

A KPI is a quantifiable measure that helps managers define progress toward both short-term and long-term goals.

Accepted Answer

A) True 
 B)False

Question 15

A base value can either be another calculated field that resolves to a value or an absolute value.

Accepted Answer

A) True 
 B)False

Question 16

Successful ________ should help summarize complex data so users can interpret the information at a glance.

Accepted Answer

The answer of Successful ________ should help summarize complex data...

Question 17

Calculated fields can be extended to become ________.

Accepted Answer

A) target values 
B) status thresholds 
C) KPIs 
D) base values 
A) target values 
B) status thresholds 
C) KPIs 
D) base values

Question 18

________ expand across the available space in the container,and if additional space is needed a horizontal scroll bar is added.

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 19

A company's profit 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 20

Match between columns
                        Premises: Positive KPI
Negative KPI
Slicer
Sparkline
Bidirectional KPI

Accepted Answer

The Answer of Value becomes worse as it deviates too is...

All of the following statements are TRUE about preparing a dashboard for production EXCEPT:

All of the following statements are TRUE about the Microsoft Azure Marketplace EXCEPT:

All of the following statements are TRUE about using apps for Office for data visualizations EXCEPT:

The temperature for storing a particular product where damage could occur if the temperature gets too cold or too hot is an example of a ________.

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

Sparklines provide a way to graphically summarize a row or column of data in a single cell.

You can increase the success of your dashboard by taking personal preferences into account whenever possible.This is an example of the ________ design concept.

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

Which of the following is NOT a pane that is visible when you first insert a Power View report sheet?

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

A typical manager engages in over 300 different tasks and decisions each day.

A negative KPI is when the greater the value the worse the KPI,such as the number of sick days in a specific time period.

A(n)________ is a collection of tables and their relationships reflecting the real-world relationships between business functions and processes.

A KPI is a quantifiable measure that helps managers define progress toward both short-term and long-term goals.

A base value can either be another calculated field that resolves to a value or an absolute value.

Successful ________ should help summarize complex data so users can interpret the information at a glance.

Calculated fields can be extended to become ________.

________ expand across the available space in the container,and if additional space is needed a horizontal scroll bar is added.

A company's profit is an example of a ________.

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

All of the following statements are TRUE about preparing a dashboard for production EXCEPT:

All of the following statements are TRUE about the Microsoft Azure Marketplace EXCEPT:

All of the following statements are TRUE about using apps for Office for data visualizations EXCEPT:

The temperature for storing a particular product where damage could occur if the temperature gets too cold or too hot is an example of a ________.

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

Sparklines provide a way to graphically summarize a row or column of data in a single cell.

You can increase the success of your dashboard by taking personal preferences into account whenever possible.This is an example of the ________ design concept.

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

Which of the following is NOT a pane that is visible when you first insert a Power View report sheet?

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

A typical manager engages in over 300 different tasks and decisions each day.

A negative KPI is when the greater the value the worse the KPI,such as the number of sick days in a specific time period.

A(n)________ is a collection of tables and their relationships reflecting the real-world relationships between business functions and processes.

A KPI is a quantifiable measure that helps managers define progress toward both short-term and long-term goals.

A base value can either be another calculated field that resolves to a value or an absolute value.

Successful ________ should help summarize complex data so users can interpret the information at a glance.

Calculated fields can be extended to become ________.

________ expand across the available space in the container,and if additional space is needed a horizontal scroll bar is added.

A company's profit is an example of a ________.

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