Exam 7: Organizing Data for Effective Analysis

Explore all topics

When the data elements are being imported using an XML map, only the element names appear in the worksheet. To import the data from these elements into the worksheet, click the ____ button in the External Table Data group on the TABLE TOOLS DESIGN tab.

(Multiple Choice)

4.8/5

(34)

Question 141

Case 7-2 Robert has imported some data from Access and is using the Query Wizard to filter the data. Please refer to the above figure when answering the questions below. -Robert wants to send a special gift to anyone who has placed his or her first order in the past three months or who has total sales of over $1,000 per year. In this case, Robert would use a(n) ____.

(Multiple Choice)

4.7/5

(38)

Question 142

MATCHING Identify the letter of the choice that best matches the PivotTable that has been added to the worksheet shown in the figure above. -PivotTable inserted on a new worksheet

(Multiple Choice)

4.9/5

(40)

Question 143

Excel includes several external data sources saved as database files that you can use to import data into Excel.

(True/False)

4.7/5

(37)

Question 144

A(n) PivotSheet report is an interactive report that lets you summarize and analyze a data set. _________________________

(True/False)

4.7/5

(46)

Question 145

You can enter data into a worksheet by ____.

(Multiple Choice)

4.7/5

(42)

Question 146

Identify the letter of the choice that best matches the date and time function. -Returns a decimal number for a specific time that is represented by a text string

(Multiple Choice)

4.8/5

(34)

Question 147

In the FIND function, ____ is the text containing the text that you want to find.

(Multiple Choice)

4.8/5

(30)

Question 148

When you click a filter arrow in the header row, you can ____.

(Multiple Choice)

4.8/5

(42)

Question 149

____ provides structure for a document by dividing it into elements (pieces) such as title, paragraph, text, name, part number, and so on.

(Multiple Choice)

4.8/5

(34)

Question 150

Showing 141 - 150 of 150

When the data elements are being imported using an XML map, only the element names appear in the worksheet. To import the data from these elements into the worksheet, click the ____ button in the External Table Data group on the TABLE TOOLS DESIGN tab.

MATCHING Identify the letter of the choice that best matches the PivotTable that has been added to the worksheet shown in the figure above. -PivotTable inserted on a new worksheet

Excel includes several external data sources saved as database files that you can use to import data into Excel.

A(n) PivotSheet report is an interactive report that lets you summarize and analyze a data set. _________________________

You can enter data into a worksheet by ____.

Identify the letter of the choice that best matches the date and time function. -Returns a decimal number for a specific time that is represented by a text string

In the FIND function, ____ is the text containing the text that you want to find.

When you click a filter arrow in the header row, you can ____.

____ provides structure for a document by dividing it into elements (pieces) such as title, paragraph, text, name, part number, and so on.

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Using Data Tables and Excel Scenarios for What If Analysis

Enhancing Decision Making with Solver

Troubleshooting Workbooks and Automating Excel Applications

Filters