Excel because that gimpppa.org 365 Excel for gimpppa.org 365 for Mac Excel because that the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel because that iPad Excel for iPhone Excel for Android tablet computers Excel 2010 Excel 2007 Excel because that Mac 2011 Excel because that Android phones Excel mobile More...Less

3-D

A

B

C

D

E

F

G

H

ns

J

together

M

N

O

ns

Q

R

S

T

U

V

W

X

3-D

top of web page

3-D reference

A reference to a selection that spans two or an ext worksheets in a workbook.

You are watching: Charts can either be embedded in a worksheet

3-D walls and floor

The areas surrounding plenty of 3-D chart varieties that provide dimension and boundaries come the chart. Two walls and one floor are displayed within the plot area.

A

top of web page

Activate

To do a chart sheet or worksheet the active, or selected, sheet. The sheet the you activate determines which tabs are displayed. Come activate a sheet, click the tab because that the sheet in the workbook.

Active cell

The selected cabinet in i m sorry data is gotten in when you start typing. Just one cabinet is active at a time. The energetic cell is bounded by a heavy border.

Active sheet

The sheet that you"re functioning on in a workbook. The surname on the tab of the active sheet is bold.

Address

The route to an object, document, file, page, or other destination. An attend to can be a URL (Web address) or a UNC course (network address), and also can incorporate a specific location in ~ a file, such as a indigenous bookmark or one Excel cabinet range.

Alternate startup folder

A folder in addition to the XLStart folder that includes workbooks or other files that you desire to it is in opened automatically when you begin Excel and templates that you want to be accessible when girlfriend create brand-new workbooks.

Alternate startup folder

A folder in addition to the XLStart folder that consists of workbooks or other records that you desire to it is in opened immediately when you start Excel and templates the you want to be available when girlfriend create new workbooks.

Argument

The values that a role uses to perform operations or calculations. The type of debate a function uses is particular to the function. Common debates that are supplied within functions encompass numbers, text, cabinet references, and also names.

Array

Used to build solitary formulas that produce multiple outcomes or that run on a group of debates that space arranged in rows and columns. An array selection shares a typical formula; an array consistent is a team of constants provided as one argument.

Array formula

A formula that performs many calculations on one or more sets of values, and then returns either a single an outcome or lot of results. Range formulas room enclosed in between braces and also are entered by pushing CTRL+SHIFT+ENTER.

Associated PivotTable

The PivotTable that supplies the resource data come the PivotChart. That is created automatically when you create a brand-new PivotChart. As soon as you readjust the layout of one of two people report, the other likewise changes.

Autoformat

A built-in collection of cell styles (such together font size, patterns, and alignment) the you can use to a selection of data. Excel determines the level of an introduction and information in the selected selection and uses the formats accordingly.

Axis

A line bordering the graph plot area provided as a structure of recommendation for measurement. The y axis is usually the upright axis and contains data. The x-axis is generally the horizontal axis and also contains categories.

B

height of web page

Base address

The family member path the Excel offers for the destination address when you insert a hyperlink. This can be one Internet resolve (URL), a course to a folder top top your tough drive, or a route to a folder top top a network.

Border

A decorative heat that deserve to be applied to worksheet cells or objects, such together charts, pictures, or text boxes. Borders distinguish, emphasize, or group items.

C

height of web page

Calculated column

In an Excel table, a calculated column uses a single formula the adjusts because that each row. It immediately expands to include additional rows so that the formula is immediately extended to those rows.

Calculated field (database)

A field in the result set of a ask that screens the an outcome of an expression rather than data from a database.

Calculated ar (PivotTable)

A ar in a PivotTable or PivotChart that supplies a formula friend create. Calculated fields can carry out calculations by using the components of other fields in the PivotTable or PivotChart.

Calculated item

An item in ~ a PivotTable ar or PivotChart ar that uses a formula you create. Calculation items have the right to perform calculations by making use of the components of various other items in ~ the same field of the PivotTable or PivotChart.

Category axis

A graph axis that represents the category for every data point. It screens arbitrary text values choose Qtr1, Qtr2, and also Qtr3; the cannot display screen scaled number values.

Category field

A ar that"s presented in the group area that the PivotChart. Item in a group field show up as the labels on the group axis.

