A category of information, such as last name or order amount, that is stored in a table. When Query displays a result set in its Data pane, a field is represented as a column.
A reference to a cell or range on a sheet in another Excel workbook, or a reference to a defined name in another workbook.
A range of data that is brought into a worksheet but that originates outside of Excel, such as in a database or text file. In Excel, you can format the data or use it in calculations as you would any other data.
Data that is stored in a database, such as Access, dBASE, or SQL Server, that is separate from Query and the program from which you started Query.
Formerly known as an Excel list, you can create, format, and expand an Excel table to organize the data on your worksheet.
Components that can be installed on your computer to add commands and functions to Excel. These add-in programs are specific to Excel. Other add-in programs that are available for Excel or Office are Component Object Model (COM) add-ins.
Usually used in statistical or scientific data, error bars show potential error or degree of uncertainty relative to each data marker in a series.
A chart that is placed on a worksheet rather than on a separate chart sheet. Embedded charts are beneficial when you want to view or print a chart or a PivotChart report with its source data or other information in a worksheet.