Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Excel Terms
| Term | Definition |
|---|---|
| Absolute Cell Reference | In a spreadsheet, a reference to one specific cell, rather than a relative reference which would indicate the placement of a cell in reference to the current cell (for example, four rows above in the same column). Since cell references in a spreadsheet ar |
| Active Cell | The cell in a spreadsheet in which numbers or formulas can be entered. The active cell shows a thick border, and its name is at the top of the screen; also called the current cell. |
| Argument | A value that is passed to a program, subroutine, procedure, or function by the calling program; one of the independent variables that determine the output. |
| Cell | A box in a spreadsheet or table where data can be entered. |
| Cell Reference | Exact designation of a cell's location in a spreadsheet, indicated by a column letter and a row number. The address D4 would be in column D, row 4. Also called cell address. |
| IF | Intermediate Frequency |
| Relative Cell Reference | A reference to a cell in a spreadsheet, such as B3, that indicates its relationship to other cells. When a formula containing relative cell references is copied to a different cell, it maintains its relative references. For example, the formula may state |
| Text | character data |
| Auto Fil | A feature that enables you to copy the contents of a cell or a range of cells or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells |
| Average | A predefined formula that calculates the arithmetic mean of values in a range. |
| Comment | a private note, annotation, or additional information to the author or another reader about the content of a document. |
| Count | A predefined formula that tallies the number of cells in a range that contain values you can use in calculations, such as numerical and date data, but excludes blank cells or text entries from the tally. |
| Fill Handle | A small black square at the bottom right corner of a cell used to copy cell content or text or number patterns to adjacent cells. |
| Formula | A combination of cell references, operators, values, and/or functions used to perform a calculation. |
| Formula Bar | An element in excel that appears below the ribbon and to the right of the insert command that shows the contents of the active cell so that you edit the text, value, date, formula, or function. |
| Function | A predefined computation that simplifies creating a complex calculation and produces a result based on inputs known as arguments. |
| MAX | a predefined formula that finds the highest value in a range. |
| Mixed Cell Reference | A designation that combines an absolute cell reference with a relative cell reference. |
| Name Box | an element in excel that identifies the address or range name of the active cell in a worksheet. |
| PMT | a predefined formula that calculates the periodic payment for a loan with a fixed interest rate and fixed term. |
| Pointing | the process of using the mouse pointer to select cells while building a formula/ semi selection. |
| Range | a group of adjacent or contiguous cells in a excel worksheet. |
| Sheet tab | a visual item in excel that looks like a folder tab that displays the name of a worksheet. |
| Values | a number that represents a quantity or amount. |
| VLOOKUP | a predefined formula that looks up a value and returns a related result from the lookup table. |
Created by:
650435630