Cell

A box created by the intersection of a row and column in a worksheet or a table, in i m sorry you go into information.

Cell reference

The set of coordinates that a cell occupies ~ above a worksheet. Because that example, the reference of the cabinet that shows up at the intersection of obelisk B and also row 3 is B3.

Certifying authority

A advertising organization, or a group within a company, that uses tools such together gimpppa.org Certificate Server to provide digital certificate that software program developers can use to sign macros and also users can use to sign documents.

Change history

In a shared workbook, info that is maintained around changes do in past modifying sessions. The information consists of the name of the person who made every change, when the change was made, and also what data to be changed.

Chart area

The entire chart and all the elements.

Chart sheet

A sheet in a workbook that includes only a chart. A chart sheet is beneficial when you want to check out a chart or a PivotChart individually from worksheet data or a PivotTable.

Column field

A field that"s assigned a pillar orientation in a PivotTable. Items associated with a column ar are displayed as column labels.

Column heading

The shaded area in ~ the height of each Data pane pillar that has the field name.

Column heading

The lettered or numbered gray area at the height of each column. Click the tower heading come select whole column. To rise or to decrease the width of a column, traction the heat to the appropriate of the obelisk heading.

Comparison criteria

A set of search conditions that is offered to discover data. Comparison criteria have the right to be a series of characters that you want to match, such as "Northwind Traders," or one expression, such together ">300."

Comparison operator

A authorize that is offered in compare criteria come compare 2 values. The 6 standards are = same to, > better than, = greater than or same to, not equal to.

Conditional format

A format, such as cell shading or font color, that Excel automatically applies to cells if a specified condition is true.

Consolidation table

The table of an unified results that shows up in the location area. Excel create the consolidation table by using the summary function that you pick to the resource area worths that you specify.

Constant

A worth that is no calculated. For example, the number 210 and the text "Quarterly Earnings" room constants. An expression, or a worth resulting from an expression, is not a constant.

Constraints

The limitations placed on a Solver problem. Friend can use constraints to adjustable cells, the target cell, or other cells the are directly or indirectly pertained to the target cell.

Copy area

The cells the you copy once you desire to paste data into an additional location. After you copy cells, a moving border appears around them to show that they"ve been copied.

Criteria

Conditions friend specify to border which documents are included in the an outcome set that a query. For example, the adhering to criterion selects records for i m sorry the value for the bespeak Amount ar is greater than 30,000: bespeak Amount > 30000.

Criteria pane

The area of the home window that screens the criteria used to limit the records contained in the result set of your query.

Current region

The block that filled-in cells that includes the right now selected cell or cells. The region extends in every directions to the an initial empty row or column.

Custom calculation

A technique of summarizing worths in the data area the a PivotTable by making use of the worths in other cells in the data area. Use the present data together list ~ above the PivotTable ar dialog because that a data field to produce custom calculations.

D

height of web page

Data form

A dialog crate that screens one finish record at a time. You deserve to use data creates to add, change, locate, and delete records.

Data label

A label that provides extr information around a data marker, which represents a solitary data allude or value that originates native a datasheet cell.

Data marker

A bar, area, dot, slice, or various other symbol in a chart that represents a single data point or worth that originates native a datasheet cell. Related data mite in a graph constitute a data series.

Data pane

The area the the window that display screens the an outcome set of her query.

Data points

Individual worths that are plotted in a chart. Connected data points consist of a data series. Data points are stood for by bars, columns, lines, slices, dots, and other shapes. These shapes are dubbed data markers.

Data region

A range of cells that includes data and also that is bounded by north cells or datasheet borders.

Data series

Related data point out that room plotted in a chart and also originate indigenous datasheet rows or columns. Each data collection in a chart has actually a unique shade or pattern. You can plot one or an ext data series in a chart. Pie charts have actually only one data series.

Data source

A stored set of "source" info used to attach to a database. A data resource can include the name and location of the database server, the surname of the database driver, and also information that the database needs when you log on.

Data source driver

A program paper used to connect to a specific database. Every database regimen or administration system needs a various driver.

Data table

A variety of cells that mirrors the results of substituting various values in one or more formulas. There space two species of data tables: one-input tables and also two-input tables.

Data table in charts

