Excel for hunterriverpei.com 365 Excel because that hunterriverpei.com 365 because that Mac Excel for the net Excel 2021 Excel 2021 because that Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel because that iPad Excel for iPhone Excel because that 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

l

M

N

O

p

Q

R

S

T

U

V

W

X

3-D

top of web page

3-D reference

A referral to a selection that spans 2 or much more worksheets in a workbook.

You are watching: Excel recognizes an entry as a value if it is a number or it begins with ____.

3-D walls and floor

The areas surrounding countless 3-D chart types that give dimension and also boundaries to the chart. 2 walls and also one floor are presented within the plot area.

A

height of page

Activate

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

Active cell

The selected cabinet in which data is gone into when you begin typing. Just one cell is active at a time. The active cell is bounded through a heavy border.

Active sheet

The sheet that you"re working on in a workbook. The surname on the tab the the energetic sheet is bold.

Address

The course to an object, document, file, page, or various other destination. An deal with can it is in a URL (Web address) or a UNC course (network address), and also can incorporate a certain location in ~ a file, such as a word bookmark or one Excel cell range.

Alternate startup folder

A folder in addition to the XLStart folder that consists of workbooks or other documents that you desire to be opened automatically when you begin Excel and templates the you want to be easily accessible when girlfriend create brand-new workbooks.

Alternate startup folder

A folder in enhancement to the XLStart folder that includes workbooks or other papers that you want to it is in opened instantly when you begin Excel and also templates the you want to be easily accessible when friend create new workbooks.

Argument

The worths that a function uses to carry out operations or calculations. The kind of argument a function uses is particular to the function. Common arguments that are used within functions include numbers, text, cabinet references, and also names.

Array

Used come build solitary formulas that produce multiple results or that run on a group of arguments that are arranged in rows and columns. One array range shares a usual formula; one array consistent is a group of constants provided as an argument.

Array formula

A formula the performs many calculations top top one or much more sets the values, and then returns one of two people a single an outcome or lot of results. Array formulas room enclosed between braces and also are gone into by pushing CTRL+SHIFT+ENTER.

Associated PivotTable

The PivotTable that supplies the source data to the PivotChart. It is created immediately when you produce a brand-new PivotChart. Once you readjust the layout of either report, the other also changes.

Autoformat

A built-in collection that cell formats (such as font size, patterns, and also alignment) that you can use to a range of data. Excel determines the level of an overview and detail in the selected selection and applies the styles accordingly.

Axis

A line bordering the chart plot area offered as a frame of reference for measurement. The y axis is usually the vertical axis and contains data. The x-axis is generally the horizontal axis and also contains categories.

B

peak of web page

Base address

The loved one path that Excel provides for the destination attend to when friend insert a hyperlink. This have the right to be one Internet address (URL), a path to a folder ~ above your hard drive, or a route to a folder on a network.

Border

A decorative heat that can be used to worksheet cell or objects, such as charts, pictures, or text boxes. Borders distinguish, emphasize, or team items.

C

top of page

Calculated column

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

Calculated field (database)

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

Calculated ar (PivotTable)

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

Calculated item

An item within a PivotTable field or PivotChart field that supplies a formula you create. Calculate items can perform calculations by making use of the materials of various other items in ~ the same field of the PivotTable or PivotChart.

Category axis

A chart axis the represents the classification for every data point. It displays arbitrary message values like Qtr1, Qtr2, and Qtr3; the cannot screen scaled numerical values.

Category field

A field that"s presented in the category area that the PivotChart. Items in a group field show up as the brand on the classification axis.

Cell

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

Cell reference

The collection of collaborates that a cell occupies on a worksheet. For example, the reference of the cabinet that shows up at the intersection of pillar B and also row 3 is B3.

Certifying authority

A advertisement organization, or a team within a company, that uses tools such together hunterriverpei.com Certificate Server to administer digital certificates that software developers can use to authorize macros and also users deserve to use to sign documents.

Change history

