# Like this study set? Create a free account to save it.

### function

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

### statistical functions

Functions used to describe large quantities of data; average, median, minimun, max

### arguments

the values that an Excel function uses to perform calculations or operations, the values in parentheses

### AVERAGE function

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

### MEDIAN function

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

### comparison operator

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

### conditional format

a format that changes the appearance of a cell - for example, by adding cell shading or font color - based on a condition; if the condition is true, the cell is formatted based on that condition, and if the condition is false, the cell is not formatted

### COUNTIF function

a statistical function that counts the number of cells within a range that meet the given condition and that has two arguments = the range of cells to check and the criteria

### data bar

a cell format consisting of a shaded bar that provides a visual cue to the reader about hte value of a cell relative to the other cells; the length of the bar represents the value in the cell

### detail sheets

the worksheets that contain the details of the information summarized on a summary sheet

### Excel table

a series of rows and columns that contains related dsta that is managed independently from the data in other rows and columns in the worksheet

### Filter

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

### Find and replace

a command that 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

### Freeze panes

a command that enables you to select one or more rows or columns and freeze (lock) them into place; the locked rows and columns become separate panes

### IF function

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

### Logical functions

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

### NOW function

an excel funtion that retrieves the date and time from your computer's calendar and clock and inserts the information into the selected cell

### pane

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

### paste

the action of placing text or objects that have been copied or moved from one location to another location

### paste options gallery

a gallery of buttons that provides a Live Preview of all the Paste options available in the current context

### print titles

an Excel command that enables you to specify rows and columns to repeat on each printed page

### scale to fit

Excel commands that enable you to stretch or shrink the width, height, or both, of printed output to fit a maximum number of pages