A grid that can be included to part charts and also contains the numeric data offered to develop the chart. The data table usually is attached come the horizontal axis of the chart and replaces the tick-mark labels on the horizontal axis.

Data validation

An Excel feature that you can use to specify restrictions ~ above what data deserve to or have to be gotten in in a cell, and also to display messages the prompt users for exactly entries and also notify users about incorrect entries.

Database

A collection of data related to a particular subject or purpose. Within a database, information around a specific entity, such as an employee or order, is categorized into tables, records, and also fields.

DDE conversation

The interaction in between two applications that are communicating and also exchanging data v special functions and code well-known as dynamic data exchange (DDE).

Default startup workbook

The new, unsaved workbook that"s presented when you start Excel. The default startup workbook is presented only if you haven"t had other workbooks in the XLStart folder.

Default workbook template

The Book.xlt template that you develop to adjust the default style of brand-new workbooks. Excel offers the design template to produce a empty workbook when you start Excel or develop a new workbook without specifying a template.

Default worksheet template

The Sheet.xlt design template that you produce to adjust the default layout of new worksheets. Excel provides the template to develop a empty worksheet once you include a new worksheet to a workbook.

Dependents

Cells that contain formulas the refer to various other cells. Because that example, if cabinet D10 includes the formula =B5, cabinet D10 is a dependency of cabinet B5.

Destination area

The range of cells that you choose to hold the summary data in a consolidation. The location area can be ~ above the very same worksheet together the source data or ~ above a various worksheet. A worksheet have the right to contain only one consolidation.

Detail data

For automatic subtotals and worksheet outlines, the subtotal rows or columns that room totaled by an introduction data. Information data is typically surrounding to and also either above or come the left of the summary data.

Drop lines

In line and also area charts, present that prolong from a data point to the group (x) axis. Beneficial in area charts to clarify whereby one data marker ends and the next begins.

Drop-down list box

A manage on a menu, toolbar, or dialog box that displays a list of alternatives when girlfriend click the tiny arrow next to the perform box.

E

peak of web page

Embedded chart

A chart that is put on a worksheet fairly than on a different chart sheet. Embedded charts are valuable when you desire to see or publish a chart or a PivotChart through its resource data or other details in a worksheet.

Error bars

Usually offered in statistical or scientific data, error bars show potential error or level of uncertainty relative to every data marker in a series.

Excel add-in

Components that have the right to be mounted on your computer system to add commands and functions to Excel. This add-in program are specific to Excel. Other add-in programs that are obtainable for Excel or Office are Component Object design (COM) add-ins.

Excel table

Formerly well-known as an Excel list, you deserve to create, format, and also expand one Excel table come organize the data on her worksheet.

Expression

A combination of operators, field names, functions, literals, and constants that evaluates to a solitary value. Expressions have the right to specify criteria (such together Order Amount>10000) or perform calculations on ar values (such together Price*Quantity).

External data

Data that is stored in a database, such as Access, dBASE, or SQL Server, the is separate from Query and also the program from which you started Query.

External data

Data the is stored external of Excel. Examples include databases created in Access, dBASE, SQL Server, or top top a internet server.

External data range

A selection of data that is lugged into a worksheet however that originates exterior of Excel, such together in a database or message file. In Excel, friend can style the data or use it in calculations as you would any type of other data.

External reference

A reference to a cabinet or selection on a paper in one more Excel workbook, or a reference to a identified name in an additional workbook.

F

top of web page

Field (database)

A group of information, such as last name or bespeak amount, the is stored in a table. As soon as Query screens a an outcome set in the Data pane, a field is represented as a column.

Field (PivotTable)

In a PivotTable or PivotChart, a category of data that"s acquired from a ar in the resource data. PivotTables have actually row, column, page, and data fields. PivotCharts have actually series, category, page, and data fields.

Fill handle

The tiny black square in the lower-right corner of the selection. When you allude to the to fill handle, the pointer changes to a black color cross.

Filter

To display only the rows in a list that satisfy the problems you specify. You usage the AutoFilter command to display rows that complement one or much more specific values, calculated values, or conditions.

Font

A graphic design used to every numerals, symbols, and also alphabetic characters. Additionally called form or typeface. Arial and also Courier new are examples of fonts. Fonts normally come in various sizes, such together 10 point, and also various styles, such as bold.

