Deck 11: Analyzing Data With Business Intelligence

Question 1

The text from a web query is placed in a worksheet as formatted text.

Answer 1

  False

Question 2

The following is an example of a delimiter: _______.

A) #
B) $ 
C) tab
D) period

Answer 2

  C

Question 3

When you _______ data,you specify which records you want to retrieve using specific criteria.

A) order
B) filter 
C) strike
D) rekey

Answer 3

  B

Question 4

In addition to specifying the format of data using the Text Import Wizard,you can also indicate which columns you want to import.

Question 5

You relate tables to one another by using _______ fields.

A) key
B) common 
C) indexed
D) date

Question 6

A data _______ is any file that contains the data you want to retrieve.

A) roster
B) link 
C) dialog
D) source

Question 7

_______ is a database program.

A) Word
B) Access 
C) PowerPoint
D) Outlook

Question 8

A(n)_______ might ask something like,"What are the names of all the stocks in the portfolio,and what are their corresponding ticker symbols?" 

A) index
B) matrix 
C) register
D) query

Question 9

For a fixed-width text file to import correctly into Excel,there must be some way for the Text Import Wizard to know where each column begins and ends.

Question 10

One way to structure text files is to use a(n)_______.

A) index
B) matrix 
C) delimiter
D) register

Question 11

Excel can save a workbook as a text file,preserving only the data values,without any of the formats applied to it.

Question 12

In the Text Import Wizard,the Preview window shows the initial rows of the text file._________________________

Question 13

When you use Excel to connect to a text file,the _______ Wizard determines whether the data is in a fixed-width format or a delimited format.

A) File
B) Open File 
C) Open Text
D) Text Import

Question 14

Most software programs can both save and retrieve data in a(n)_______ file format.

A) HTML
B) text 
C) spreadsheet
D) picture

Question 15

Databases in which tables can be joined through the use of common fields are known as _______ databases.

A) structured
B) relational 
C) linked
D) trusted

Question 16

A(n)_______ is a file that stores a collection of related data.

A) index
B) register 
C) database
D) table

Question 17

Columns in delimited text files are always vertically aligned as they would be in a spreadsheet.

Question 18

When no arrow connects a table to any of the other tables in the data model,there is no way to match the records of that table with the other tables.

Question 19

A data connection is like a pipeline from a data source to two or more locations in the workbook.

Question 20

A database is divided into separate tables.

Question 21

Database tables can be inserted directly into PivotCharts and PivotFigures.​​ 

Question 22

Audra is a manager in the Sales Department for Creative Pastry Gadgets.She needs access to up-to-date financial data and sales reports.Some of this information comes from Excel workbooks,but other information is stored in other software programs.In addition,Creative Pastry Gadgets maintains a database with detailed financial information and sales figures.Audra uses Excel to analyze data from external data sources.​Audra wants the workbook to always display the most current values from a text file used when importing external sales data.What is the advantage of editing the properties of the connection versus editing the properties of the external data range? 

A) The choices are applied to all of the external data ranges that use that connection. 
B) The choices are applied only to the current workbook. 
C) The choices are only applied the first time the workbook is opened after the properties have been changed. 
D) There is no advantage-it would be better to edit the properties of the external data range.

Question 23

William works for a nationwide real estate agency.He uses the agency's website to promote the latest homes.He uses Access to store information concerning the home and Excel to analyze the data.Fall open houses include homes in Seattle,Chicago,and Denver.Spring open houses include tours of homes in Washington,D.C.,New Mexico,Alaska,and Montana.Summer home tours include Paris,Rome,Denmark,and Australia.​William wants Excel to automatically refresh the connection between his Excel workbook and his Access database whenever the workbook is opened.He should click the Refresh data when opening the file check box in the Connection Properties dialog box.What steps should he take to open the Connection Properties dialog box? 

A) Click the Data tab on the Ribbon, click the Connections button in the Connections group, then click the Connection button. 
B) Click the Data tab on the Ribbon, click the Connections button in the Connections group, select the database, then click the Properties button. 
C) Click the Edit tab on the Ribbon, then click the Connections button in the Connections group. 
D) Click the Edit tab on the Ribbon, click the Connections button in the Connections group, select the database, then click the Properties button.

