Search
Create
ICT Chapter 2: Formulas and Functions
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (26)
formula
performs mathematical operations that produce a calculated result
pointing
uses the mouse or arrow keys to select the cell directly when creating a formula
fill handle
is a small black square in the bottom-right corner of a selected cell
relative cell reference
a typical cell reference that changes when copied
absolute cell reference
indicated by dollar signs before the column letter and row number, stays the same regardless of where a formula is copied
mixed cell reference
contains an absolute reference with a relative reference
function
is a preconstructed formula that makes difficult computations less complicated
sum function
represented by sigma, adds up or sums the numeric entries within a range of cells
syntax
refers to the rules for constructing the function
arguments
are values as input that perform an indicated calculation, and the return another value as output
average function
calculates the arithmetic mean, or average, for the values in an argument list
min function
determines the smallest value of all cells in a list of arguments
max function
determines the highest value of all cells in a list of arguments
count function
counts the number of cells in a range that contain the numerical data
counta function
counta the number of cells in a range that are not blank
median function
finds the midpoint value in a set of values
today function
displays the current date in a cell
now function
uses the computer's clock to display the current date and time side by side in a cell
if function
returns one value when a condition is met and returns another value when the condition is not met
vlookup function
looks up an answer from a vertical table of possible answers
lookup value
is the value to look up in a reference table
lookup table
is a range of cells containing the reference table
column index number
is the column number in the lookup table that contains return values
breakpoint
is the lowest numeric value for a category or series in a lookup table to produce a corresponding result for a lookup function
pmt function
calculates the payment in aloan
fv function
returns the future value of an investment
;