The worths that an Excel role uses to execute calculations or operations.

You are watching: A predefined formula is called a:

AVERAGE FunctionAn Excel role that adds a team of values, and then divides the result by the variety of values in the group.
Comparison OperatorSymbols that evaluate each value to recognize if that is the same (=), greater than (>), less than (<), or in between a range of values as specified by the criteria.
Conditional FormatA format that changes the figure of a cell- based on a condition; if true, the cabinet is formatted based upon that condition. And also if false, the cell is not formatted.
COUNTIF FunctionA statistical duty that counts the variety of cells within a selection that meet the offered condition and also that has actually two arguments- the selection of cell to check and also the criteria.
CriteriaConditions that you point out in a reasonable function.
Data BarA cell style consisting the a shaded bar that provides a visual cue come the reader around the value of a cell family member to various other cells; the length of the bar to represent the value in the cell- a much longer bar represents a higher value and a much shorter bar to represent a reduced value.
Detail SheetsThe worksheets the contain the details of the info summarized on a summary sheet.
Drag and also DropThe activity of relocating a choice by dragging it to a new location.
Excel TableA collection of rows and columns that consists of related data that is regulated independently native the data in other rows and also columns in the worksheet.
FilterThe process of displaying only a portion of the data based upon matching a particular value to display only the data that meets the criteria the you specify.
Find and ReplaceA command the searches the cells in a worksheet- or in a selected range- because that matches and then replaces each complement with a replacement worth of her choice.
Freeze PanesA command that enables you to choose one or more rows or columns and also freeze (lock) them right into place; the locked rows and columns end up being separate panes.
FunctionA predefined formula that Excel has already built for you- that performs calculation by using details values in a details order in structure.
IF FunctionA duty that uses a logical test to examine whether a condition is met, and also then return one worth if true, and also another value if false.
Logical FunctionsA team of features that test for certain conditions and also that generally use conditional test to recognize whether specified problems are true or false.
Logical TestAny value or expression that deserve to be evaluated as being true or false.
MAX functionAn Excel duty that identify the biggest value in a selected variety of values.
MEDIAN FunctionAn Excel role that find the center value that has actually as countless values over it in the team as are below it; it different from average in that the result is not impacted as lot by a solitary value that is greatly different from the others.
MIN FunctionAn Excel function that determines the smallest value in a selected range of values.
NavigateThe process of experimenting within the arranging structure of Windows.
NOW FunctionAn Excel role that retrieves the date and also time from your computer's calendar and also clock and also inserts the details into the selected cell.
PaneA section of a worksheet home window bounded by and separated from various other portions by vertical and also horizontal bars.
PasteThe action of placing text or objects that have actually been copied or relocated from one place to an additional location.
Paste AreaThe target destination for data that has actually been reduced or duplicated using the Office Clipboard.
Paste choices GalleryA gallery of buttons that provies a Live Preview of every the dough options accessible in the present context.
Print TitlesAn Excel command that permits you come specify rows and also columns to repeat on each printed page.
Scale to FitExcel command that enable you to stretch or shrink the width, height, or both, of published output to fit a maximum variety 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 particular order based on the worth in every field.
Statistical FunctionExcel function, including the AVERAGE, MEDIAN, MIN, and MAX functions, i beg your pardon are useful to analysis a group of measurements.
SUM FunctionA predefined formula the adds every the numbers in a selected selection of cells.
Summary SheetA worksheet whereby totals from various other worksheets space displayed and summarized.
VolatileA term offered to explain an Excel duty that is subject to readjust each time the workbook is reopened; for instance the NOW duty updates chin to the existing date and time every time the workbook is opened.
COUNTA statistical role that counts the variety of cells in a selection that save on computer numbers.
Flash FillRecognizes a pattern in her data, and then immediately fills in values when you enter examples of the output that girlfriend want. Usage it to break-up data from 2 or more cells or to integrate data from two cells.

See more: Fraction Calculator: 1/4 Divided By 7 /1? What Is 1/4 Divided By 7 (Calculate 1/4 ÷ 7

Formula AutoCompleteAn Excel attribute that, after typing an = (equal sign) and the start letter or letters of a role name, screens a list of role names that enhance the typed letter(s), and also from i m sorry you deserve to insert the role by pointing to its name and pressing the Tab vital or double-clicking.