In a mutual workbook, information that is maintained about changes do in past modifying sessions. The information contains the surname of the human who made every change, as soon as the readjust was made, and what data to be changed.

Chart area

The whole chart and also all the elements.

Chart sheet

A paper in a workbook that consists of only a chart. A chart sheet is useful when you desire to view a chart or a PivotChart separately from worksheet data or a PivotTable.

Column field

A field that"s assigned a column orientation in a PivotTable. Items connected with a column field are displayed as tower labels.

Column heading

The shaded area in ~ the optimal of every Data pane tower that contains the field name.

Column heading

The lettered or numbered gray area in ~ the peak of each column. Click the obelisk heading to select an entire column. To increase or diminish the width of a column, traction the heat to the appropriate of the pillar heading.

Comparison criteria

A collection of search conditions that is supplied to uncover data. To compare criteria have the right to be a collection of personalities that you desire to match, such together "Northwind Traders," or an expression, such together ">300."

Comparison operator

A sign that is provided in comparison criteria come compare two values. The six standards are = equal to, > better than, = better than or same to, no equal to.

Conditional format

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

Consolidation table

The table of linked results that shows up in the location area. Excel create the consolidation table by using the summary role that you pick to the source area worths that girlfriend specify.

Constant

A worth that is not calculated. Because that example, the number 210 and also the message "Quarterly Earnings" are constants. An expression, or a value resulting indigenous an expression, is no a constant.

Constraints

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

Copy area

The cells that you copy as soon as you want to paste data into an additional location. After girlfriend copy cells, a moving border shows up around lock to indicate that they"ve been copied.

Criteria

Conditions girlfriend specify to border which records are included in the result set the a query. For example, the following criterion selects records for i beg your pardon the value for the stimulate Amount ar is higher than 30,000: stimulate Amount > 30000.

Criteria pane

The area of the window that display screens the criteria offered to limit the records included in the result set of her query.

Current region

The block of filled-in cells that consists of the currently selected cell or cells. The an ar extends in every directions to the an initial empty heat or column.

Custom calculation

A method of summarizing values in the data area that a PivotTable by using the worths in other cells in the data area. Usage the present data as list ~ above the PivotTable field dialog because that a data field to create custom calculations.

D

height of web page

Data form

A dialog crate that screens one complete record at a time. You have the right to use data creates to add, change, locate, and delete records.

Data label

A label that provides extr information around a data marker, which to represent a single data allude or value that originates indigenous a datasheet cell.

Data marker

A bar, area, dot, slice, or other symbol in a chart the represents a solitary data allude or worth that originates native a datasheet cell. Connected data mite in a graph constitute a data series.

Data pane

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

Data points

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

Data region

A variety of cell that contains data and that is bounded by north cells or datasheet borders.

Data series

Related data points that room plotted in a chart and also originate indigenous datasheet rows or columns. Every data series in a chart has a unique shade or pattern. You deserve to plot one or more data collection in a chart. Pie charts have only one data series.

Data source

A stored collection of "source" information used to affix to a database. A data resource can encompass the name and location that the database server, the surname of the database driver, and information the the database needs when you log on.

Data source driver

A program paper used to affix to a specific database. Each database routine or monitoring system requires a different driver.

Data table

A range of cells that reflects the outcomes of substituting different values in one or more formulas. There space two species of data tables: one-input tables and two-input tables.

Data table in charts

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

Data validation

An Excel feature that you deserve to use to define restrictions on what data can or need to be gotten in in a cell, and to display screen messages that prompt individuals for exactly entries and notify users about incorrect entries.

Database

A collection of data concerned a particular subject or purpose. In ~ a database, information about a specific entity, such as an employee or order, is categorized into tables, records, and fields.

DDE conversation

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

Default startup workbook

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

Default workbook template

The Book.xlt template that you produce to adjust the default layout of new workbooks. Excel uses the template to develop a blank workbook as soon as you begin Excel or develop a brand-new workbook there is no specifying a template.

Default worksheet template

The Sheet.xlt layout that you create to change the default format of new worksheets. Excel provides the theme to create a empty worksheet when you include a new worksheet to a workbook.

