The values that one Excel role uses to execute calculations or operations.

You are watching: The function that retrieves and then displays

AVERAGE FunctionAn Excel function that to add a team of values, and then divides the result by the variety of values in the group.
Comparison OperatorSymbols 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 FormatA 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 FunctionA 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.
CriteriaConditions that you point out in a reasonable function.
Data BarA 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 SheetsThe worksheets the contain the details that the details summarized ~ above a review sheet.
Drag and also DropThe activity of moving a selection by dragging it to a new location.
Excel TableA 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.
FilterThe 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 ReplaceA 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 PanesA 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.
FunctionA predefined formula that Excel has already built for you- the performs calculation by using specific values in a specific order in structure.
IF FunctionA 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 FunctionsA group of attributes that test for details conditions and that generally use conditional tests to determine whether specified conditions are true or false.
Logical TestAny worth or expression that deserve to be evaluated together being true or false.
MAX functionAn Excel function that determines the largest value in a selected selection of values.
MEDIAN FunctionAn 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 FunctionAn Excel function that determines the smallest worth in a selected range of values.
NavigateThe process of trying out within the organizing structure that Windows.
NOW FunctionAn 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.
PaneA part of a worksheet home window bounded by and also separated from various other portions through vertical and also horizontal bars.
PasteThe activity of placing message or objects that have actually been duplicated or moved from one place to another location.
Paste AreaThe target destination for data that has been cut or replicated using the Office Clipboard.
Paste choices GalleryA gallery of buttons the provies a Live Preview of all the dough options accessible in the current context.
Print TitlesAn Excel command that permits you to specify rows and also columns come repeat on each printed page.
Scale to FitExcel command that allow you to stretch or shrink the width, height, or both, of published output to fit a maximum number of pages.
Sheet TabThe labels follow me the lower border of the Excel window that identify each worksheet.
SortThe process of arranging data in a details order based on the value in each field.
Statistical FunctionExcel function, consisting of the AVERAGE, MEDIAN, MIN, and also MAX functions, i beg your pardon are helpful to analysis a team of measurements.
SUM FunctionA predefined formula the adds every the number in a selected variety of cells.
Summary SheetA worksheet whereby totals from other worksheets room displayed and also summarized.
VolatileA 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.
COUNTA statistical duty that counts the number of cells in a variety that save numbers.
Flash FillRecognizes 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 AutoCompleteAn 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.