An Excel function that finds the middle value that has as many values above it in the group as are below it. AVERAGE function Comparison operator Conditional format COUNTIF function Criteria Freeze Panes Function IF function Logical functions Logical test MAX function MEDIAN function MIN function Statistical functions SUM function 6. An Excel function that determines the smallest value in a range. AVERAGE function Comparison operator Conditional format COUNTIF function Criteria Freeze Panes Function IF function Logical functions Logical test MAX function MEDIAN function MIN function Statistical functions SUM function 7. An Excel function that determines the largest value in a range. AVERAGE function Comparison operator Conditional format COUNTIF function Criteria Freeze Panes Function IF function Logical functions Logical test MAX function MEDIAN function MIN function Statistical functions SUM function 8. A command that enables you to select one or more rows or columns and lock them in place. AVERAGE function Comparison operator Conditional format COUNTIF function Criteria Freeze Panes Function IF function Logical functions Logical test MAX function MEDIAN function MIN function Statistical functions SUM function 9. A group of functions that test for specific conditions, and which typically use conditional tests to determine