AB | |

A cell referral that fefers to cells by your fixed place in a worksheet; this stays the same once the formula is copied. You are watching: The labels along the lower edge of the workbook window that identify each worksheet. | |

Accounting Number Format | The Excel number layout that uses a thousands comma separator where apporpriate, inserts a solved U.S. Dollar sign aligned at he left edge of the cell, applies two decimal places, and leaves a tiny amount of room at the best edge of the cabinet to accommodate a parenthesis for an adverse numbers. |

Active Cell | The cell, surrounded by a black color border, ready to receive data or by influenced by the next Excel command. |

Arithmetic Operators | The signs +,-,*,/,%, and also ^ offered to signify addition, subtraction, multiplication, division, percentage, and exponentiation in one Excel formula. |

AutoComplete | A function that speeds your typing and also lessens the likelihood that errors; if the first couple of characters you kind in a cell match an existing entry in the column, Excel fills in the remaining characters for you. |

Auto Fill | An Excel attribute that generates and also extends worths into surrounding cells based upon the values of selected cells. |

AutoFit | An Excel feature that adjusts the broad of a pillar to fit the cell content of the widest cell in the column. |

AutoSum | Another surname for the sum function. |

Category Axis | The area follow me the bottom of a chart the identifies the category of data; likewise referred to together the x-axis. |

Category Labels | The brand that display along the bottom the a chart to identify the categories of data; Excel uses the heat titles as the category names. |

Cell | The intersection that a column and also a row. |

Cell Address | Another name for a cell reference. |

Cell Content | Anything typed into a cell. |

Cell Reference | The to know of a particular bell through its intersecting obelisk letter and row number. |

Cell Style | A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading. |

Chart | The graphic representation of data in a worksheet; data presented as a graph is usually simpler to recognize than a table that numbers. |

Chart Layout | The mix of chart facets that deserve to be displayed in a chart such as a title, legend, lables because that the columns, and also the table that charted cells. |

Chart Layouts Gallery | A group of predesigned graph layouts that you can apply to one Excel chart. |

Chart Styles | The overall visual watch of a graph in terms of its graphic effects, colors, and backgrounds; for example, you can have level or beveled columns, colors, that solid or transparent, and also backgrounds that are dark or light. |

Chart styles Gallery | A team of predesigned chart layouts that girlfriend can use to an Excel chart. |

Chart Types | Various chart formats used in a way that is meaninful to the reader; typical examples are obelisk charts, pie charts, and also line charts; |

Column | A vertical team of cells in a worksheet. |

Column Chart | A graph in i m sorry the data is arranged in columns and also which is valuable for mirroring data changes over a duration of time or for illustrating comparisons amongst items. |

Column Heading | The letter that display screens at the peak of a vertical team of cells in a worksheet; beginning with the an initial letter of the alphabet, a distinctive letter or combination of letters identifies each column. |

Comma Style | The Excel number layout that inserts thousand comma separators whereby appropriate and also applies 2 decimal places; this additionally leaves room at the appropriate to accommodate a parenthesis when an adverse numbers are present. |

Constant Value | Numbers, text, dates, or time of day the you kind into a cell. |

Context Sensitive | A command linked with activites in i m sorry you space engaged; often activated by right-clicking a screen item. |

Data | Text or number in a cell. |

Data Marker | A column, bar, area, dot, pie slice, or other symbol in a chart the represents a single data point; connected data points form a data series. |

Data Point | A worth that originates in a worksheet cell and also that is stood for in a graph by a data marker. |

Data Series | Related data points represented by data markers; every data series has a unique shade or pattern represented in a graph legend. |

Displayed Value | The data that displays in a cell. |

Expand Formula Bar Button | An Excel window element through which you have the right to increase the elevation of the Formula Bar come displaylengthy cell content. |

Expand Horizontal scroll Bar Button | An Excel home window element v which you have the right to increase the width of the horizontal scroll bar. |

Fill Handle | The tiny black square in the reduced right edge of a selected cell. |

Format | Changing the figure of cells and also worksheet facets to make a wordsheet attractive and easy come read. |

Formula | An equation that performs mathematical calculations on values in a worksheet. |

Formula Bar | An facet in the Excel window that screens the worth or formula had in the energetic cell; right here you can additionally enter or modify values or formulas. |

Function | A predifined formula- a formula that Excel has already built because that you-that performs calculations through using details values in a specific order or structure. |

General Format | The default style that Excel uses to numbers; this format hs not details characteristics- whatever you form in the cell will display, v the exemption that trailing zeros come the best of a decimal suggest wiht not display. |

Label | Column and row headings that define the worths and aid the reader understand the chart. |

Left Alignment | The cell format in which personalities align in ~ the left edge of the cell; this is the default for text entries and also is an example of formatting info stored in a cell. |

Legend | A chart element that identifies the patterns or colour that room assigned come the categories in the chart. |

Lettered obelisk Headings | The area follow me the height edge the a worksheet the identifies each shaft with a distinctive letter or combination of letters. |

Merge & Center | A command the joins selected cell in an Excel worksheet right into one bigger cell and also centers the contents in the brand-new cell. |

