click below
click below
Normal Size Small Size show me how
Learn Key Excel 2
NLISD - Learn Key Excel Session 2 Vocabulary
| Question | Answer |
|---|---|
| A block of cells that can be selected, manipulated, named, or formatted as a group. | Range |
| A cell in the database that contains information, such as name, address, and zip code. | Field |
| A feature located under the toolbars at the top of the working screen. It contains the edit line for working with formulas and provides information regarding cell addresses. | Formula Bar |
| A feature that will count the number of cells in a range that contain numbers. | Count |
| A connection between two files that automatically updates one file whenever the other is changed | Hot Link |
| An individual and unique rectangular section of a document that is the intersection of a column and a row. | Cell |
| A function that allows the user to easily average a range based on specific criteria. | Average If |
| A feature that allows the user to enter an IF function for the second argument in a IF function; allowing up to 64 levels. | Nested If |
| A set of instructions that determine which information the database function will be applied to. | Criteria Range |
| A graphical representation of the data from a Pivot Table | Pivot Chart |
| A feature that will look up values in columns. | VLOOKUP |
| A setting where the brightness overwhelms the contrast. | Watermark. |