excel ch.2

pane

a portion of a worksheet window bounded by and separated from other portions by vertical or horizontal bars

MEDIAN function

a statistical function that finds the middle value that has as many values above it in the group as below it describes a group of data

AVERAGE function

adds a group of values and then divides the result by the number of values in the group

logical test

any value or expression that you can evaluate as being true or false

sort

arrange all the data in a specific order in ascending or descending order

drag and drop

cell contents can be moved from one location to another

conditional format

changes the appearance of a cell based on a condition

freeze panes

command enables you to select one or more rows or columns and then freeze (lock) them into place

print titles and scale to fit

commands to create pages that are attractive and easy to read

comparison operators

compare values

MAX function

determines the largest value in a selected range of values

MIN function

determines the smallest value in a selected range of values

filter

display only a portion of the data based on matching a specific value, to show only the data that meets the criteria that you specify

find and replace

feature searches the cells in a worksheet or in a selected range for matches and then replaces each match with a replacement value of your choice

SUM function

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

function

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

data bar

provides a visual cue to the reader about the value of a cell relative to other cells

COUNTIF function

statistical function that counts the number of cells within a range that meet the given condition, the criteria that you provide

logical functions

use conditional tests to determine wether specified conditions called criteria are true or false

IF function

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

defining the arguments

when indicating which cells you want to use in the function's calculation

statistical function

Average, Median, Max, and Min functions are useful to analyze a group of measurements