Formula

A succession of values, cell references, names, functions, or operators in a cell the together produce a brand-new value. A formula always begins through an equal sign (=).

Formula bar

A bar at the peak of the Excel home window that you use to get in or edit values or recipe in cells or charts. Displays the consistent value or formula save on computer in the energetic cell.

Formula Palette

A device that helps you develop or modify a formula and likewise provides information about functions and also their arguments.

Function (gimpppa.org Query)

An expression that returns a value based upon the results of a calculation. Questions assumes that data sources gimpppa.org the Avg, Count, Max, Min, and Sum functions. Part data sources might not gimpppa.org all of these, or might gimpppa.org extr functions.

Function (Office Excel)

A prewritten formula the takes a worth or values, performs one operation, and also returns a value or values. Use attributes to simplify and shorten recipe on a worksheet, specifically those the perform an extensive or facility calculations.

G

peak of page

Goal seek

A method to discover a particular value because that a cell by adjusting the worth of one other cell. When goal seeking, Excel varies the worth in a cell that you specify till a formula that"s dependency on that cell returns the result you want.

Grid

A collection of intersecting lines used to align objects.

Gridlines in charts

Lines friend can add to a chart the make it simpler to view and evaluate data. Gridlines expand from the tick marks on an axis across the plot area.

Group

In an synopsis or PivotTable, one or an ext detail rows or columns that are adjacent and low grade to a an overview row or column.

H

top of page

High-low lines

In 2-D line charts, lines that extend from the highest to the lowest value in every category. High-low lines are often used in stock charts.

History worksheet

A different worksheet that lists transforms being tracked in a mutual workbook, consisting of the name of the human who made the change, when and where it was made, what data was deleted or replaced, and how disputes were resolved.

I

height of page

Identifier

A ar name provided in an expression. Because that example, order Amount is the i would (field name) for a field that consists of order amounts. You have the right to use one expression (such together Price*Quantity) in location of one identifier.

Implicit intersection

A referral to a range of cells, rather of a solitary cell, that is calculated like a single cell. If cell C10 has the formula =B5:B15*5, Excel multiplies the value in cabinet B10 through 5 since cells B10 and C10 are in the exact same row.

Index

A database component that speeds up searching because that data. When a table has an index, data in the table deserve to be uncovered by feather it up in the index.

Inner join

In Query, default type of join between two tables where only the records that have actually the very same values in the joined fields are selected. The two corresponding records from each table are linked and presented as one record in the result set.

Input cell

The cell in which every input value from a data table is substituted. Any cell ~ above a worksheet can be the intake cell. Although the input cell does not should be component of the data table, the recipe in data tables have to refer come the entry cell.

Insert row

In an Excel table, a distinct row the facilitates data entry. The Insert row is indicated by one asterisk.

Internet Explorer

A Web internet browser that interprets HTML files, formats them into web pages, and displays them to the user. You deserve to download Internet traveler from the gimpppa.org net site in ~ http://www.gimpppa.org.com.

Item

A subcategory of a ar in PivotTables and PivotCharts. For instance, the field "Month" could have items such as "January," "February," and also so on.

Iteration

Repeated calculation of a worksheet till a particular numeric problem is met.

J

height of page

Join

A connection in between multiple tables where documents from related areas that match are merged and shown as one record. Records that don"t complement may be contained or excluded, relying on the type of join.

Join line

In Query, a line that connects fields between two tables and also shows Query how the data is related. The type of join suggests which records are selected because that the query"s result set.

Join line

In Query, a line the connects fields between two tables and also shows exactly how the data is related. The kind of join indicates which records are selected for the query"s result set.

Justify

To readjust horizontal spacing therefore that text is set evenly follow me both the left and also right margins. Justifying text creates a smooth edge on both sides.

L

optimal of page

Legend

A box that identify the trends or color that are assigned to the data collection or categories in a chart.

Legend keys

Symbols in legends that display the patterns and also colors assigned come the data series (or categories) in a chart. Legend keys appear to the left the legend entries. Formatting a legend vital also formats the data mite that"s associated with it.

Locked field or record

The condition of a record, field, or other object in a database that permits the to be viewed however not readjusted (read-only) in Query.