Dependents

Cells the contain formulas that refer to other cells. For example, if cell D10 consists of the formula =B5, cabinet D10 is a dependent of cabinet B5.

Destination area

The range of cells that you pick to organize the summarized data in a consolidation. The destination area have the right to be ~ above the very same worksheet as the source data or ~ above a different worksheet. A worksheet can contain just one consolidation.

Detail data

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

Drop lines

In line and also area charts, lines that expand from a data allude to the classification (x) axis. Helpful in area charts to clarify whereby one data marker ends and the next begins.

Drop-down perform box

A control on a menu, toolbar, or dialog crate that display screens a perform of alternatives when you click the little arrow beside the list box.

E

top of page

Embedded chart

A chart that is placed on a worksheet fairly than on a different chart sheet. Embedded charts are helpful when you desire to view or print a chart or a PivotChart v its source data or other info in a worksheet.

Error bars

Usually used in statistics or clinical data, error bars show potential error or level of uncertainty relative to every data mite in a series.

Excel add-in

Components that have the right to be installed on your computer to add commands and also functions to Excel. This add-in program are details to Excel. Other add-in programs that are accessible for Excel or Office space Component Object model (COM) add-ins.

Excel table

Formerly recognized as an Excel list, you deserve to create, format, and expand an Excel table to organize the data on her worksheet.

Expression

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

External data

Data that is stored in a database, such as Access, dBASE, or SQL Server, the is different from Query and also the routine from i beg your pardon you started Query.

External data

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

External data range

A range of data that is carried into a worksheet however that originates external of Excel, such as in a database or text file. In Excel, girlfriend can style the data or usage it in calculations as you would any type of other data.

External reference

A reference to a cabinet or selection on a sheet in one more Excel workbook, or a referral to a characterized name in another workbook.

F

height of page

Field (database)

A classification of information, such as last name or bespeak amount, that is save in a table. When Query display screens a result set in that Data pane, a ar is represented as a column.

Field (PivotTable)

In a PivotTable or PivotChart, a classification 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 little black square in the lower-right corner of the selection. Once you suggest to the to fill handle, the pointer alters to a black color cross.

Filter

To screen only the rows in a perform that meet the conditions you specify. You use the AutoFilter command to screen rows that complement one or an ext specific values, calculation values, or conditions.

Font

A graphic design applied to all numerals, symbols, and alphabetic characters. Likewise called type or typeface. Arial and also Courier new are instances of fonts. Fonts commonly come in different sizes, such as 10 point, and various styles, such together bold.

Formula

A succession of values, cabinet references, names, functions, or operators in a cell the together produce a new value. A formula constantly begins with an equal sign (=).

Formula bar

A bar at the height of the Excel window that you use to get in or modify values or formulas in cells or charts. Display screens the consistent value or formula save in the energetic cell.

Formula Palette

A tool that helps you produce or edit a formula and likewise provides information around functions and their arguments.

Function (hunterriverpei.com Query)

An expression the returns a value based on the results of a calculation. Ask assumes that data resources hunterriverpei.com the Avg, Count, Max, Min, and also Sum functions. Some data sources may not hunterriverpei.com all of these, or might hunterriverpei.com extr functions.

Function (Office Excel)

A prewritten formula that takes a worth or values, performs one operation, and also returns a worth or values. Use features to simplify and shorten recipe on a worksheet, particularly those that perform lengthy or facility calculations.

G

optimal of page

Goal seek

A technique to find a certain value because that a cabinet by adjusting the worth of one other cell. Once goal seeking, Excel different the worth in a cell the you specify until a formula that"s dependence on that cell returns the result you want.

Grid

A set of intersecting lines offered to align objects.

Gridlines in charts

Lines girlfriend can include to a chart that make it less complicated to view and evaluate data. Gridlines prolong from the tick marks on an axis across the plot area.

Group

In an overview or PivotTable, one or more detail rows or columns the are surrounding and low grade to a summary row or column.

H

top of page

