excel ch. 2 end of chapter quiz

a statistical function that counts the number of cells within a range that meet the given condition and which has two arguments - the range of the cells to check and the criteria

COUNTIF function

a function that uses a logical test to check whether a condition is met, and then returns one value if true and another value if false

IF function

the function that retrieves and then displays the date and time from your computer is the

NOW function

the values that an excel function uses to perform calculations or operations are the

arguments

an excel function that adds a group of values and then divides the result by the number of values in the group

average function

symbols that evaluate each value to determine if it is the same, greater than, less than, or in between a range of values as specified by the criteria

comparison operator

a format that changes the appearance of a cell based on a condition

conditional formatting

conditions that you specify in a logical function

criteria

the process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify is called

filtering

the excel command that recognizes a pattern in your data and then automatically fills in the values when you enter examples of the desired output is

flashfill

an excel feature which, after typing = and the beginning letter or letters of a function name, displays a list of function names that match the typed letter(s)

formula autocomplete

a predefined formula that performs calculations by using specific values in a particular order or structure

function

a group of functions that test for specific conditions, and which typically use conditional tests to determine whether specified conditions are true or false

logical functions

any value or expression that can be evaluated as being true or false

logical test

an excel function that determines the largest value in a range

max function

an excel function that finds the middle value that has as many values above it in the group as are below it

median function

an excel function that determines the smallest value in a range

min function

the process of arranging data in a specific order based on the value in each field is called

sorting

excel functions, such as AVERAGE, that are useful to analyze a group of measurements

statistical functions

a predefined formula that adds all the numbers in a selected range

sum function