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