Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
23 Cards in this Set
- Front
- Back
Absolute reference
|
Cell reference that points to a specific cell and does not change when copied; appears with a dollar sign ($) before each column and row designation.
|
|
Argument
|
Specifies the numbers, text, or cell references used by the function to calculates a value.
|
|
Auto Fill
|
An Excel tool that enables you to copy the contents of the selected cells by dragging the fill handle over another adjacent cell or range of cells rather than using the Copy and Paste commands.
|
|
AVERAGE function
|
Excel function that calculates the average value of a collection of numbers.
|
|
Date function
|
Category of Excel functions that store and calculate dates as numeric values, representing the number of days since January 1, 1900.
|
|
Destination range
|
The range on a worksheet in which formulas have been copied and pasted.
|
|
Fill handle
|
A small black square in the lower-right corner of a selected cell or cell range that you drag to copy the contents of the selected cells to adjacent cells.
|
|
MAX function
|
Excel function that calculates the maximum accounts for a given category and has a similar syntax to the AVERAGE and SUM functions.
|
|
MIN function
|
Excel function that calculates the minimum amounts for a given category and has a similar syntax to the AVERAGE and SUM functions.
|
|
Mixed reference
|
Cell reference that contains both relative and absolute references, for example.
|
|
NOW() function
|
Date function that automatically displays the current date in a workbook whenever you reopen it.
|
|
Optional argument
|
An argument that is not necessary for the function to calculate a value (if an optional argument is not included, Excel assumes a default value for it.)
|
|
Relative reference
|
In a formula, the address of a cell range based on the relative position of the cell that contains the formula and the cell the formula refers to. If you copy the formula, the relative reference is adjusted to reflect the new location of the cell containing the formula.
|
|
Source cell
|
Cell that contains the formula that you copy.
|
|
Source range
|
Cell range the contains the formula you copy.
|
|
SUM function
|
Math function that calculates the sum of a set of numbers.
|
|
Syntax
|
Set of rules that specify how to enter certain commands so that VBA will interpret them correctly.
|
|
TODAY() function
|
Date function that automatically changes the date in a workbook whenever you reopen it.
|
|
WEEKDAY function
|
Date function that returns a numeric value by calculating weekdays based on dates entered in the worksheet.
|
|
Comparison operator
|
Symbol that indicates the relationship between two values.
|
|
IF function
|
Logical function that test whether a particular condition is true. If the condition is true, one operation is performed by the function; otherwise a different operation is performed.
|
|
Logical function
|
Category of Excel functions that test, or evaluate, whether a condition, usually entered as an expression, is true or false.
|
|
PMT function
|
Statistical function that determines the monthly payment required to pay of a loan.
|