Excel Chapter 2: End of Chapter Quiz
Any value or expression that can be evaluated as being true or false. Function Statistical functions SUM function AVERAGE function MEDIAN function MIN function MAX function Formula AutoComplete Criteria Logical test Logical functions COUNTIF functions IF Function comparison operator conditional format
Logical test
An Excel function that adds a group of values and then divides the result by the number of values in the group. Function Statistical functions SUM function AVERAGE function MEDIAN function MIN function MAX function Formula AutoComplete Criteria Logical test Logical functions COUNTIF functions IF Function comparison operator conditional format
AVERAGE function
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 cells to check and the criteria. Function Statistical functions SUM function AVERAGE function MEDIAN function MIN function MAX function Formula AutoComplete Criteria Logical test Logical functions COUNTIF functions IF Function comparison operator conditional format
COUNTIF 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. Function Statistical functions SUM function AVERAGE function MEDIAN function MIN function MAX function Formula AutoComplete Criteria Logical test Logical functions COUNTIF functions IF Function Comparison Operator Conditional format
Comparison operator
A format that changes the appearance of a cell based on a condition Function Statistical functions SUM function AVERAGE function MEDIAN function MIN function MAX function Formula AutoComplete Criteria Logical test Logical functions COUNTIF functions IF Function Comparison Operator Conditional format
Conditional format
Conditions that you specify in a logical function. Function Statistical functions SUM function AVERAGE function MEDIAN function MIN function MAX function Formula AutoComplete Criteria Logical test Logical functions COUNTIF functions IF Function comparison operator conditional format
Criteria
An Excel feature which, after typing an =(equal sign) and the beginning letter or letters of function name displays a list of function names that match the typed letter(s). Function Statistical functions SUM function AVERAGE function MEDIAN function MIN function MAX function Formula AutoComplete Criteria Logical test Logical functions COUNTIF functions IF Function conparison operator conditional format
Formula Autocomplete
A predefined formula that performs calculations by using specific values in a particular order or structure. Function Statistical functions SUM function AVERAGE function MEDIAN function MIN function MAX function Formula AutoComplete Criteria Logical test Logical functions COUNTIF functions IF Function comparison operator conditional format
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. Function Statistical functions SUM function AVERAGE function MEDIAN function MIN function MAX function Formula AutoComplete Criteria Logical test Logical functions COUNTIF functions IF Function Comparison Operator Conditional format
IF function
A group of function that test for specific condictions, and which typically use conditional tests to determine whether specified condition are true or false. Function Statistical functions SUM function AVERAGE function MEDIAN function MIN function MAX function Formula AutoComplete Criteria Logical test Logical functions COUNTIF functions IF Function comparison operator conditional format
Logical functions
An Excel function that determines the largest value in a range. Function Statistical functions SUM function AVERAGE function MEDIAN function MIN function MAX function Formula AutoComplete Criteria Logical test Logical functions COUNTIF functions IF Function comparison operator conditional format
MAX function
An Excel function that finds the middle value that has as many values above it in the group as below it. Function Statistical functions SUM function AVERAGE function MEDIAN function MIN function MAX function Formula AutoComplete Criteria Logical test Logical functions COUNTIF functions IF Function comparison operator conditional format
MEDIAN function
An Excel function that determines the smallest value in a range. Function Statistical functions SUM function AVERAGE function MEDIAN function MIN function MAX function Formula AutoComplete Criteria Logical test Logical functions COUNTIF functions IF Function
MIN function
The function that retrieves and then displays the date and time from your computer is: CALENDAR function NOW function DATE function
NOW function
A predefined formula that adds all the numbers in a selected range. Function Statistical functions SUM function AVERAGE function MEDIAN function MIN function MAX function Formula AutoComplete Criteria Logical test Logical functions COUNTIF functions IF Function comparison operator conditional format
SUM function
Excel functions, such as AVERAGE that are useful to analyze a group of measurements Function Statistical functions SUM function AVERAGE function MEDIAN function MIN function MAX function Formula AutoComplete Criteria Logical test Logical functions COUNTIF functions IF Function comparison operator conditional format
Statistical functions
The values that an Excel function uses to perform calculations or operations are the: data bars comparison operators arguments
arguments
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: scaling filtering sorting
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: split flash fill find and replace
flash fill
The process of arranging data in a specific order based on the value in each field is called: scaling sorting filtering
sorting
