Exam 11: Connecting to External Data

Case-Based Critical Thinking Questions Case 11-2 Sadra works for a local travel agency.She uses the agency's Web site to promote the latest tours.She uses Access to store information concerning the tours and Excel to analyze the data.Fall tours include trips to Honolulu,Seattle,Chicago,and Denver.Spring tours include trips to Washington,D.C. ,New Mexico,Alaska,and Montana.Summer tours include Paris,Rome,Denmark,and Australia. -Sadra is told by her database administrator to always document her connections to external data.Why is this important?

When Excel imports external data into a PivotTable or PivotChart,the initial table and chart are ____.

-In the accompanying figure,Item 2 points to the ____.

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

-In the accompanying figure,Item ____ points to the formatted title.

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

Data in an XML document is contained within ____________________.

-The item marked 1 in the accompanying figure is the row or field in a database table._________________________

The following is a NOT a common text filename extension: ____.

When using the Text Import Wizard,you can specify a column's format before the column is imported.

Case-Based Critical Thinking Questions Case 11-1 Tayler is a manager in the Sales Department for BusyBody Toymakers.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,BusyBody Toymakers maintains a database with detailed financial information and sales figures.Tayler uses Excel to analyze data from external data sources. -To prevent other users from updating a data source without permission,what should Tayler do?

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

The following is an example of a delimiter: ____.

When you save a query,you are actually placing the query choices you have made into a file.

Case-Based Critical Thinking Questions Case 11-1 Tayler is a manager in the Sales Department for BusyBody Toymakers.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,BusyBody Toymakers maintains a database with detailed financial information and sales figures.Tayler uses Excel to analyze data from external data sources. -Tayler creates a chart displaying the company's recent sales history.When she resizes the chart,the image is distorted.What key should she hold down while resizing the chart so that it is resized proportionately?

If a break is in the wrong location in the Data preview window,you double-click it to move it to a new location in the window.

To select fields within the Query Wizard,you can ____ the field name and Excel will automatically move it to the list of selected columns in your query.

When using the Text Import Wizard,skip importing a column by clicking the column in the Row preview box and then clicking the Do not import (skip)option button._________________________

A ____ delimiter is often the best way of separating text columns because text delimited this way can include spaces or commas within each column.

One of the advantages of using XML as a data source is that it allows you to attach,or ____,elements to specific cells in the workbook.