Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/23

Click to flip

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.