AB | |

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 Format | The 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 Cell | The cell, surrounded by a black border, all set to get data or by impacted by the next Excel command. |

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

AutoComplete | A 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 Fill | An Excel attribute that generates and also extends values into nearby cells based on the worths of selected cells. |

AutoFit | An Excel feature that adjusts the width of a tower to right the cell content of the widest cell in the column. |

AutoSum | Another name for the sum function. |

Category Axis | The area along the bottom of a chart the identifies the categories of data; likewise referred to as the x-axis. |

Category Labels | The brand that display along the bottom of a graph to recognize the category of data; Excel offers the row titles as the classification names. |

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

Cell Address | Another surname for a cell reference. |

Cell Content | Anything typed into a cell. |

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

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

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

Chart Layout | The 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 Gallery | A team of predesigned chart layouts the you can use to one Excel chart. |

Chart Styles | The 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 Gallery | A team of predesigned chart styles that friend can use to one Excel chart. |

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

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

Column Chart | A 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 Heading | The 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 Style | The 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 Value | Numbers, text, dates, or time of day that you type into a cell. |

Context Sensitive | A command associated with activites in i m sorry you space engaged; frequently activated by right-clicking a display item. |

Data | Text or numbers in a cell. |

Data Marker | A 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 Point | A value that originates in a worksheet cell and that is stood for in a graph by a data marker. |

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

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

Expand Formula Bar Button | An 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 Button | An Excel home window element through which you deserve to increase the width of the horizontal scroll bar. |

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

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

Formula | An equation the performs mathematical calculations on worths in a worksheet. |

Formula Bar | An 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. |

Function | A 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 Format | The 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. |

Label | Column and row headings that explain the values and assist the reader know the chart. |

Left Alignment | The 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. |

Legend | A chart element that identify the trends or colour that room assigned to the categories in the chart. |

Lettered column Headings | The area along the top edge the a worksheet that identifies each obelisk with a unique letter or combination of letters. |

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

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

Normal View | A 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 Format | A specific method in which Excel screens numbers in a cell. |

Number Values | Constant values consisting of only numbers. |

Numbered heat Headings | The area along the left sheet of a worksheet that identifies each row through a unique number. |

Operators | The icons with which you can specify the type of calculate you want to execute in an Excel formula. |

Page Layout View | A 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 Element | A 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. |

Pixels | The abbreviated name for picture element. |

Point and Click Method | The 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. |

Range | Two 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 Finder | An 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 Reference | In 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. |

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

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

Row Heading | The numbers along the left side of an Excel worksheet that designate the heat numbers. |

Scaling | The 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 box | A crate in the top left edge of the worksheet net that, once clicked, selects all the cell in a worksheet. |

Series | A group of things that come one after an additional in succession; for example, January, February, March, and so on. |

Sheet Tab Scrolling Buttons | Buttons 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 Tabs | The labels along the lower border the the Excel home window that recognize each wordsheet. |

Sparklines | A small chart in the background of a cabinet that provides a visual trend review alongside your data; makes a pattern an ext obvious. |

Status Bar | The 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 Function | A predefined formula that adds all the numbers in the selected range of cells. |

Spreadsheet | Another name for a worksheet. |

Text Values | Constant values consisting of only text, and also which usually offers information around number values; likewise referred to as labels. |

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

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

Value | Another surname for a constant value. |

Value Axis | A 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. |

Workbook | An Excel record that has one or more worksheets. |

Workbook- Level Buttons | Buttons at the far right the the Ribbon tabs that minimization or restore a presented workbook. |

Wordsheet | The 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-Axis | Another surname for teh horizontal axis. |

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

AutoCalculate | A 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 button | A switch that allows you to add, remove, or adjust chart facets such together the title, legend, gridlines, and also data labels. |

Chart filter button | A switch that permits you to readjust which data screens in the chart. |

Chart formats button | A button that allows you to collection a style and also color system for her chart. |

Excel pointer | An Excel home window element through which you can display the location of the pointer. |

Quick evaluation tool | A 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 Charts | An 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/Column | A 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. |

Theme | A 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 area | A component of the Excel home window that displays the columns and rows that crossing to form the worksheet’s cells. |