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