The worths that an Excel duty uses to perform calculations or operations.

You are watching: A predefined formula that performs calculations by using specific values in a particular order

AVERAGE FunctionAn Excel role that to add a team of values, and then divides the result by the number of values in the group.
Comparison OperatorSymbols that evaluate each worth to determine if that is the same (=), higher than (>), less than (<), or in in between a range of worths as specified by the criteria.
Conditional FormatA style that transforms the figure of a cell- based upon a condition; if true, the cabinet is formatted based upon that condition. And also if false, the cabinet is no formatted.
COUNTIF FunctionA statistical function that counts the number of cells within a selection that accomplish the given condition and also that has two arguments- the range of cell to check and also the criteria.
CriteriaConditions that you point out in a reasonable function.
Data BarA cell layout consisting that a shaded bar that provides a intuitive cue come the reader about the worth of a cell loved one to other cells; the size of the bar represents the worth in the cell- a much longer bar to represent a greater value and a shorter bar to represent a lower value.
Detail SheetsThe worksheets the contain the details that the info summarized top top a summary sheet.
Drag and also DropThe activity of moving a an option by dragging it come 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 procedure of displaying only a section of the data based upon matching a particular value to show only the data the meets the criteria that you specify.
Find and also ReplaceA command that searches the cells in a worksheet- or in a selected range- because that matches and then replace instead replace each match with a replacement worth of your choice.
Freeze PanesA command that allows you to select 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 the Excel has currently built for you- that performs calculation by using details values in a specific order in structure.
IF FunctionA function that supplies a logical check to examine whether a condition is met, and also then return one worth if true, and another worth if false.
Logical FunctionsA team of functions that check for certain conditions and also that frequently use conditional test 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 identify the largest value in a selected variety of values.
MEDIAN FunctionAn Excel role that finds the center value that has actually as many values over it in the team as are below it; it different from mean in the the result is not affected as lot by a single value that is greatly different from the others.
MIN FunctionAn Excel role that determines the smallest value in a selected range of values.
NavigateThe procedure of experimenting within the arranging structure of Windows.
NOW FunctionAn Excel function that retrieves the date and also time from your computer's calendar and also clock and inserts the info into the selected cell.
PaneA section of a worksheet window bounded by and separated from other portions by vertical and also horizontal bars.
PasteThe action of placing message or objects that have been replicated or relocated from one location to an additional location.
Paste AreaThe target destination for data that has actually been reduced or duplicated using the Office Clipboard.
Paste alternatives GalleryA collection of buttons the provies a Live Preview of all the paste options easily accessible in the existing context.
Print TitlesAn Excel command that allows you come specify rows and columns to repeat ~ above each published page.
Scale come FitExcel command that allow you to stretch or shrink the width, height, or both, of published output come fit a maximum number of pages.
Sheet TabThe labels follow me the lower border the the Excel window that determine each worksheet.
SortThe procedure of arranging data in a particular order based on the worth in every field.
Statistical FunctionExcel function, consisting of the AVERAGE, MEDIAN, MIN, and also MAX functions, i beg your pardon are helpful to analyze a group of measurements.
SUM FunctionA predefined formula that adds all the number in a selected selection of cells.
Summary SheetA worksheet whereby totals from other worksheets space displayed and also summarized.
VolatileA term supplied to explain an Excel function that is subject to readjust each time the workbook is reopened; for instance the NOW function updates chin to the present date and time each time the workbook is opened.
COUNTA statistical function that counts the variety of cells in a variety that contain numbers.
Flash FillRecognizes a sample in your data, and also then immediately fills in values when you go into examples of the output that girlfriend want. Usage it to break-up data from two or an ext cells or to combine data from 2 cells.

See more: What Color Are Flamingo Egg Yolks Are Not Bright Pink, Flamingo Egg Yolks Are Not Bright Pink

Formula AutoCompleteAn Excel attribute that, after inputting an = (equal sign) and the beginning letter or letters of a role name, screens a perform of role names that complement the typed letter(s), and also from i beg your pardon you have the right to insert the role by pointing to its name and also pressing the Tab key or double-clicking.