M

optimal of page

Mapped range

A variety in an XML list that has been linked to an element in one XML map.

Matrix

A rectangular variety of worths or a variety of cells the is merged with other arrays or arrays to create multiple sums or products. Excel has actually predefined matrix attributes that can create the sums or products.

Merged cell

A single cell that is produced by combining two or much more selected cells. The cell reference for a combined cell is the upper-left cell in the original selected range.

Microsoft Excel control

A indigenous Excel manage other than an ActiveX control.

Microsoft Visual basic Help

To get aid for Visual simple in Excel, ~ above the Developer tab, in the Code group, click Visual Basic, and also then under the Help menu, click gimpppa.org Visual straightforward Help.

Moving average

A sequence of averages computed from components of a data series. In a chart, a moving average smooths the fluctuations in data, hence showing the sample or trend more clearly.

Moving border

An animated border that appears around a worksheet variety that has been reduced or copied. Come cancel a moving border, press ESC.

Multiple-level group labels

Category labels in a graph that, based upon worksheet data, are instantly displayed on much more than one heat in a hierarchy. For example, the heading Produce can appear over a row v headings Tofu, Apples, and Pears.

N

height of web page

Name

A indigenous or cable of personalities that to represent a cell, range of cells, formula, or continuous value. Usage easy-to-understand names, such together Products, come refer to difficult to know ranges, such as Sales!C20:C30.

Name box

Box at left finish of the formula bar that identifies the selected cell, graph item, or illustration object. To name a cell or range, type the name in the surname box and also press ENTER. To relocate to and select a named cell, click its name in the name box.

Nonadjacent selection

A an option of two or much more cells or varieties that don"t touch every other. Once plotting nonadjacent selections in a chart, make sure that the linked selections type a rectangle-shaped shape.

Non-OLAP resource data

Underlying data for a PivotTable or PivotChart that comes from a source other 보다 an OLAP database. This sources incorporate relational databases, tables on Excel worksheets, and text record databases.

O

top of page

ObjectLink

An OLE data layout that defines a attached object, identifying the class, record name, and also name of one object. Each of this data items is a null-terminated string.

Offline cube file

A file you produce on your difficult disk or a network share to save OLAP source data because that a PivotTable or PivotChart. Offline cube files enable you to save working when you space not connected to the OLAP server.

OLAP

A database an innovation that has actually been optimized because that querying and also reporting, instead of processing transactions. OLAP data is arranged hierarchically and also stored in cubes rather of tables.

OLAP provider

A collection of software that provides access to a particular type of OLAP database. This software can include a data source driver and also other client software that is essential to attach to a database.

Operand

Items on either next of an operator in a formula. In Excel, operands can be values, cell references, names, labels, and also functions.

Operator

A sign or symbol that mentions the type of calculation to carry out within one expression. There are mathematical, comparison, logical, and also reference operators.

Outer join

In Query, a sign up with where all documents from one table space selected, even if there space no matching records in another table. Records that match are combined and displayed as one. Records that don"t have actually matches in the other table are shown empty.

Outer join

Join in i beg your pardon all records from one table room selected, also if there are no equivalent records in another table. Records that enhance are merged and shown as one. Documents that don"t have actually matches in the other table are displayed as empty.

Outline

Worksheet data in i beg your pardon rows or columns of information data are grouped so the you have the right to create an overview reports. The outline deserve to summarize either whole worksheet or a selected part of it.

Outline data

The data that is included within a worksheet outline. Overview data has both the an introduction and detail rows or columns of an outline.

Outline symbols

Symbols that you use to readjust the watch of one outlined worksheet. Friend can present or hide in-depth data by pressing the to add sign, minus sign, and the numbers 1, 2, 3, or 4, indicating the summary level.

OwnerLink

An OLE data layout that defines an embedded object, identify the class, document name, and also name of an object. Each of these data items is a null-terminated string.

P

height of web page

Page break

Divider that breaks a worksheet into separate pages for printing. Excel inserts automatic page breaks based upon the record size, margin settings, scaling options, and the positions of any kind of manual web page breaks that you insert.

Page break preview

Worksheet see that displays the locations to be printed and also the locations of web page breaks. The area to be printed is displayed in white, automatic page breaks show up as dashed lines, and also manual page breaks show up as hard lines.