High-low lines

In 2-D line charts, currently that expand from the greatest to the lowest worth in each category. High-low currently are regularly used in share charts.

History worksheet

A separate worksheet that lists transforms being tracked in a shared workbook, including the name of the person who do the change, when and where it to be made, what data was turned off or replaced, and also how disputes were resolved.

I

optimal of web page

Identifier

A field name supplied in one expression. For example, order Amount is the id (field name) because that a field that has order amounts. You have the right to use an expression (such as Price*Quantity) in location of an identifier.

Implicit intersection

A referral to a selection of cells, rather of a solitary cell, the is calculated choose a solitary cell. If cabinet C10 includes the formula =B5:B15*5, Excel multiplies the worth in cabinet B10 by 5 since cells B10 and also C10 space in the exact same row.

Index

A database ingredient that increases searching for data. Once a table has actually an index, data in the table can be uncovered by feather it up in the index.

Inner join

In Query, default form of join in between two tables where only the documents that have actually the exact same values in the joined fields are selected. The two corresponding records from each table are linked and displayed as one record in the an outcome set.

Input cell

The cabinet in which every input worth from a data table is substituted. Any kind of cell ~ above a worksheet can be the input cell. Back the input cabinet does not have to be component of the data table, the formulas in data tables have to refer to the input cell.

Insert row

In an Excel table, a unique row that facilitates data entry. The Insert heat is shown by an asterisk.

Internet Explorer

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

Item

A subcategory of a field in PivotTables and also PivotCharts. Because that instance, the field "Month" can have item such together "January," "February," and also so on.

Iteration

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

J

height of web page

Join

A connection in between multiple tables where records from related fields that complement are combined and shown as one record. Records that don"t match may be contained or excluded, depending upon the type of join.

Join line

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

Join line

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

Justify

To change horizontal spacing therefore that text is aligned evenly along both the left and right margins. Justifying message creates a smooth sheet on both sides.

L

peak of web page

Legend

A box that identify the trends or colour that room assigned come the data series or category in a chart.

Legend keys

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

Locked field or record

The problem of a record, field, or other object in a database the permits the to be viewed yet not changed (read-only) in Query.

M

peak of web page

Mapped range

A range in one XML list that has actually been attached to an element in an XML map.

Matrix

A rectangular array of worths or a range of cells the is an unified with other arrays or arrays to create multiple sums or products. Excel has predefined matrix features that can develop the sums or products.

Merged cell

A single cell that is developed by combining two or more selected cells. The cell reference for a merged cell is the upper-left cell in the initial selected range.

Microsoft Excel control

A aboriginal Excel manage other than an ActiveX control.

Microsoft Visual an easy Help

To get assist for Visual simple in Excel, ~ above the Developer tab, in the Code group, click Visual Basic, and then under the Help menu, click hunterriverpei.com Visual an easy Help.

Moving average

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

Moving border

An man border that shows up around a worksheet variety that has been cut or copied. To cancel a relocating border, press ESC.

Multiple-level group labels

Category brand in a chart that, based on worksheet data, are instantly displayed on an ext than one line in a hierarchy. For example, the heading Produce could appear over a row with headings Tofu, Apples, and also Pears.

N

height of page

Name

A native or wire of characters that to represent a cell, variety of cells, formula, or continuous value. Use easy-to-understand names, such together Products, come refer to difficult to understand ranges, such as Sales!C20:C30.

Name box

Box at left finish of the formula bar the identifies the selected cell, chart item, or drawing object. To name a cell or range, form the name in the surname box and press ENTER. To relocate to and also select a called cell, click its surname in the surname box.

Nonadjacent selection

A an option of two or an ext cells or arrays that don"t touch each other. Once plotting nonadjacent selections in a chart, make certain that the merged selections form a rectangular shape.

Non-OLAP source data

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

O

optimal of web page

ObjectLink

An OLE data layout that explains a attached object, identify the class, document name, and name of an object. Every of this data items is a null-terminated string.

Offline cube file

