AB | |

The values that one Excel role uses to execute calculations or operations. You are watching: The function that retrieves and then displays | |

AVERAGE Function | An Excel function that to add a team of values, and then divides the result by the variety of values in the group. |

Comparison Operator | Symbols that evaluate each worth to determine if the is the exact same (=), better than (>), less than (<), or in between a variety of worths as specified by the criteria. |

Conditional Format | A layout that transforms the illustration of a cell- based upon a condition; if true, the cabinet is formatted based upon that condition. And also if false, the cabinet is not formatted. |

COUNTIF Function | A statistical role that counts the number of cells in ~ a variety that accomplish the given condition and that has two arguments- the range of cells to check and also the criteria. |

Criteria | Conditions that you point out in a reasonable function. |

Data Bar | A cell style consisting that a shaded bar that gives a intuitive cue come the reader around the worth of a cell relative to other cells; the length of the bar represents the value in the cell- a much longer bar to represent a greater value and a shorter bar to represent a reduced value. |

Detail Sheets | The worksheets the contain the details that the details summarized ~ above a review sheet. |

Drag and also Drop | The activity of moving a selection by dragging it to a new location. |

Excel Table | A series of rows and columns that consists of related data the is controlled independently native the data in various other rows and columns in the worksheet. |

Filter | The process of displaying just a section of the data based on matching a specific value to show only the data the meets the criteria the you specify. |

Find and also Replace | A command that searches the cells in a worksheet- or in a selected range- for matches and also then replace instead instead each match with a replacement worth of your choice. |

Freeze Panes | A command that allows you to choose one or more rows or columns and freeze (lock) them into place; the locked rows and also columns come to be separate panes. |

Function | A predefined formula that Excel has already built for you- the performs calculation by using specific values in a specific order in structure. |

IF Function | A duty that offers a logical test to inspect whether a problem is met, and then returns one worth if true, and another value if false. |

Logical Functions | A group of attributes that test for details conditions and that generally use conditional tests to determine whether specified conditions are true or false. |

Logical Test | Any worth or expression that deserve to be evaluated together being true or false. |

MAX function | An Excel function that determines the largest value in a selected selection of values. |

MEDIAN Function | An Excel function that finds the center value that has actually as countless values over it in the team as are below it; it differs from average in the the result is not influenced as lot by a single value the is greatly various from the others. |

MIN Function | An Excel function that determines the smallest worth in a selected range of values. |

Navigate | The process of trying out within the organizing structure that Windows. |

NOW Function | An Excel role that retrieves the date and time from her computer's calendar and also clock and also inserts the details into the selected cell. |

Pane | A part of a worksheet home window bounded by and also separated from various other portions through vertical and also horizontal bars. |

Paste | The activity of placing message or objects that have actually been duplicated or moved from one place to another location. |

Paste Area | The target destination for data that has been cut or replicated using the Office Clipboard. |

Paste choices Gallery | A gallery of buttons the provies a Live Preview of all the dough options accessible in the current context. |

Print Titles | An Excel command that permits you to specify rows and also columns come repeat on each printed page. |

Scale to Fit | Excel command that allow you to stretch or shrink the width, height, or both, of published output to fit a maximum number of pages. |

Sheet Tab | The labels follow me the lower border of the Excel window that identify each worksheet. |

Sort | The process of arranging data in a details order based on the value in each field. |

Statistical Function | Excel function, consisting of the AVERAGE, MEDIAN, MIN, and also MAX functions, i beg your pardon are helpful to analysis a team of measurements. |

SUM Function | A predefined formula the adds every the number in a selected variety of cells. |

Summary Sheet | A worksheet whereby totals from other worksheets room displayed and also summarized. |

Volatile | A term used to explain an Excel duty that is subject to change each time the workbook is reopened; for example the NOW role updates chin to the existing date and time every time the workbook is opened. |

COUNT | A statistical duty that counts the number of cells in a variety that save numbers. |

Flash Fill | Recognizes a pattern in her data, and also then immediately fills in values when you enter examples the the calculation that friend want. Use it to split data from two or more cells or to combine data from 2 cells. See more: How Many Gallons Of Water Per Square Foot, Best Practices: Watering Lawn |

Formula AutoComplete | An Excel feature that, after typing an = (equal sign) and also the start letter or letters of a duty name, display screens a perform of role names that enhance the typed letter(s), and also from i beg your pardon you have the right to insert the duty by pointing come its name and also pressing the Tab crucial or double-clicking. |