AB | |

The worths that an Excel role uses to execute calculations or operations. You are watching: A predefined formula is called a: | |

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

Comparison Operator | Symbols 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 Format | A 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 Function | A 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. |

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

Data Bar | A 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 Sheets | The worksheets the contain the details of the info summarized on a summary sheet. |

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

Excel Table | A 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. |

Filter | The 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 Replace | A 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 Panes | A 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. |

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

IF Function | A 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 Functions | A 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 Test | Any value or expression that deserve to be evaluated as being true or false. |

MAX function | An Excel duty that identify the biggest value in a selected variety of values. |

MEDIAN Function | An 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 Function | An Excel function that determines the smallest value in a selected range of values. |

Navigate | The process of experimenting within the arranging structure of Windows. |

NOW Function | An 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. |

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

Paste | The action of placing text or objects that have actually been copied or relocated from one place to an additional location. |

Paste Area | The target destination for data that has actually been reduced or duplicated using the Office Clipboard. |

Paste choices Gallery | A gallery of buttons that provies a Live Preview of every the dough options accessible in the present context. |

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

Scale to Fit | Excel command that enable you to stretch or shrink the width, height, or both, of published output to fit a maximum variety 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 particular order based on the worth in every field. |

Statistical Function | Excel function, including the AVERAGE, MEDIAN, MIN, and MAX functions, i beg your pardon are useful to analysis a group of measurements. |

SUM Function | A predefined formula the adds every the numbers in a selected selection of cells. |

Summary Sheet | A worksheet whereby totals from various other worksheets space displayed and summarized. |

Volatile | A 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. |

COUNT | A statistical role that counts the variety of cells in a selection that save on computer numbers. |

Flash Fill | Recognizes 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 AutoComplete | An 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. |