A file you produce on your tough disk or a network re-publishing to save OLAP resource data because that a PivotTable or PivotChart. Offline cube files permit you to keep working once you are not associated to the OLAP server.

OLAP

A database technology that has been optimized for querying and reporting, rather of processing transactions. OLAP data is arranged hierarchically and stored in cubes instead of tables.

OLAP provider

A collection of software application that provides access to a particular form of OLAP database. This software program can include a data source driver and also other customer software the is necessary to attach to a database.

Operand

Items top top either next of one operator in a formula. In Excel, operands have the right to be values, cabinet references, names, labels, and also functions.

Operator

A sign or prize that states the type of calculation to perform within one expression. There room mathematical, comparison, logical, and reference operators.

Outer join

In Query, a sign up with where all records from one table are selected, even if there are no equivalent records in an additional table. Documents that complement are combined and presented as one. Documents that don"t have actually matches in the various other table are shown empty.

Outer join

Join in i m sorry all documents from one table room selected, even if there are no corresponding records in an additional table. Records that match are merged and presented as one. Documents that don"t have actually matches in the other table are displayed as empty.

Outline

Worksheet data in which rows or columns of information data room grouped so that you can create summary reports. The outline have the right to summarize either whole worksheet or a selected section of it.

Outline data

The data that is contained within a worksheet outline. Rundown data includes both the an introduction and information rows or columns of an outline.

Outline symbols

Symbols the you usage to adjust the view of an outlined worksheet. Friend can show or hide thorough data by pushing the plus sign, minus sign, and also the numbers 1, 2, 3, or 4, denote the overview level.

OwnerLink

An OLE data layout that describes an installed object, identifying the class, document name, and name of one object. Every of these data items is a null-terminated string.

P

optimal of page

Page break

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

Page break preview

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

Parameter

In Excel, you deserve to add, change, or remove parameters come specify cell that are editable in the viewable worksheet data the Excel Services. As soon as you conserve the workbook, the alters are automatically reflected ~ above the server.

Parameter query

A kind of questions that, once you run it, prompts for worths (criteria) to use to pick the records for the result set so that the very same query deserve to be provided to retrieve different an outcome sets.

Password

A means to safeguard your worksheet or workbook. Once you defend worksheet or workbook elements with a password, that is an extremely important the you remember that password. Without it, over there is no method to unprotect the workbook or worksheet. You should always use solid passwords that integrate uppercase and also lowercase letters, numbers, and also symbols. Weak passwords don"t mix this elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you deserve to remember so the you don"t need to write it down.

Paste area

The target destination for data that"s been cut or replicated by making use of the Office Clipboard.

Pivot area

The worksheet area into which you drag PivotTable or PivotChart areas to adjust the layout the the report. On a new report, dashed blue outlines show the pivot area on the worksheet.

PivotChart group field

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

PivotChart

A graph that gives interactive analysis of data, like a PivotTable. Friend can change views that data, see different levels of detail, or reorganize the graph layout by dragging fields and by reflecting or hiding items in fields.

PivotChart series field

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

PivotTable data

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

PivotTable grand totals

Total values for every cells in a row or all cells in a column of a PivotTable. Worths in a grand complete row or column are calculated by making use of the very same summary duty used in the data area the the PivotTable.

PivotTable list

A hunterriverpei.com Office web Component that permits you to create a structure similar to one Excel PivotTable. Users can view the PivotTable perform in a Web browser and change its layout in a manner comparable to an Excel PivotTable.

PivotTable

An interactive, cross-tabulated Excel report that summarizes and also analyzes data, such as database records, from miscellaneous sources consisting of ones exterior to Excel.

PivotTable subtotal

A row or column that provides a summary duty to display screen the total of detail items in a PivotTable field.

Plot area

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

Point

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

Precedents

Cells that are described by a formula in an additional cell. For example, if cabinet D10 contains the formula =B5, cabinet B5 is a precedent to cabinet D10.

Primary key

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

Print area

One or more ranges the cells that you designate come print once you don"t desire to publish the whole worksheet. If a worksheet contains a print area, just the print area is printed.