Question 24

A text file contains only text and numbers without any formulas,special fonts,graphics,or formatted text.​​ 

Question 25

A collection of data stored in rows and columns

Question 26

William works for a nationwide real estate agency.He uses the agency's website to promote the latest homes.He uses Access to store information concerning the home and Excel to analyze the data.Fall open houses include homes in Seattle,Chicago,and Denver.Spring open houses include tours of homes in Washington,D.C.,New Mexico,Alaska,and Montana.Summer home tours include Paris,Rome,Denmark,and Australia.​William wants his connection files listed in the Existing Connections dialog box.He should save the connections in the _______ folder.

A) My Connections
B) My Data Sources 
C) My Documents
D) My Sources

Question 27

Stores information about a specific characteristic of a person,place,or thing

Question 28

A question you ask about the data in a database

Question 29

A figure is a collection of data arranged in rows and columns.​​ 

Question 30

Audra is a manager in the Sales Department for Creative Pastry Gadgets.She needs access to up-to-date financial data and sales reports.Some of this information comes from Excel workbooks,but other information is stored in other software programs.In addition,Creative Pastry Gadgets maintains a database with detailed financial information and sales figures.Audra uses Excel to analyze data from external data sources.​To prevent other users from updating a data source without permission,what should Audra do? 

A) Define the data source. 
B) Remove the connection. 
C) Require a password. 
D) Nothing-Excel cannot prevent data from being refreshed.

Question 31

Each column of a database table,called a field,stores information about a specific characteristic of a person,place,or thing.​​ 

Question 32

Collection of data organized to be easily retrieved and used by the end user

Question 33

A query is a request for information from a data source.​ 

Question 34

Audra is a manager in the Sales Department for Creative Pastry Gadgets.She needs access to up-to-date financial data and sales reports.Some of this information comes from Excel workbooks,but other information is stored in other software programs.In addition,Creative Pastry Gadgets maintains a database with detailed financial information and sales figures.Audra uses Excel to analyze data from external data sources.​Audra needs to delete a connection to a data source.She should select the connection in the list in the Workbook Connections dialog box,and then click the _______ button.

A) Delete
B) Remove 
C) Omit
D) Detach

Question 35

A delimiter is a symbol that separates one column of data from another.

Question 36

Data sources can be databases,text files,or other Excel workbooks.​​ 

Question 37

Each row of a database table,called a field,displays a collection of characteristics of a particular person,place,or thing.​​ 

Question 38

Audra is a manager in the Sales Department for Creative Pastry Gadgets.She needs access to up-to-date financial data and sales reports.Some of this information comes from Excel workbooks,but other information is stored in other software programs.In addition,Creative Pastry Gadgets maintains a database with detailed financial information and sales figures.Audra uses Excel to analyze data from external data sources.​Audra decides to import data so it will be stored in an external data range.She learns that Excel automatically assigns the data range a defined name based on the filename of the _______.

A) open source
B) destination file 
C) data source
D) file source

Question 39

One way to interact with a database is with a query language.The most popular query language is _______.

A) ODC
B) UDC 
C) OLE
D) SQL

Question 40

Displays the collection of characteristics of a particular person,place,or thing

Question 41

A scatterline is a line fitted to a scatter chart showing the relationship between two numerical variables.

Question 42

The source editor is an office tool used to write queries.​ 

Question 43

One way to identify a trend is by adding a scatterline to a trend chart of the data.​ 

Question 44

Databases in which tables can be joined through the use of common fields are known as situational databases.​ 

Question 45

To create a worksheet containing forecasted values,including values that follow a seasonal pattern,you click the Forecast Sheet button.​ 

Question 46

Power Map is an add-in that presents data geographically on a virtual 3-D globe.​ 

Question 47

One advantage of forecast sheets is that they can be used to analyze annual data in which the values follow a periodic pattern throughout the calendar year.​ 

