The worths that an Excel feature provides to perform calculations or operations.

You are watching: Excel functions such as average that are useful to analyze a group of measurements

AVERAGE FunctionAn Excel attribute that adds a team of worths, and then divides the outcome by the number of values in the group.
Compariboy OperatorSymbols that evaluate each worth to identify if it is the exact same (=), better than (>), much less than (<), or in between a variety of values as specified by the criteria.
Conditional FormatA format that transforms the appearance of a cell- based upon a condition; if true, the cell is formatted based upon that problem. and also if false, the cell is not formatted.
COUNTIF FunctionA statistical attribute that counts the number of cells within a variety that satisfy the provided condition and also that has two arguments- the selection of cells to check and the criteria.
CriteriaConditions that you specify in a logical function.
Data BarA cell format consisting of a shaded bar that provides a visual cue to the reader about the value of a cell family member to various other cells; the length of the bar represents the worth in the cell- a longer bar represents a higher worth and also a much shorter bar represents a reduced value.
Detail SheetsThe worksheets that contain the details of the information summarized on an introduction sheet.
Drag and also DropThe action of relocating a selection by dragging it to a new area.
Excel TableA series of rows and columns that contains related data that is regulated separately from the data in other rows and also columns in the worksheet.
FilterThe process of displaying only a section of the data based on equivalent a certain worth to present only the data that meets the criteria that you specify.
Find and also ReplaceA command that searches the cells in a worksheet- or in a selected range- for matches and then relocations each match via a replacement worth of your choice.
Freeze PanesA command also that enables you to pick one or more rows or columns and freeze (lock) them into place; the locked rows and also columns come to be sepaprice panes.
FunctionA precharacterized formula that Excel has actually currently built for you- that performs calculation by making use of specific values in a specific order in structure.
IF FunctionA attribute that offers a logical test to check whether a condition is met, and then returns one value if true, and also one more value if false.
Logical FunctionsA group of attributes that test for particular conditions and also that typically usage conditional tests to identify whether mentioned problems are true or false.
Logical TestAny value or expression that deserve to be evaluated as being true or false.
MAX functionAn Excel function that determines the biggest worth in a schosen selection of worths.
MEDIAN FunctionAn Excel feature that finds the middle value that has actually as many type of worths over it in the team as are listed below it; it differs from AVERAGE in that the outcome is not influenced as a lot by a solitary value that is substantially various from the others.
MIN FunctionAn Excel feature that determines the smallest value in a schosen range of values.
NavigateThe procedure of trying out within the arranging structure of Windows.
NOW FunctionAn Excel function that retrieves the day and also time from your computer's calendar and also clock and also inserts the indevelopment into the selected cell.
PaneA percent of a worksheet home window bounded by and separated from other portions by vertical and also horizontal bars.
PasteThe activity of placing message or objects that have been copied or moved from one location to another place.
Paste AreaThe tarobtain location for information that has been cut or copied making use of the Office Clipboard.
Paste Options GalleryA gallery of butloads that provies a Live Ptestimonial of all the Paste choices available in the present conmessage.
Publish TitlesAn Excel command that allows you to specify rows and also columns to repeat on each printed web page.
Scale to FitExcel command that allow you to stretch or shrink the width, elevation, or both, of published output to fit a maximum variety of peras.
Sheet TabThe labels alengthy the reduced border of the Excel window that recognize each worksheet.
SortThe procedure of arranging data in a details order based upon the value in each area.
Statistical FunctionExcel attribute, including the AVERAGE, MEDIAN, MIN, and MAX attributes, which are helpful to analyze a team of dimensions.
SUM FunctionA preidentified formula that adds all the numbers in a schosen variety of cells.
Summary SheetA worksheet wright here totals from various other worksheets are presented and also summarized.
VolatileA term offered to explain an Excel attribute that is topic to adjust each time the workbook is reopened; for example the NOW attribute updays itself to the current date and also time each time the workbook is opened up.
COUNTA statistical feature that counts the variety of cells in a range that contain numbers.
Flash FillRecognizes a pattern in your data, and then automatically fills in worths when you enter examples of the output that you desire. Use it to separation data from 2 or more cells or to incorporate data from two cells.

See more: Dance To The Beat Of A Different Drum, March To The Beat Of A Different Drummer

Formula AutoCompleteAn Excel function that, after inputting an = (equal sign) and also the beginning letter or letters of a duty name, displays a list of attribute names that match the typed letter(s), and also from which you have the right to insert the function by pointing to its name and also pushing the Tab vital or double-clicking.