Print titles

Row or column labels that are published at the peak of or ~ above the left next of every page on a published worksheet.

Property fields

Independent attributes associated with items, or members, in one OLAP cube. For example, if city items have actually size and population properties save on computer in the server cube, a PivotTable can display screen the dimension and population of every city.

Protect

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

Q

height of web page

Query

In query or Access, a means of recognize the documents that prize a certain question girlfriend ask about the data save in a database.

Query channel

You usage a query channel in a DDE conversation between the destination application and a specific query (for example, Query1) in Query. To use a ask channel, you should have currently opened the query home window using a mechanism channel.

Query design

All facets included in the query window, such as tables, criteria, the bespeak in which areas are arranged, and also so on. The design likewise specifies even if it is Auto questions is turned on, and also whether you can edit the resource data.

R

top of web page

Range

Two or more cells top top a sheet. The cell in a range can be surrounding or nonadjacent.

Read-only

A setting that allows a document to be check out or copied but not adjusted or saved.

Record

A repertoire of information around a details person, place, event, or thing. When Query displays a an outcome set in the Data pane, a document is stood for as a row.

Refresh (external data range)

To update data native an external data source. Each time girlfriend refresh data, you watch the many recent version of the info in the database, including any kind of changes that were made come the data.

Refresh (PivotTable)

To upgrade the contents of a PivotTable or PivotChart to reflect alters to the underlying source data. If the report is based upon external data, refreshing operation the underlying query to retrieve new or adjusted data.

Regression analysis

A kind of statistical analysis used for forecasting. Regression analysis estimates the relationship in between variables so that a provided variable have the right to be predicted indigenous one or an ext other variables.

Relative reference

In a formula, the address of a cell based upon the relative position of the cell that includes the formula and the cell referred to. If girlfriend copy the formula, the reference immediately adjusts. A relative recommendation takes the form A1.

Remote reference

A referral to data stored in a file from another program.

Report filter

A ar that"s used to filter a subset of data in a PivotTable or PivotChart right into one page for more layout and also analysis. You have the right to either display a an introduction of every items in a report filter, or display one item at a time, i beg your pardon filters out the data for all various other items.

Report template

An Excel theme (.xlt file) that consists of one or an ext queries or PivotTables that are based on external data. When you conserve a report template, Excel conserves the query an interpretation but doesn"t save 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 that a questions in Query, or you have the right to return a result set come an Excel worksheet for additional analysis.

Row heading

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

Row label

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

R-squared value

A number from 0 come 1 the reveals how very closely the approximated values for the trendline exchange mail to your actual data. A trendline is many reliable when its R-squared worth is in ~ or close to 1. Additionally known as the coefficient of determination.

S

peak of page

Scenario

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

Scroll lock

With role lock turn on, the arrow keys scroll the energetic sheet rather than make a various cell active. To turn scroll lock off or on, press the scroll LOCK key.

Section

Any combination of a worksheet, view, and scenario that you pick when you produce a report. A report have the right to contain several sections.

Select

To highlight a cabinet or selection of cells on a worksheet. The selected cells will be impacted by the following command or action.

Select all button

The gray rectangle in the upper-left corner of a datasheet whereby the row and column headings meet. Click this button to select all cell on a datasheet.

Series axis

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

Series field

A field that"s shown in the series area of a PivotChart. Items in a collection field are provided in the legend and administer the names of the separation, personal, instance data series.

Series lines

In 2-D stack bar and also column charts, lines that affix the data markers in every data series that are provided to emphasize the difference in measurement in between each series.

Shared workbook

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

Single-mapped cell

A cell that has been attached to a non-repeating facet in one XML map.

Sort order

A means to kinds data based on value or data type. You have the right to sort data alphabetically, numerically, or through date. Sort orders usage an ascending (1 to 9, A come Z) or diminish (9 to 1, Z to A) order.

Source areas

The cell arrays that friend consolidate in the location area friend specify. Source areas deserve to be on any worksheet in a workbook, in other open up or closeup of the door workbooks, or ~ above Lotus 1-2-3 worksheets.