Parameter

In Excel, you deserve to add, change, or eliminate parameters come specify cell that are editable in the viewable worksheet data of Excel Services. When you conserve the workbook, the transforms are immediately reflected on the server.

Parameter query

A kind of query that, when you run it, prompts for values (criteria) to usage to pick the documents for the an outcome set so that the very same query can be used to retrieve different an outcome sets.

Password

A method to protect your worksheet or workbook. As soon as you defend worksheet or workbook facets with a password, that is an extremely important that you remember that password. There is no it, over there is no method to unprotect the workbook or worksheet. You should always use strong passwords that combine uppercase and also lowercase letters, numbers, and also symbols. Weak passwords don"t mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a solid password the you can remember so the you don"t have to write that down.

Paste area

The target location for data that"s been reduced or copied by using the Office Clipboard.

Pivot area

The worksheet area right into which you traction PivotTable or PivotChart areas to adjust the layout that the report. Top top a brand-new report, dashed blue outlines suggest the pivot area top top the worksheet.

PivotChart classification field

A ar that is assigned a group orientation in a PivotChart. In a chart, categories usually appear on the x-axis, or horizontal axis, of the chart.

PivotChart

A chart that provides interactive evaluation of data, favor a PivotTable. Friend can adjust views the data, see different levels that detail, or reorganize the graph layout through dragging fields and by reflecting or hiding items in fields.

PivotChart collection field

A field that is assigned a collection orientation in a PivotChart. In a chart, series are represented in the legend.

PivotTable data

In a PivotTable, the summary data that"s calculated indigenous the data areas of a source list or table.

PivotTable grand totals

Total worths for every cells in a row or all cells in a obelisk of a PivotTable. Values in a grand full row or obelisk are calculated by using the same summary function used in the data area the the PivotTable.

PivotTable list

A gimpppa.org Office internet Component that permits you to develop a structure comparable to an Excel PivotTable. Users have the right to view the PivotTable perform in a Web browser and readjust its layout in a manner comparable to an Excel PivotTable.

PivotTable

An interactive, cross-tabulated Excel report the summarizes and analyzes data, such as database records, from assorted sources including ones external to Excel.

PivotTable subtotal

A row or shaft that provides a summary role to display screen the total of information items in a PivotTable field.

Plot area

In a 2-D chart, the area bounded by the axes, including all data series. In a 3-D chart, the area bounded through the axes, consisting of the data series, group names, tick-mark labels, and axis titles.

Point

A unit the measurement same to 1/72 of an inch.

Precedents

Cells that are referred to by a formula in an additional cell. Because that example, if cell D10 consists of the formula =B5, cell B5 is a precedent to cabinet D10.

Primary key

One or much more fields that uniquely determine each record in a table. In the same way that a patent plate number identify a car, the primary key uniquely identifies a record.

Print area

One or much more ranges of cells that you designate to print as soon as you don"t want to print the entire worksheet. If a worksheet has a publish area, just the print area is printed.

Print titles

Row or tower labels the are printed at the top of or on the left next of every page on a printed worksheet.

Property fields

Independent attributes associated with items, or members, in an OLAP cube. For example, if city items have size and population properties stored in the server cube, a PivotTable can display the dimension and population of each city.

Protect

To make setups for a worksheet or workbook that stop users native viewing or gaining access to the specified worksheet or workbook elements.

Q

top of page

Query

In questions or Access, a way of detect the records that price a details question you ask around the data save on computer in a database.

Query channel

You usage a ask channel in a DDE conversation in between the location application and a details query (for example, Query1) in Query. To usage a query channel, you must have currently opened the query window using a system channel.

Query design

All aspects included in the questions window, such together tables, criteria, the order in which fields are arranged, and so on. The design also specifies even if it is Auto query is turn on, and whether friend can modify the source data.

R

optimal of page

Range

Two or much more cells top top a sheet. The cells in a variety can be adjacent or nonadjacent.

Read-only

A setting that allows a record to be read or copied yet not changed or saved.

Record

A collection of information around a specific person, place, event, or thing. As soon as Query display screens a result set in the Data pane, a document is stood for as a row.

Refresh (external data range)

