Question 1

A(n)________ field is a field where a calculation takes place,but a new calculated field is not being created.

Accepted Answer

A) bidirectional 
B) explicit calculated 
C) implicit calculated 
D) vertical multiple 
A) bidirectional 
B) explicit calculated 
C) implicit calculated 
D) vertical multiple

Question 2

A data model is a collection of tables and their relationships reflecting the real-world relationships between business functions and processes.

Accepted Answer

A) True 
 B)False

Question 3

A(n)________ value can either be another calculated field that resolves to a value or an absolute value.

Accepted Answer

The answer of A(n)________ value can either be another calculated...

Question 4

The ________ provides a structure for managing complex IT projects.

Accepted Answer

systems de

Question 5

An implicit calculated field is created when a formula is typed in the Calculation Area of the PowerPivot window.

Accepted Answer

A) True 
 B)False

Question 6

All of the following statements are TRUE about the current business drivers for dashboard initiatives EXCEPT ________.

Accepted Answer

A) the need to recruit the best employees 
B) the need to gain visibility into key business processes 
C) the need for one view of the business date 
D) improved timeliness and accuracy of business decisions 
A) the need to recruit the best employees 
B) the need to gain visibility into key business processes 
C) the need for one view of the business date 
D) improved timeliness and accuracy of business decisions

Question 7

Match between columns
                        Premises: Explicit calculated field
Status threshold
Base value
Target value
Implicit calculated field

Accepted Answer

The Answer of Can only use standard aggregation functions and is...

Question 8

One of the primary goals of a dashboard is to help the user navigate and interpret a large quantity of data at a glance.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) Designing with White Space 
A) Making Sure It Is Well Defined 
B) Keeping It Simple 
C) Knowing Your Users 
D) Designing with White Space

Question 9

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

Accepted Answer

A) Sparklines 
B) Power View 
C) Slicers 
D) Silverlight 
A) Sparklines 
B) Power View 
C) Slicers 
D) Silverlight

Question 10

A status threshold is defined by the range between a high and low value.

Accepted Answer

A) True 
 B)False

Question 11

All of the following statements are TRUE about the new data model EXCEPT:

Accepted Answer

A) Data can be added to the data model from a variety of sources. 
B) Many organizations store data inside a relational database such as MySQL, Oracle, or a DBMS like Microsoft Access. 
C) Most organizations store their data in a relational database in order to ensure their data are secure, accurate, and consistent. 
D) Prior to Excel 2010, it would be very complicated and time consuming to integrate relational data into an analysis. 
A) Data can be added to the data model from a variety of sources. 
B) Many organizations store data inside a relational database such as MySQL, Oracle, or a DBMS like Microsoft Access. 
C) Most organizations store their data in a relational database in order to ensure their data are secure, accurate, and consistent. 
D) Prior to Excel 2010, it would be very complicated and time consuming to integrate relational data into an analysis.

Question 12

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.

Accepted Answer

A) True 
 B)False

Question 13

A(n)________ calculated field is created when you drag a field like Sales or Quantity Sold into the Values area of a PivotTable.

Accepted Answer

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

Question 14

________ will expand across the width of the container and wrap down the container in the available space and a vertical scroll bar may also be 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 15

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

Accepted Answer

A) True 
 B)False

Question 16

A(n)________ is a quantifiable measure that helps managers define progress toward both short-term and long-term goals.

Accepted Answer

key perfor

Question 17

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

Accepted Answer

The answer of A typical manager engages in over ________...

Question 18

You can expand and collapse the ribbon by pressing Alt+F1.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

The answer of A(n)________ is when the greater the value...

Question 20

Excel's Power View report includes a map ________ that can be used with filters or slicers,or even used to filter other charts in the report.

Accepted Answer

The answer of Excel's Power View report includes a map...

A(n)________ field is a field where a calculation takes place,but a new calculated field is not being created.

A data model is a collection of tables and their relationships reflecting the real-world relationships between business functions and processes.

A(n)________ value can either be another calculated field that resolves to a value or an absolute value.

The ________ provides a structure for managing complex IT projects.

An implicit calculated field is created when a formula is typed in the Calculation Area of the PowerPivot window.

All of the following statements are TRUE about the current business drivers for dashboard initiatives EXCEPT ________.

One of the primary goals of a dashboard is to help the user navigate and interpret a large quantity of data at a glance.This is an example of the ________ design concept.

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

A status threshold is defined by the range between a high and low value.

All of the following statements are TRUE about the new data model EXCEPT:

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.

A(n)________ calculated field is created when you drag a field like Sales or Quantity Sold into the Values area of a PivotTable.

________ will expand across the width of the container and wrap down the container in the available space and a vertical scroll bar may also be added.

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

A(n)________ is a quantifiable measure that helps managers define progress toward both short-term and long-term goals.

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

You can expand and collapse the ribbon by pressing Alt+F1.

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

Excel's Power View report includes a map ________ that can be used with filters or slicers,or even used to filter other charts in the report.

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)________ field is a field where a calculation takes place,but a new calculated field is not being created.

A data model is a collection of tables and their relationships reflecting the real-world relationships between business functions and processes.

A(n)________ value can either be another calculated field that resolves to a value or an absolute value.

The ________ provides a structure for managing complex IT projects.

An implicit calculated field is created when a formula is typed in the Calculation Area of the PowerPivot window.

All of the following statements are TRUE about the current business drivers for dashboard initiatives EXCEPT ________.

One of the primary goals of a dashboard is to help the user navigate and interpret a large quantity of data at a glance.This is an example of the ________ design concept.

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

A status threshold is defined by the range between a high and low value.

All of the following statements are TRUE about the new data model EXCEPT:

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.

A(n)________ calculated field is created when you drag a field like Sales or Quantity Sold into the Values area of a PivotTable.

________ will expand across the width of the container and wrap down the container in the available space and a vertical scroll bar may also be added.

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

A(n)________ is a quantifiable measure that helps managers define progress toward both short-term and long-term goals.

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

You can expand and collapse the ribbon by pressing Alt+F1.

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

Excel's Power View report includes a map ________ that can be used with filters or slicers,or even used to filter other charts in the report.

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