Source data

The perform or table that"s used to develop a PivotTable or PivotChart. Source data can be taken from an Excel table or range, an exterior database or cube, or an additional PivotTable.

SQL

A language provided to retrieve, update, and manage data. Once you produce a query, Query uses SQL to construct the corresponding SQL select statement. If you know SQL, you can view or change the SQL select statement.

Standard font

The default message font for worksheets. The typical font determines the default font because that the normal cell style.

Summary data

For automatic subtotals and also worksheet outlines, every rows or columns that summarize information data. An overview data normally is adjacent to and also below the information data.

Summary function

A kind of calculation the combines resource data in a PivotTable or a consolidation table, or once you room inserting automatically subtotals in a list or database. Instances of review functions encompass Sum, Count, and Average.

System channel

Used in a DDE conversation in between applications to get information about the system, such together the current connections, open up queries, and also the status of the destination application.

T

optimal of web page

Table pane

The area that the Query home window that screens the tables in a query. Every table displays the fields from which you deserve to retrieve data.

Template

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

Text box

A rectangle-shaped object ~ above a worksheet or chart, in which friend can kind text.

Tick marks and also tick-mark labels

Tick clues are little lines that measurement, comparable to divisions on a ruler, that crossing an axis. Tick-mark labels recognize the categories, values, or collection in the chart.

Titles in charts

Descriptive text that is immediately aligned come an axis or centered at the height of a chart.

Total row

A one-of-a-kind row in one Excel table that offers a choice of aggregate functions advantageous for working with numerical data.

Totals

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

Tracer arrows

Arrows that display the relationship in between the energetic cell and its connected cells. Tracer arrows are blue when pointing from a cabinet that gives data to an additional cell, and also red if a cell consists of an error value, such as #DIV/0!.

Trendline

A graphic representation of patterns in data series, such together a line sloping upward to represent raised sales end a period of months. Trendlines are provided for the study of problems of prediction, additionally 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 cannot be sized.

U

peak of web page

Up-down bars

In heat charts with multiple data series, bars that indicate the difference between data points in the an initial and last series.

V

optimal of web page

Value

The text, date, number, or reasonable input the completes a problem that a ar must satisfy for looking or filtering. Because that example, the field author with the problem equals must incorporate a value, such as John, to it is in complete.

Value axis

A chart axis that display screens scaled numerical values.

Value field

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

Values area

The part of a PivotTable that contains an overview data. Values in each cell the the worths area represent a review of data from the resource records or rows.

Vertexes

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

Vertexes

Black, square, draggable point out that show up at the ends and intersections of lines or curves in certain AutoShapes, such as freeforms, scribbles, and also curves.

View

A set of display and print settings that you have the right to name and also apply to a workbook. You can create an ext than one view of the very same workbook without conserving separate duplicates of the workbook.

W

optimal of page

Web query

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

What-if analysis

A process of an altering the values in cell to see just how those changes influence the result of formulas on the worksheet. Because that example, differing the interest rate that is provided in an amortization table to identify the lot of the payments.

Workbook

A spreadsheet program file that you develop in Excel. A workbook includes worksheets that rows and columns in which you have the right to enter and calculate data.

Worksheet

The primary document that you use in Excel come store and also work with data. Additionally called a spreadsheet. A worksheet is composed of cells that room organized into columns and also rows; a worksheet is always stored in a workbook.

Workspace file

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

World wide Web

A device for navigating the net or through a arsenal of workbooks and also other Office documents associated by hyperlinks and also located ~ above a network share, a company intranet or the Internet. Once you use a web browser, the Web appears as a arsenal of text, pictures, sounds, and also digital movies.

Wrap

In text, to rest a heat of text automatically on getting to a margin or object and continue the message on a brand-new line.

See more: What Style Of Jazz Music Most Influenced The Beat Poets? ? Jazz Breath: How Jazz Influenced Beat Poetics

X

optimal of page

XML

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