Absolute cell Reference
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 FormatThe 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 CellThe cell, surrounded by a black color border, ready to receive data or by influenced by the next Excel command.
Arithmetic OperatorsThe signs +,-,*,/,%, and also ^ offered to signify addition, subtraction, multiplication, division, percentage, and exponentiation in one Excel formula.
AutoCompleteA 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 FillAn Excel attribute that generates and also extends worths into surrounding cells based upon the values of selected cells.
AutoFitAn Excel feature that adjusts the broad of a pillar to fit the cell content of the widest cell in the column.
AutoSumAnother surname for the sum function.
Category AxisThe area follow me the bottom of a chart the identifies the category of data; likewise referred to together the x-axis.
Category LabelsThe brand that display along the bottom the a chart to identify the categories of data; Excel uses the heat titles as the category names.
CellThe intersection that a column and also a row.
Cell AddressAnother name for a cell reference.
Cell ContentAnything typed into a cell.
Cell ReferenceThe to know of a particular bell through its intersecting obelisk letter and row number.
Cell StyleA defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.
ChartThe graphic representation of data in a worksheet; data presented as a graph is usually simpler to recognize than a table that numbers.
Chart LayoutThe 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 GalleryA group of predesigned graph layouts that you can apply to one Excel chart.
Chart StylesThe 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 GalleryA team of predesigned chart layouts that girlfriend can use to an Excel chart.
Chart TypesVarious chart formats used in a way that is meaninful to the reader; typical examples are obelisk charts, pie charts, and also line charts;
ColumnA vertical team of cells in a worksheet.
Column ChartA 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 HeadingThe 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 StyleThe 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 ValueNumbers, text, dates, or time of day the you kind into a cell.
Context SensitiveA command linked with activites in i m sorry you space engaged; often activated by right-clicking a screen item.
DataText or number in a cell.
Data MarkerA 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 PointA worth that originates in a worksheet cell and also that is stood for in a graph by a data marker.
Data SeriesRelated data points represented by data markers; every data series has a unique shade or pattern represented in a graph legend.
Displayed ValueThe data that displays in a cell.
Expand Formula Bar ButtonAn 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 ButtonAn Excel home window element v which you have the right to increase the width of the horizontal scroll bar.
Fill HandleThe tiny black square in the reduced right edge of a selected cell.
FormatChanging the figure of cells and also worksheet facets to make a wordsheet attractive and easy come read.
FormulaAn equation that performs mathematical calculations on values in a worksheet.
Formula BarAn 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.
FunctionA 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 FormatThe 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.
LabelColumn and row headings that define the worths and aid the reader understand the chart.
Left AlignmentThe 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.
LegendA chart element that identifies the patterns or colour that room assigned come the categories in the chart.
Lettered obelisk HeadingsThe area follow me the height edge the a worksheet the identifies each shaft with a distinctive letter or combination of letters.
Merge & CenterA 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 BoxAn facet of the Excel window that screens the surname of the selected cell, table, chart, or object.
Normal ViewA 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 FormatA specific way in i m sorry Excel display screens numbers in a cell.
Number ValuesConstant values consisting of only numbers.
Numbered heat HeadingsThe area follow me the left edge of a worksheet that identifies every row v a distinctive number.
OperatorsThe signs with i m sorry you can specify the type of calculation you desire to carry out in an Excel formula.
Page Layout ViewA 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 ElementA 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.
PixelsThe abbreviated name for photo element.
Point and also Click MethodThe 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.
RangeTwo 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 FinderAn 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 ReferenceIn 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.
RoundingA 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.
RowA horizontal group of cells in a worksheet.
Row HeadingThe numbers follow me the left side of one Excel worksheet that designate the heat numbers.
ScalingThe 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 boxA crate in the upper left corner of the worksheet grid that, when clicked, selects all the cell in a worksheet.
SeriesA team of things that come one after another in succession; because that example, January, February, March, and so on.
Sheet Tab Scrolling ButtonsButtons 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 TabsThe labels follow me the lower border the the Excel window that determine each wordsheet.
SparklinesA tiny chart in the elevator of a cabinet that provides a intuitive trend review alongside your data; provides a pattern much more obvious.
Status BarThe 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 FunctionA predefined formula the adds all the numbers in the selected range of cells.
SpreadsheetAnother name for a worksheet.
Text ValuesConstant worths consisting of only text, and which usually provides information about number values; additionally referred to together labels.
Underlying FormulaThe formula gone into in a cell and visible just on the Formula Bar.
Underlying ValueThe data that screens in the Formula Bar.
ValueAnother name for a consistent value.
Value AxisA 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.
WorkbookAn Excel file that consists of one or an ext worksheets.
Workbook- Level ButtonsButtons in ~ the much right of the Ribbon tabs that minimize or restore a shown workbook.
WordsheetThe 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-AxisAnother name for teh horizontal axis.
Y-AxisAnother name for the upright axis.
AutoCalculateA 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 buttonA switch that enables you to add, remove, or adjust chart aspects such as the title, legend, gridlines, and data labels.
Chart filters buttonA button that enables you to adjust which data displays in the chart.
Chart layouts buttonA button that enables you to set a style and also color plan for your chart.
Excel pointerAn Excel home window element with which you can display the ar of the pointer.
Quick analysis toolA 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 ChartsAn 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/ColumnA 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.
ThemeA 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 areaA component of the Excel window that displays the columns and rows that intersect to type the worksheet’s cells.
*