Search
Create
Log in
Sign up
Log in
Sign up
CompSci exam 1 (chap 2)
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (17)
Syntax
a set of rules that governs the structure and components for properly entering a function
TODAY function
displays the current date
Absolute cell reference
Indicates a cell's specific location; the cell reference does not change when you copy the formula
Argument
an input, such as a cell reference or value, needed to complete a function
MAX function
identifies the highest value in a range
COUNT function
tallies the number of cells in a range that contain values
VLOOKUP function
looks up a value in a vertical lookup table and returns a related result from the lookup table
Lookup table
a range that contains data for the basis of the lookup and data to be retrieved
AVERAGE function
calculates the arithmetic mean, or average, of values in a range
MEDIAN function
identifies the midpoint value in a set of values
NOW function
displays current date and time
IF function
evaluates a condition and returns one value if the condition is true and a different value if the condition is false
SUM function
calculates the total of values contained in one or more cells
PMT function
calculates the periodic payment for a loan with a fixed interest rate and fixed term
Relative cell reference
indicates a cell's location from the cell containing the formula; the cell reference changes when the formula is copied
Mixed cell reference
contains both an absolute and a relative cell reference in a formula; the absolute part does not change but the relative part does when you copy the formula
Logical test
an expression that evaluates to true or false
;