Absolute cabinet Reference
A cell recommendation that fefers to cells by their fixed place in a worksheet; this remains the same as soon as the formula is copied.

You are watching: A cell surrounded by a black border and ready to receive data is the

Accounting Number FormatThe Excel number format that uses a thousand comma separator where apporpriate, inserts a fixed U.S. Dollar authorize aligned in ~ he left sheet of the cell, applies two decimal places, and also leaves a small amount of space at the right edge of the cell to accommodate a parenthesis for negative numbers.
Active CellThe cell, surrounded by a black color border, prepared to obtain data or by affected by the following Excel command.
Arithmetic OperatorsThe symbols +,-,*,/,%, and also ^ offered to signify addition, subtraction, multiplication, division, percentage, and also exponentiation in one Excel formula.
AutoCompleteA function that speeds her typing and lessens the likelihood of errors; if the first couple of characters you type in a cell enhance an existing entry in the column, Excel filling in the remaining personalities for you.
Auto FillAn Excel attribute that generates and also extends values into nearby cells based upon the values of selected cells.
AutoFitAn Excel feature that adjusts the width of a shaft to fit the cell content of the widest cabinet in the column.
AutoSumAnother name for the sum function.
Category AxisThe area along the bottom of a chart the identifies the categories of data; additionally referred to together the x-axis.
Category LabelsThe brand that display screen along the bottom the a graph to determine the categories of data; Excel provides the row titles as the category names.
CellThe intersection that a column and a row.
Cell AddressAnother surname for a cell reference.
Cell ContentAnything typed into a cell.
Cell ReferenceThe identification of a specific bell by its intersecting shaft letter and row number.
Cell StyleA defined collection of formatting characteristics, such together font, font size, font color, cell borders, and cell shading.
ChartThe graphic depiction of data in a worksheet; data presented as a graph is usually simpler to know than a table that numbers.
Chart LayoutThe mix of chart elements that deserve to be presented in a chart such together a title, legend, lables for the columns, and the table that charted cells.
Chart Layouts GalleryA group of predesigned chart layouts that you can apply to an Excel chart.
Chart StylesThe overall visual look at of a graph in regards to its graphics effects, colors, and backgrounds; because that example, you can have level or beveled columns, colors, that solid or transparent, and backgrounds that space dark or light.
Chart layouts GalleryA group of predesigned chart styles that girlfriend can use to an Excel chart.
Chart TypesVarious chart formats used in a method that is meaninful come the reader; common examples are tower charts, pie charts, and also line charts;
ColumnA vertical team of cell in a worksheet.
Column ChartA chart in i beg your pardon the data is i ordered it in columns and also which is advantageous for showing data changes over a duration of time or for portraying comparisons amongst items.
Column HeadingThe letter that screens at the peak of a vertical group of cells in a worksheet; start with the an initial letter that the alphabet, a distinct letter or combination of letter identifies each column.
Comma StyleThe Excel number style that inserts thousands comma separators whereby appropriate and applies 2 decimal places; this additionally leaves room at the right to accommodate a parenthesis when negative numbers are present.
Constant ValueNumbers, text, dates, or time of day that you type into a cell.
Context SensitiveA command linked with activites in i m sorry you room engaged; often activated by right-clicking a display item.
DataText or numbers in a cell.
Data MarkerA column, bar, area, dot, pie slice, or various other symbol in a chart that represents a single data point; connected data points kind a data series.
Data PointA worth that originates in a worksheet cell and that is represented in a graph by a data marker.
Data SeriesRelated data points represented by data markers; every data collection has a unique shade or pattern represented in a chart legend.
Displayed ValueThe data that displays in a cell.
Expand Formula Bar ButtonAn Excel window element through which you can increase the height of the Formula Bar come displaylengthy cell content.
Expand Horizontal role Bar ButtonAn Excel home window element with which you have the right to increase the width of the horizontal role bar.
Fill HandleThe tiny black square in the lower right edge of a selected cell.
FormatChanging the illustration of cells and also worksheet aspects to make a wordsheet attractive and easy come read.
FormulaAn equation the performs mathematical calculations on worths in a worksheet.
Formula BarAn aspect in the Excel window that displays the worth or formula consisted of in the active cell; right here you can also enter or modify values or formulas.
FunctionA predifined formula- a formula the Excel has currently built for you-that performs calculations through using certain values in a particular order or structure.
General FormatThe default layout that Excel applies to numbers; this layout hs not particular characteristics- every little thing you form in the cell will certainly display, v the exception that rolling zeros to the right of a decimal point wiht no display.
LabelColumn and also row headings that define the worths and aid the reader understand the chart.
Left AlignmentThe cell format in which characters align at the left sheet of the cell; this is the default for message entries and is an example of formatting details stored in a cell.
LegendA chart aspect that identify the patterns or colors that space assigned come the category in the chart.
Lettered pillar HeadingsThe area along the top edge the a worksheet that identifies each obelisk with a unique letter or combination of letters.
Merge & CenterA command the joins selected cell in one Excel worksheet into one larger cell and centers the materials in the new cell.
Name BoxAn aspect of the Excel home window that displays the name of the selected cell, table, chart, or object.
Normal ViewA screen view the maximizes the number of cells visible on her screen and keeps the column letters and also row number close to the columns and also rows.
Number FormatA specific means in i beg your pardon Excel displays numbers in a cell.
Number ValuesConstant values consisting of only numbers.
Numbered row HeadingsThe area along the left sheet of a worksheet that identifies every row through a distinctive number.
OperatorsThe signs with i beg your pardon you deserve to specify the kind of calculate you want to do in one Excel formula.
Page Layout ViewA display view in i m sorry you deserve to use the rulers to measure up the width and height that data, collection margins because that printing, hide or screen the numbered row headings and the lettered shaft headings, and readjust the page orientation; this view is valuable for preparing your worksheet for printing.
Picture ElementA suggest of prefer measured in dots every square customs on a screen; 64 pixels amounts to 8.43 characters, which is the average number of digits that will fit in a cabinet in an Excel worksheet utilizing the default font.
PixelsThe abbreviated name for photo element.
Point and also Click MethodThe technique of contructing a formula by pointing to and then clicking cells; this an approach is convenient when the referenced cells space not nearby to one another.
RangeTwo or more selected cell on a worksheet the are nearby or nonadjacent; since the selection is treated together a single unit, you can make the same transforms or mix of alters to an ext than one cell at a time.
Range FinderAn Excel feature that outlines cell in shade to suggest which cell are supplied in a formula; advantageous 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 work on tabs throughout the upper part of the regime window.
RoundingA procedure in which you recognize which number at the right of the number will be the critical digit displayed and also then boost it by one if the next digit come its right it 5, 6, 7, 8, or 9.
RowA horizontal team of cells in a worksheet.
Row HeadingThe numbers along the left next of one Excel worksheet the designate the heat numbers.
ScalingThe group of commands by which you can reduce the horizontal and vertical dimension of the printed data through a portion or through the variety of pages the you specify.
Select all boxA crate in the top left corner of the worksheet net that, as soon as clicked, selects all the cell in a worksheet.
SeriesA group of things that come one after one more in succession; for example, January, February, March, and so on.
Sheet Tab Scrolling ButtonsButtons to the left that the sheet tabs provided to screen Excel paper tabs that space not in view; used when over there are more sheet tabs than will display in the space provided.
Sheet TabsThe labels along the lower border that the Excel window that determine each wordsheet.
SparklinesA small chart in the lift of a cabinet that provides a intuitive trend an introduction alongside her data; provides a pattern more obvious.
Status BarThe area along the reduced edge the the Excel window that displays, on the left side, the present cell mode, web page number, and also worksheet information; ~ above the best ride, as soon as numerical data is selected, usual calculations such together Sum and also Average display.
SUM FunctionA predefined formula the adds all the number in the selected selection of cells.
SpreadsheetAnother surname for a worksheet.
Text ValuesConstant worths consisting of only text, and which usually provides information around number values; additionally referred to together labels.
Underlying FormulaThe formula entered in a cell and also visible only on the Formula Bar.
Underlying ValueThe data that screens in the Formula Bar.
ValueAnother name for a continuous value.
Value AxisA numerical range on the left side fo a chart that mirrors the selection of numbers because that the data points also referred to together the y- axis.
WorkbookAn Excel paper that includes one or more worksheets.
Workbook- Level ButtonsButtons at the far right that the Ribbon tabs that minimize or gain back a shown workbook.
WordsheetThe primary record that you usage in Excel to work-related with and store data, and also which is formatted together a pattern of uniformly spaced horizontal and also vertical lines.
X-AxisAnother surname for teh horizontal axis.
Y-AxisAnother name for the vertical axis.
AutoCalculateA function that display screens three calculations in the status bar by default—Average, Count, and also Sum—when you pick a range of numerical data.
Chart elements buttonA button that permits you come add, remove, or adjust chart elements such as the title, legend, gridlines, and data labels.
Chart filter buttonA button that allows you to change which data display screens in the chart.
Chart formats buttonA switch that permits you to set a style and color plan for your chart.
Excel pointerAn Excel window element with which girlfriend can display screen the ar of the pointer.
Quick evaluation toolA tool that screens in the reduced right corner of a selected selection with i m sorry you have the right to analyze your data by utilizing Excel devices such together charts, color-coding, and also formulas.
Recommended ChartsAn Excel feature that screens a customized collection of charts that, according to Excel’s calculations, will finest fit your data based upon the selection of data that you select.
Switch Row/ColumnA charting command come swap the data end the axis—data gift charted on the vertical axis will move to the horizontal axis and vice versa.
ThemeA predefined set of colors, fonts, lines, and also fill impacts that coordinate through each other.

See more: Is Officemax Open On Labor Day Hours & Location Near Me, Is Officemax Open On Labor Day

Worksheet net areaA part of the Excel window that screens the columns and also rows that crossing to kind the worksheet’s cells.