Course Ma

Excel $2$ End

Excel $2GCc1+$

m$/$Pegasus$/$Modules$/$AssessmentTool$/$Presentation$/$frmStudentP$...$

Gmail

YouTube

HBO Max

Welcome to Apache...

Save for Later

Finish: Subrnit for Gradin

Watch each term in the second column with its correct definition in the first column. Write the letter of the term on the blank line in front of the correct definition.

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

Excel functions, such as MVERAGE, that are useful to analyze a group of measurements.

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

An Excel function that adds a group of walues and then divides the result by the number of values in the group.

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

An Excel function that determines the smallest value in a range

An Excel function that determines the largest value in a range

Function

IF function Criteria COUNTIF function Logical functions MAX function Conditional format MIN function Freeze Panes MEDIAN function SUM function AVERAGE function Comparison operator Logical test Statistical functions

A command that enables you to select one or more rows or columns and lock them in place.

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

Conditions that you specify in a logical 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

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

A function that uces a lasical tect to rherk withether a

Search