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

The systems development life cycle (SDLC)provides a structure for managing complex IT projects.

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

An app for Office is essentially a web page that is hosted inside an Office application.

A(n)________ value is a calculated field that resolves to a value.

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

When naming cells,avoid names that have already been given to calculated columns within the same workbook.

________ multiples expand across the available space in the container.

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

All of the following statements are TRUE about business intelligence EXCEPT:

When you first insert a Power View report sheet,three panes are visible: the Design pane,Filters pane,and the ________ pane.

A ________ can be the aggregate of 2013 Profit or a monthly sales goal that every employee should meet.

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

To be able to manipulate Slicers,you must allow users to Edit Objects,which does allow changes to the PivotCharts.

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

As a general rule,the less defined you can make your dashboard theme,the more useful your users will find it.