|
|
|
5
|
a format, such as cell shading or font color, that Excel automatically applies to cells if a specified condition is true
|
|
8
|
a subcategory of a field in PivotTable and PivotChart reports. For instance, the field 'Month' could have items such as 'January,' 'February,' and so on
|
|
9
|
individual values that are plotted in a chart. Related data points make up a data series. Data points are represented by bars, columns, lines, slices, dots, and other shapes. These shapes are called data markers
|
|
10
|
the small black square in the lower]right corner of the selection. When you point to the fill handle, the pointer changes to a black cross
|
|
11
|
a tool that helps you create or edit a formula and also provides information about functions and their arguments
|
|
12
|
a combination of operators, field names, functions, literals, and constants that evaluates to a single value. Expressions can specify criteria (such as Order Amount 10000) or perform calculations on field values (such as Price*Quantity)
|
|
14
|
the values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names
|
|
17
|
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
|
|
18
|
a stored set of 'source' information used to connect to a database. A data source can include the name and location of the database server, the name of the database driver, and information that the database needs when you log on.
|
|
|
|
|
|
|
1
|
cells that contain formulas that refer to other cells. For example, if cell D10 contains the formula =B5, cell D10 is a dependent of cell B5
|
|
2
|
divider that breaks a worksheet into separate pages for printing. Excel inserts automatic page breaks based on the paper size, margin settings, scaling options, and the positions of any manual page breaks that you insert
|
|
3
|
conditions you specify to limit which records are included in the result set of a query. For example, the following criterion selects records for which the value for the Order Amount field is greater than 30,000: Order Amount 30000
|
|
4
|
the entire chart and all its elements
|
|
5
|
a set of search conditions that is used to find data. Comparison criteria can be a series of characters that you want to match, such as 'Northwind Traders,' or an expression, such as 300
|
|
6
|
items on either side of an operator in a formula. In Excel, operands can be values, cell references, names, labels, and functions
|
|
7
|
a single cell that is created by combining two or more selected cells. The cell reference for a merged cell is the upper]left cell in the original selected range
|
|
13
|
one or more ranges of cells that you designate to print when you do not want to print the entire worksheet. If a worksheet includes a print area, only the print area is printed
|
|
15
|
the target destination for data that has been cut or copied by using the Office Clipboard
|
|
16
|
to update data from an external data source. Each time you refresh data, you see the most recent version of the information in the database, including any changes that were made to the data
|
|
19
|
two or more cells on a sheet; a group of selected cells. The cells in a range can be adjacent or nonadjacent
|
|
|
|
