Excel 2010 Bible

Part V: Analyzing Data with Excel

688

FIGURE 33.11

The results of the query.

Working with Data Returned by Query

Excel stores the data that Query returns in either a worksheet or a pivot table cache. When Excel

stores data in a worksheet, it stores the data in a table that’s a specially named range known as an

external data range; Excel creates the name for this range automatically. In this example, the

external data range is named Table_Query_from_Budget_Database.

You can manipulate data returned from a query just like any other worksheet range. For example,

you can sort the data, format it, or create formulas that use the data.

The following sections describe what you can do with the data that Excel receives from Query and

stores in a worksheet.

Adjusting the external data range properties

You can adjust various properties of the external data range by using the External Data Properties

dialog box (see Figure 33.12).

To display this dialog box, the cell pointer must be within the external data range. Open this

dialog box by using either of these methods:

l (^) Right-click and choose Table ➪ External Data Properties from the shortcut menu.
l Choose Data ➪ Connections ➪ Properties.