Name Box | An facet of the Excel window that screens the surname of the selected cell, table, chart, or object. |

Normal View | A screen view that maximizes the number of cells visible on her screen and also keeps the shaft letters and row number close come the columns and rows. |

Number Format | A specific way in i m sorry Excel display screens numbers in a cell. |

Number Values | Constant values consisting of only numbers. |

Numbered heat Headings | The area follow me the left edge of a worksheet that identifies every row v a distinctive number. |

Operators | The signs with i m sorry you can specify the type of calculation you desire to carry out in an Excel formula. |

Page Layout View | A display screen view in which you have the right to use the rulers to measure up the width and height of data, set margins because that printing, hide or screen the numbered heat headings and the lettered column headings, and change the page orientation; this check out is advantageous for preparing her worksheet for printing. |

Picture Element | A allude of favor measured in dots per square customs on a screen; 64 pixels equates to 8.43 characters, which is the average variety of digits that will certainly fit in a cell in an Excel worksheet using the default font. |

Pixels | The abbreviated name for photo element. |

Point and also Click Method | The method of contructing a formula by pointing to and also then click cells; this method is convenient as soon as the referenced cells are not adjacent to one another. |

Range | Two or an ext selected cells on a worksheet the are nearby or nonadjacent; because the variety is treated as a solitary unit, you deserve to make the same changes or combination of changes to more than one cabinet at a time. |

Range Finder | An Excel attribute that outlines cells in shade to suggest which cell are used in a formula; helpful for verifying i m sorry cells space referenced in a formula. |

Relative cabinet Reference | In a formula, the deal with of a cell based on the relative position related tasks on tabs throughout the upper portion of the routine window. |

Rounding | A procedure in i beg your pardon you recognize which digit at the right of the number will certainly be the last digit displayed and then rise it through one if the next digit come its right it 5, 6, 7, 8, or 9. |

Row | A horizontal group of cells in a worksheet. |

Row Heading | The numbers follow me the left side of one Excel worksheet that designate the heat numbers. |

Scaling | The group of commands whereby you can reduce the horizontal and also vertical dimension of the printed data by a percent or by the variety of pages that you specify. |

Select every box | A crate in the upper left corner of the worksheet grid that, when clicked, selects all the cell in a worksheet. |

Series | A team of things that come one after another in succession; because that example, January, February, March, and so on. |

Sheet Tab Scrolling Buttons | Buttons to the left of the paper tabs supplied to display screen Excel sheet tabs that space not in view; provided when there are much more sheet tabs 보다 will screen in the space provided. |

Sheet Tabs | The labels follow me the lower border the the Excel window that determine each wordsheet. |

Sparklines | A tiny chart in the elevator of a cabinet that provides a intuitive trend review alongside your data; provides a pattern much more obvious. |

Status Bar | The area along the reduced edge that the Excel window that displays, on the left side, the current cell mode, page number, and worksheet information; top top the best ride, as soon as numerical data is selected, typical calculations such as Sum and also Average display. |

SUM Function | A predefined formula the adds all the numbers in the selected range of cells. |

Spreadsheet | Another name for a worksheet. |

Text Values | Constant worths consisting of only text, and which usually provides information about number values; additionally referred to together labels. |

Underlying Formula | The formula gone into in a cell and visible just on the Formula Bar. |

Underlying Value | The data that screens in the Formula Bar. |

Value | Another name for a consistent value. |

Value Axis | A numerical range on the left next fo a graph that shows the variety of numbers because that the data points likewise referred to as the y- axis. |

Workbook | An Excel file that consists of one or an ext worksheets. |

Workbook- Level Buttons | Buttons in ~ the much right of the Ribbon tabs that minimize or restore a shown workbook. |

Wordsheet | The primary document that you usage in Excel to work with and also store data, and also which is formatted as a sample of uniformly spaced horizontal and vertical lines. |

X-Axis | Another name for teh horizontal axis. |

Y-Axis | Another name for the upright axis. |

AutoCalculate | A attribute that display screens three calculations in the condition bar by default—Average, Count, and also Sum—when you pick a variety of number data. |

Chart facets button | A switch that enables you to add, remove, or adjust chart aspects such as the title, legend, gridlines, and data labels. |

Chart filters button | A button that enables you to adjust which data displays in the chart. |

Chart layouts button | A button that enables you to set a style and also color plan for your chart. |

Excel pointer | An Excel home window element with which you can display the ar of the pointer. |

Quick analysis tool | A device that screens in the lower right corner of a selected range with which you have the right to analyze your data by using Excel tools such together charts, color-coding, and also formulas. |

Recommended Charts | An Excel function that screens a customized collection of charts that, follow to Excel’s calculations, will best fit your data based on the range of data the you select. |

Switch Row/Column | A charting command come swap the data end the axis—data being charted top top the upright axis will move to the horizontal axis and vice versa. |

Theme | A predefined set of colors, fonts, lines, and also fill impacts that coordinate v each other. See more: Cry The Beloved Country Questions And Answers, Cry, The Beloved Country |

Worksheet net area | A component of the Excel window that displays the columns and rows that intersect to type the worksheet’s cells. |