Exam 11: Analyzing Data With Business Intelligence

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.

(Multiple Choice)

4.8/5

(31)

Question 21

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

(True/False)

4.9/5

(40)

Question 22

Identify the letter of the choice that best matches the phrase or definition. -Displays the collection of characteristics of a particular person,place,or thing

(Multiple Choice)

4.8/5

(29)

Question 23

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

(Multiple Choice)

4.9/5

(23)

Question 24

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

(True/False)

4.8/5

(28)

Question 25

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

(Multiple Choice)

4.8/5

(30)

Question 26

Identify the letter of the choice that best matches the phrase or definition. -Stores information about a specific characteristic of a person,place,or thing

(Multiple Choice)

4.9/5

(31)

Question 27

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

(Multiple Choice)

4.8/5

(35)

Question 28

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

(True/False)

4.8/5

(35)

Question 29

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

(Multiple Choice)

4.9/5

(31)

Question 30

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

(True/False)

4.9/5

(32)

Question 31

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.

(Multiple Choice)

4.8/5

(29)

Question 32

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

(True/False)

4.7/5

(36)

Question 33

The following is an example of a delimiter: _______.

(Multiple Choice)

4.8/5

(27)

Question 34

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

(True/False)

4.9/5

(38)

Question 35

Identify the letter of the choice that best matches the phrase or definition. -A collection of data stored in rows and columns

(Multiple Choice)

4.9/5

(32)

Question 36

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

(True/False)

5.0/5

(34)

Question 37

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

(Multiple Choice)

4.9/5

(36)

Question 38

A database is divided into separate tables.

(True/False)

4.8/5

(33)

Question 39

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

(True/False)

4.8/5

(31)

Question 40

Showing 21 - 40 of 75

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

Identify the letter of the choice that best matches the phrase or definition. -Displays the collection of characteristics of a particular person,place,or thing

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

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

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

Identify the letter of the choice that best matches the phrase or definition. -Stores information about a specific characteristic of a person,place,or thing

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

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

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

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

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.

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

The following is an example of a delimiter: _______.

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

Identify the letter of the choice that best matches the phrase or definition. -A collection of data stored in rows and columns

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

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

A database is divided into separate tables.

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

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivottables, and Pivotcharts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What-If Analyses

Collaborating on a Shared Workbook

Working With Text Functions

Filters

Exam 11: Analyzing Data With Business Intelligence

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

Identify the letter of the choice that best matches the phrase or definition. -Displays the collection of characteristics of a particular person,place,or thing

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

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

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

Identify the letter of the choice that best matches the phrase or definition. -Stores information about a specific characteristic of a person,place,or thing

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

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

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

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

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.

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

The following is an example of a delimiter: _______.

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

Identify the letter of the choice that best matches the phrase or definition. -A collection of data stored in rows and columns

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

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

A database is divided into separate tables.

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

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivottables, and Pivotcharts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What-If Analyses

Collaborating on a Shared Workbook

Working With Text Functions

Filters

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

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

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

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

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

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

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

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