To upgrade data native an outside data source. Every time girlfriend refresh data, you see the many recent version of the details in the database, including any type of changes that were made come the data.

Refresh (PivotTable)

To upgrade the contents of a PivotTable or PivotChart to reflect changes to the underlying resource data. If the report is based on external data, refreshing runs the underlying query to retrieve new or adjusted data.

Regression analysis

A kind of statistical analysis used for forecasting. Regression evaluation estimates the relationship between variables so that a given variable deserve to be predicted native one or an ext other variables.

Relative reference

In a formula, the address of a cell based on the relative place of the cell that has the formula and also the cabinet referred to. If friend copy the formula, the reference instantly adjusts. A relative reference takes the type A1.

Remote reference

A referral to data save in a file from an additional program.

Report filter

A ar that"s offered to filter a subset of data in a PivotTable or PivotChart right into one page for additional layout and analysis. You have the right to either display screen a an overview of all items in a report filter, or display screen one item in ~ a time, i m sorry filters the end the data for all various other items.

Report template

An Excel layout (.xlt file) that contains one or much more queries or PivotTables that are based upon external data. Once you save a report template, Excel saves the query an interpretation but doesn"t keep the queried data in the template.

Result set

The collection of documents returned when you run a query. You can see the an outcome set the a ask in Query, or you have the right to return a an outcome set come an Excel worksheet for additional analysis.

Row heading

The numbered gray area come the left of every row. Click the heat heading to select whole row. To increase or diminish the height of a row, traction the line listed below the heat heading.

Row label

A ar that"s assigned a heat orientation in a PivotTable.

R-squared value

A number native 0 come 1 that reveals how carefully the approximated values because that the trendline exchange mail to your actual data. A trendline is many reliable once its R-squared worth is in ~ or near 1. Also known as the coefficient the determination.

S

top of page

Scenario

A named set of input values that you deserve to substitute in a worksheet model.

Scroll lock

With scroll lock turn on, the arrowhead keys scroll the energetic sheet rather than do a different cell active. To rotate scroll lock turn off or on, press the scroll LOCK key.

Section

Any mix of a worksheet, view, and also scenario that you choose when you produce a report. A report can contain several sections.

Select

To to mark a cabinet or variety of cell on a worksheet. The selected cells will be impacted by the following command or action.

Select every button

The gray rectangle in the upper-left edge of a datasheet wherein the row and column headings meet. Click this button to choose all cells on a datasheet.

Series axis

A chart axis that represents the depth measurement in a true 3-D chart. It screens the series names together arbitrary text values; that cannot screen scaled numerical values.

Series field

A ar that"s displayed in the series area of a PivotChart. Items in a series field are detailed in the legend and carry out the names of the separation, personal, instance data series.

Series lines

In 2-D stacked bar and column charts, lines that connect the data mite in every data collection that are supplied to emphasize the distinction in measurement between each series.

Shared workbook

A workbook collection up to permit multiple customers on a network come view and make alters at the exact same time. Every user who saves the workbook watch the changes made by other users.

Single-mapped cell

A cabinet that has been attached to a non-repeating facet in an XML map.

Sort order

A means to arrange data based upon value or data type. You deserve to sort data alphabetically, numerically, or through date. Type orders usage an ascending (1 to 9, A come Z) or to decrease (9 to 1, Z to A) order.

Source areas

The cell arrays that friend consolidate in the location area friend specify. Resource areas have the right to be on any worksheet in a workbook, in other open or close up door workbooks, or top top Lotus 1-2-3 worksheets.

Source data

The perform or table that"s used to create a PivotTable or PivotChart. Resource data have the right to be taken native an Excel table or range, an outside database or cube, or another PivotTable.

SQL

A language offered to retrieve, update, and also manage data. When you produce a query, Query provides SQL to build the equivalent SQL choose statement. If you recognize SQL, you deserve to view or readjust the SQL choose statement.

Standard font

The default message font because that worksheets. The conventional font identify the default font because that the typical cell style.

Summary data

For automatically subtotals and also worksheet outlines, all rows or columns that summarize detail data. Review data typically is nearby to and below the information data.

Summary function

A type of calculation that combines resource data in a PivotTable or a consolidation table, or when you are inserting automatically subtotals in a perform or database. Examples of review functions incorporate Sum, Count, and Average.