Question 48

Make sure your data files are set up with password controls to prohibit unauthorized access.​ 

Question 49

Power Query is a BI tool used for writing queries to almost any kind of data source,from text files to websites to large database structures.​ 

Question 50

All steps in Power Query are written in the language P.

Question 51

Loading data from a query into Excel creates a snapshot of that data.

Question 52

To change the confidence interval percentage,expand Options,and then enter a new value in the Confidence Interval box.​ 

Question 53

Power organization sheets are organized around data visualizations,which are the tables,charts,and maps that present data in a visual way.​ 

Question 54

The connection between a workbook and a data source can be lost when one or the other is moved to a new location.​ 

Question 55

In a query,you can group the data by the values within one of the columns.​ 

Question 56

Power View is a BI tool for visually exploring the data from Power Pivot and is chiefly used for finding hidden relationships within the data.​ 

Question 57

Power and Exponential trendlines cannot be used if the data contains zero or negative values.​ 

Question 58

A hierarchy is an organization of fields that start with the most general and go down to the most specific.​ 

Question 59

Power Map data is placed in tables,which are superimposed on the map.​ 

Question 60

A data source is usually organized in the way you need it for your report.​ 

Question 61

 You need at least ____ complete years of data to project a seasonal trend for the next year.​ 

A) ​One 
B) ​Two 
C) ​Three 
D) ​Four

Question 62

You can click the ________ View button in Power Pivot to view the structure and relationships of the tables in the Data Model.​ 

A) ​Data  
B) ​Diagram 
C) Database 
D) None of the above

Question 63

A ________can retrieve data from multiple fields in different tables in the Data Model​ 

A) Diagram 
B) ​Record 
C) ​PivotTable 
D) ​Timeline slicer

Question 64

A ________ is a highly structured collection of data values organized into separate tables.​ 

A) ​Data model 
B) ​Diagram 
C) Database 
D) None of the above​

Question 65

A __________ is a slicer that is applied to date fields.Using the timeline,you can summarize the data for ranges of time intervals from years down to minutes and seconds.​ 

A) Trendline 
B) ​Timeline 
C) ​Scatter line 
D) ​PivotTable

Question 66

The Power Pivot add-in provides access to the _________.​ 

A) ​Data model 
B) ​Diagram 
C) ​Database 
D) ​None of the above

Question 67

The Query Editor also includes tools to:​ 

A) ​create new columns 
B) group data values 
C) ​calculate summary statistics 
D) All of the above

Question 68

Use data ________ to prevent hackers from gaining unauthorized access to sensitive information.​ 

A) ​Encryption 
B) ​Security 
C) Privacy 
D) ​Saving

Question 69

When you create a grouping,the query editor adds a new column to summarize the numeric values within each group by calculating the:​ 

A) ​Sum, average, median, minimum, or maximum of the data values 
B) ​Count of rows within each group 
C) Count of rows with distinct values within each group 
D) All of the above

Question 70

You should have ____ source(s)of your data.

A) ​One 
B) ​Two 
C) ​Three 
D) ​Four

Question 71

The _______ is part of an OLAP (Online Analytic Processing)database,built to optimize structured data for querying and reporting.​ 

A) ​Data Cube 
B) ​Data Model 
C) ​Encryption Source 
D) ​Exponential Trendline

Question 72

Which of the following is not a type of trendline?​ 

A) ​Exponential 
B) ​Linear 
C) Horizontal 
D) ​Power

Question 73

A ________ is an organization of fields that start with the most general and go down to the most specific.​ 

A) ​Hierarchy 
B) ​Trendline 
C) ​Data Cube 
D) ​Timeline slicer

Question 74

A ______ stores information about a specific characteristic of a person,place,or thing,such as a store ID.​ 

A) ​ Field 
B) ​ Record 
C) ​ PivotTable 
D) ​Timeline slicer

Question 75

A _______ is a collection of fields.​ 

A) ​Diagram 
B) ​Record 
C) ​PivotTable 
D) Timeline slicer