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

You are watching: Which of the following is a predesigned set of built-in format options?

Accounting Number FormatThe Excel number format that applies a thousand comma separator wherein apporpriate, inserts a solved U.S. Dollar authorize aligned in ~ he left edge of the cell, uses two decimal places, and also leaves a small amount of room at the ideal edge of the cell to accommodate a parenthesis for negative numbers.
Active CellThe cell, surrounded by a black border, all set to get data or by impacted by the next Excel command.
Arithmetic OperatorsThe symbols +,-,*,/,%, and also ^ offered to signify addition, subtraction, multiplication, division, percentage, and also exponentiation in one Excel formula.
AutoCompleteA attribute that speeds her typing and also lessens the likelihood of errors; if the first couple of characters you type in a cell complement an existing entrance 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 on the worths of selected cells.
AutoFitAn Excel feature that adjusts the width of a tower to right the cell content of the widest cell in the column.
AutoSumAnother name for the sum function.
Category AxisThe area along the bottom of a chart the identifies the categories of data; likewise referred to as the x-axis.
Category LabelsThe brand that display along the bottom of a graph to recognize the category of data; Excel offers the row titles as the classification names.
CellThe intersection the a column and also a row.
Cell AddressAnother surname for a cell reference.
Cell ContentAnything typed into a cell.
Cell ReferenceThe to know of a particular bell by its intersecting obelisk letter and also row number.
Cell StyleA defined set of formatting characteristics, such together font, font size, font color, cell borders, and also cell shading.
ChartThe graphic depiction of data in a worksheet; data presented as a graph is usually simpler to recognize than a table that numbers.
Chart LayoutThe combination of chart aspects that have the right to be presented in a graph such together a title, legend, lables for the columns, and also the table of charted cells.
Chart Layouts GalleryA team of predesigned chart layouts the you can use to one Excel chart.
Chart StylesThe as whole visual look at of a chart in regards to its graphics effects, colors, and backgrounds; because that example, you can have flat or beveled columns, colors, that solid or transparent, and backgrounds that room dark or light.
Chart styles GalleryA team of predesigned chart styles that friend can use to one Excel chart.
Chart TypesVarious chart styles used in a way that is meaninful to the reader; typical examples are pillar charts, pie charts, and also line charts;
ColumnA vertical team of cell in a worksheet.
Column ChartA chart in i m sorry the data is arranged in columns and which is advantageous for showing data transforms over a duration of time or for illustrating comparisons among items.
Column HeadingThe letter that display screens at the peak of a vertical group of cell in a worksheet; start with the first letter that the alphabet, a distinctive letter or mix of letter identifies each column.
Comma StyleThe Excel number layout that inserts thousands comma separators where appropriate and also applies two decimal places; this likewise leaves space at the right to accommodate a parenthesis when negative numbers room present.
Constant ValueNumbers, text, dates, or time of day that you type into a cell.
Context SensitiveA command associated with activites in i m sorry you space engaged; frequently activated by right-clicking a display item.
DataText or numbers in a cell.
Data MarkerA column, bar, area, dot, pie slice, or other symbol in a chart the represents a single data point; associated data points kind a data series.
Data PointA value that originates in a worksheet cell and that is stood for in a graph by a data marker.
Data SeriesRelated data points stood for by data markers; every data series 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 with which you have the right to increase the elevation of the Formula Bar to displaylengthy cell content.
Expand Horizontal scroll Bar ButtonAn Excel home window element through which you deserve to increase the width of the horizontal scroll bar.
Fill HandleThe tiny black square in the lower right edge of a selected cell.
FormatChanging the figure 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 home window that display screens the value or formula contained in the active cell; here you can likewise enter or edit values or formulas.
FunctionA predifined formula- a formula that Excel has currently built because that you-that performs calculations by using specific values in a specific order or structure.
General FormatThe default layout that Excel uses to numbers; this format hs not particular characteristics- every little thing you form in the cell will display, with the exception that trailing zeros to the right of a decimal suggest wiht not display.
LabelColumn and row headings that explain the values and assist the reader know the chart.
Left AlignmentThe cell layout in which characters align in ~ the left edge of the cell; this is the default for message entries and is an instance of formatting information stored in a cell.
LegendA chart element that identify the trends or colour that room assigned to the categories in the chart.
Lettered column 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 cells in one Excel worksheet into one bigger cell and also centers the components in the brand-new cell.
Name BoxAn element of the Excel home window that screens the surname of the selected cell, table, chart, or object.
Normal ViewA display screen view that maximizes the number of cells clearly shows on your screen and also keeps the column letters and also row numbers close come the columns and rows.
Number FormatA specific method in which Excel screens numbers in a cell.
Number ValuesConstant values consisting of only numbers.
Numbered heat HeadingsThe area along the left sheet of a worksheet that identifies each row through a unique number.
OperatorsThe icons with which you can specify the type of calculate you want to execute in an Excel formula.
Page Layout ViewA display screen view in which you deserve to use the rulers to measure up the width and also height the data, set margins because that printing, hide or display screen the numbered heat headings and also the lettered column headings, and change the page orientation; this check out is beneficial for preparing her worksheet for printing.
Picture ElementA suggest of prefer measured in dots per square customs on a screen; 64 pixels equals 8.43 characters, i beg your pardon is the average number of digits that will certainly fit in a cabinet in one Excel worksheet utilizing the default font.
PixelsThe abbreviated name for picture element.
Point and Click MethodThe method of contructing a formula by pointing to and then click cells; this technique is convenient as soon as the referenced cells space not surrounding to one another.
RangeTwo or much more selected cells on a worksheet that are surrounding or nonadjacent; since the variety is treated as a solitary unit, you deserve to make the same alters or mix of transforms to an ext than one cell at a time.
Range FinderAn Excel function that outlines cells in color to show which cell are used in a formula; valuable for verifying i m sorry cells are referenced in a formula.
Relative cabinet ReferenceIn a formula, the deal with of a cell based upon the relative place related jobs on tabs throughout the upper section of the regimen window.
RoundingA procedure in i m sorry you determine which digit at the best of the number will certainly be the critical digit displayed and also then rise it by one if the next digit come its ideal it 5, 6, 7, 8, or 9.
RowA horizontal group of cell in a worksheet.
Row HeadingThe numbers along the left side of an Excel worksheet that designate the heat numbers.
ScalingThe team of commands whereby you have the right to reduce the horizontal and also vertical dimension of the published data through a portion or by the number of pages that you specify.
Select every boxA crate in the top left edge of the worksheet net that, once clicked, selects all the cell in a worksheet.
SeriesA group of things that come one after an additional in succession; for example, January, February, March, and so on.
Sheet Tab Scrolling ButtonsButtons to the left of the paper tabs supplied to display Excel paper tabs that room not in view; used when there are much more sheet tabs than will screen in the space provided.
Sheet TabsThe labels along the lower border the the Excel home window that recognize each wordsheet.
SparklinesA small chart in the background of a cabinet that provides a visual trend review alongside your data; makes a pattern an ext obvious.
Status BarThe area along the lower edge the the Excel home window that displays, top top the left side, the present cell mode, web page number, and worksheet information; top top the appropriate ride, when numerical data is selected, typical calculations such as Sum and also Average display.
SUM FunctionA predefined formula that adds all the numbers in the selected range of cells.
SpreadsheetAnother name for a worksheet.
Text ValuesConstant values consisting of only text, and also which usually offers information around number values; likewise referred to as labels.
Underlying FormulaThe formula gone into in a cell and visible only on the Formula Bar.
Underlying ValueThe data that displays in the Formula Bar.
ValueAnother surname for a constant value.
Value AxisA numerical scale on the left side fo a graph that reflects the selection of numbers for the data points additionally referred to as the y- axis.
WorkbookAn Excel record that has one or more worksheets.
Workbook- Level ButtonsButtons at the far right the the Ribbon tabs that minimization or restore a presented workbook.
WordsheetThe primary paper that you use in Excel to job-related with and also store data, and also which is formatted together a sample of uniformly spaced horizontal and also vertical lines.
X-AxisAnother surname for teh horizontal axis.
Y-AxisAnother surname for the upright axis.
AutoCalculateA attribute that screens three calculations in the status bar through default—Average, Count, and Sum—when you select a range of numerical data.
Chart elements buttonA switch that allows you to add, remove, or adjust chart facets such together the title, legend, gridlines, and also data labels.
Chart filter buttonA switch that permits you to readjust which data screens in the chart.
Chart formats buttonA button that allows you to collection a style and also color system for her chart.
Excel pointerAn Excel home window element through which you can display the location of the pointer.
Quick evaluation toolA device that display screens in the reduced right edge of a selected range with i m sorry you can analyze her data by making use of Excel devices such as charts, color-coding, and also formulas.
Recommended ChartsAn Excel function that screens a customized set of charts that, according to Excel’s calculations, will ideal fit your data based upon the selection of data the you select.
Switch Row/ColumnA charting command to swap the data over the axis—data gift charted ~ above the vertical axis will move to the horizontal axis and also vice versa.
ThemeA predefined collection of colors, fonts, lines, and also fill impacts that coordinate v each other.

See more: How Did Jun Die In Halo Reach ? Is Jun Dead

Worksheet grid areaA component of the Excel home window that displays the columns and rows that crossing to form the worksheet’s cells.