System channel

Used in a DDE conversation in between applications to get information around the system, such as the present connections, open up queries, and the condition of the location application.

T

height of page

Table pane

The area the the Query home window that display screens the tables in a query. Every table display screens the fields from i beg your pardon you have the right to retrieve data.

Template

A workbook that you create and use as the basis because that other comparable workbooks. Girlfriend can develop templates for workbooks and worksheets. The default design template for workbooks is called Book.xlt. The default template for worksheets is dubbed Sheet.xlt.

Text box

A rectangular object ~ above a worksheet or chart, in which friend can type text.

Tick marks and also tick-mark labels

Tick point out are tiny lines the measurement, similar to departments on a ruler, that intersect an axis. Tick-mark labels recognize the categories, values, or series in the chart.

Titles in charts

Descriptive text that is automatically aligned to an axis or centered at the optimal of a chart.

Total row

A distinct row in an Excel table that provides a choice of aggregate functions helpful for working with numerical data.

Totals

One of the five calculation types Query specifies for you: Sum, Avg, Count, Min, and Max.

Tracer arrows

Arrows that show the relationship between the energetic cell and its connected cells. Tracer arrows are blue as soon as pointing indigenous a cell that provides data to another cell, and also red if a cell contains an error value, such together #DIV/0!.

Trendline

A graphic depiction of fads in data series, such as a heat sloping upward to represent increased sales end a duration of months. Trendlines are used for the study of difficulties of prediction, also called regression analysis.

Trendline label

Optional message for a trendline, including either the regression equation or the R-squared value, or both. A trendline label deserve to be formatted and moved; it can not be sized.

U

height of web page

Up-down bars

In line charts v multiple data series, bars that suggest the difference between data clues in the an initial and critical series.

V

height of page

Value

The text, date, number, or logical input the completes a problem that a field must accomplish for searching or filtering. For example, the field writer with the condition equals must incorporate a value, such together John, to be complete.

Value axis

A graph axis that display screens scaled number values.

Value field

A ar from a source list, table, or database that includes data the is summarized in a PivotTable or PivotChart. A value field usually consists of numeric data, such together statistics or sales amounts.

Values area

The part of a PivotTable the contains review data. Values in every cell that the values area represent a summary of data indigenous the resource records or rows.

Vertexes

Black, square, draggable clues that appear at the ends and also intersections of present or curve in certain AutoShapes (such together freeforms, scribbles, and curves) as soon as you modify points on the AutoShape.

Vertexes

Black, square, draggable point out that appear at the ends and also intersections of currently or curves in particular AutoShapes, such as freeforms, scribbles, and also curves.

View

A collection of display and also print settings that you can name and apply to a workbook. You can create an ext than one see of the exact same workbook without conserving separate copies of the workbook.

W

peak of page

Web query

A query that retrieves data save on computer on your intranet or the Internet.

What-if analysis

A process of transforming the worths in cells to see just how those changes impact the result of recipe on the worksheet. For example, varying the interest price that is used in an amortization table to recognize the amount of the payments.

Workbook

A spreadsheet program paper that you create in Excel. A workbook contains worksheets that rows and also columns in i m sorry you deserve to enter and also calculate data.

Worksheet

The primary record that you use in Excel to store and also work through data. Additionally called a spreadsheet. A worksheet consists of cell that room organized into columns and also rows; a worksheet is always stored in a workbook.

Workspace file

A paper that saves screen information around open workbooks, so the you have the right to later resume occupational with the same home window sizes, print areas, screen magnification, and also display settings. A workspace paper doesn"t contain the workbooks themselves.

World wide Web

A device for navigating the internet or v a arsenal of workbooks and other Office documents linked by hyperlinks and located on a network share, a company intranet or the Internet. As soon as you use a net browser, the Web appears as a arsenal of text, pictures, sounds, and also digital movies.

Wrap

In text, to break a line of text immediately on reaching a margin or object and also continue the message on a new line.

See more: Ford Mustang Cabin Air Filter Location, Mustang Cabin Air Filter 2005

X

top of page

XML

Extensible Markup Language (XML): A condensed form of Standard generalised Markup Language (SGML) that allows developers to produce customized tags that offer adaptability in organizing and also presenting information.