| absolute cell address | "Cell reference in a worksheet that does not adjust when copied to other cells. You make a cell address absolute by placing dollar signs ($) before the column letter and row number, such as $C$4."
|
 |
|
|
| ActiveX controls | "Re-usable program components or objects that provide some functionality; for example, calendar applications, Internet connectivity, and interface elements."
|
|
|
|
| adaptive menus | The dynamic menu bars and toolbars that are personalized to the way you work. Office XP watches the tasks that you perform in an application and then displays only those commands and buttons that you use most often.
|
|
|
|
| advanced criteria filter | A filtering command and process that uses conditions stored in a criteria range to limit the display of records in a list or to extract records to a new location in the same worksheet.
|
|
|
|
| Analysis ToolPak | "An Excel add-in program; provides specialized data analysis tools for performing statistical and engineering analyses. The add-in consists of tools for calculating ANOVA tables, performing Fourier Analysis, and extrapolating regression equations."
|
|
|
|
| annuity | A series of equal cash payments made over a given period of time.
|
|
|
|
| application window | "In Windows, each running application program appears in its own application window. These windows may be sized and moved anywhere on the Windows desktop."
|
|
|
|
| arguments | "The parameters used in entering a function according to its syntax. Arguments may include text, numbers, formulas, functions, and cell references."
|
|
|
|
| array formula | A single formula that produces multiple results or that accommodates a group of arguments in a row or column orientation.
|
|
|
|
| audit | "In Excel, the process of reviewing a workbook, worksheet, range, or cell for incorrect entries, non-conforming values, formula references, and other information."
|
|
|
|
| AutoCalculate | A software feature that sums the selected range of cells and displays the result in the Status bar.
|
|
|
|
| AutoComplete | A software feature that assists you in entering data into a worksheet by filling in letters from existing entries in the column as you type.
|
|
|
|
| AutoCorrect | A software feature that corrects common typing and spelling mistakes automatically as you type. It also enables you to enter complex symbols quickly and easily.
|
|
|
|
| AutoFill | A software feature that enables you to copy and extend a formula or data series automatically in a worksheet.
|
|
|
|
| AutoFilter | "A software feature that makes it quick and easy for you to select, filter, and display records from a worksheet list."
|
|
|
|
| AutoFit | A software feature that calculates the optimal row height or column width based on existing data in the worksheet.
|
|
|
|
| AutoFormat | A software feature that applies professionally designed formatting styles to your documents.
|
|
|
|
| automacro | "A macro that runs automatically when a specific event occurs, such as opening a workbook."
|
|
|
|
| AutoShapes | Ready-made graphic objects that you can add to your worksheet using the Drawing toolbar and then format and customize to suit your needs.
|
|
|
|
| AutoSum | A software feature that automatically inserts a formula for adding values from a surrounding row or column of cells.
|
|
|
|
| AutoTemplates | Special template workbooks that contain the default settings for new workbooks (Book.xlt) and worksheets (Sheet.xlt). These templates are stored in the XLStart folder.
|
|
|
|
| bar chart | A chart that compares one data element to another data element using horizontal bars. Similar to a column chart.
|
|
|
|
| breakpoint | "In VBA code, a user-defined stopping point that interrupts a macro's execution and displays the Visual Basic Editor."
|
|
|
|
| cell | The intersection of a column and a row.
|
|
|
|
| cell address | "The location of a cell on a worksheet given by the intersection of a column and a row. Columns are labeled using letters. Rows are numbered. A cell address combines the column letter with the row number (for example, B9 or DF134.)"
|
|
|
|
| cell alignment | The positioning of data entered into a worksheet cell in relation to the cell borders.
|
|
|
|
| cell layer | "The layer for worksheet cells; this layer holds data, calculated expressions, formatting attributes, and other information."
|
|
|
|
| cell pointer | The cursor on a worksheet that points to a cell. The cell pointer is moved using the arrow keys or the mouse.
|
|
|
|
| cell range | One or more cells in a worksheet that together form a rectangle.
|
|
|
|
| character strings | "Any combination of letters, symbols, and numerals that is not a numerical or date value."
|
|
|
|
| Chart component | A Microsoft Office Web Component; an ActiveX object that provides basic interactive charting capabilities using the Microsoft Internet Explorer Web browser.
|
|
|
|
| chart sheet | "A sheet tab or page within a workbook file that is used to create, modify, and display a chart graphic."
|
|
|
|
| Chart Wizard | A linear step progression of dialog boxes that leads you through creating a chart in Excel.
|
|
|
|
| Clip Organizer | "A shared application in Microsoft Office that lets you manage clip art images, pictures, sounds, animation, and video clips and insert them into a worksheet's draw layer."
|
|
|
|
| Code window | "In the Visual Basic Editor, the window containing the macro procedure code; used for coding and debugging program statements."
|
|
|
|
| coding | Developing and writing code manually from scratch.
|
|
|
|
| collection | Object type that acts as a container for a set of similar objects.
|
|
|
|
| column chart | A chart that compares one data element with another data element and can show variations over a period of time.
|
|
|
|
| COM add-in | "An add-in program, based on the Component Object Model (COM), that is created using Microsoft Office XP or Visual Basic. COM add-in programs can be run in any Office XP application."
|
|
|
|
| comment | "A special text box that is attached to a cell and used to display helpful information. You display a cell's comment by moving the mouse pointer over the cell containing a comment indicator, a small red triangle in the upper-right corner of the cell."
|
|
|
|
| concatenate | "In Excel, joining together characters from separate cells or strings using the ampersand ""&"" operator to form a single cell entry; combining characters to form a string."
|
|
|
|
| conditional formatting | A software feature that gives you the ability to change a cell's formatting based on its contents or based on the results of a formula calculation.
|
|
|
|
| Conditional Sum Wizard | An Excel add-in program; a series of dialog boxes that lead you through summing a worksheet range based on specific conditions being met.
|
|
|
|
| consolidate | "The process of combining smaller worksheet files into a single summary worksheet, making it easier to manage large amounts of data."
|
|
|
|
| constant | "Any number, date, or text value that is entered directly into a cell, as an operand in a formula, or as an argument in a function. An unchanging value that the user cannot adjust or modify. Opposite of a variable."
|
|
|
|
| constraints | Logical conditions or business rules that you define in the Solver add-in program to limit a resource's value or availability.
|
|
|
|
| control structures | "Group of program statements that allows you to make decisions and direct the flow of executed instructions; two common control structures are ""branching"" and ""looping."""
|
|
|
|
| Control Toolbox | A special type of toolbar that contains ActiveX controls that you may add to your worksheet or custom user forms.
|
|
|
|
| criteria form | A special dialog box that displays an empty data form that you use to enter search criteria. You can use the criteria form to find records.
|
|
|
|
| criteria range | "The worksheet range used in an advanced criteria filter, or as an argument in a database function, for inputting search conditions. The first row always contains the criteria header row--select fields from the field header row. The rows beneath the criteria header contain the conditions that match entries or evaluate to true and false."
|
|
|
|
| custom add-in | "An application-specific add-in program containing macro procedures and other VBA code that you may hide, protect, and distribute for use with your workbook applications."
|
|
|
|
| custom format | A combination of formatting codes that when placed in a particular sequence enhance the display of numeric and date values. You construct and store custom formats on the Number tab of the Format Cells dialog box.
|
|
|
|
| custom view | A combination of print and display settings that are named and stored with the workbook in which they were created.
|
|
|
|
| data form | "A special dialog box that displays one record at a time from the active worksheet list. You can use the data form to add, modify, and delete a record."
|
|
|
|
| data validation | "A term used to describe the process of evaluating data once it has been entered into a software program. Using a set of rules, which may contain a range of acceptable values, the evaluation results in either the entry being accepted or rejected."
|
|
|
|
| debugging | A programming term that means locating errors in your VBA code and correcting those errors.
|
|
|
|
| delimiter | "A symbol or character, such as a tab or quotation mark, that is used to separate fields or columns of information in a text file."
|
|
|
|
| dependent variable | "A worksheet value that is used in testing for a hypothesized relationship with another worksheet value called the independent variable. Having proven a relationship exists, you can use regression analysis to forecast the value of a dependent variable for a given independent variable. "
|
|
|
|
| design time | The period during which a program is created or modified in the Visual Basic Editor or ActiveX controls are added to a worksheet.
|
|
|
|
| document window | "In Excel, each open workbook appears in its own document window. These windows may be sized and moved anywhere within the application window."
|
|
|
|
| drag and drop | A software feature that allows you to copy and move information by dragging information from one location to another using the mouse.
|
|
|
|
| draw layer | The invisible surface that exists above the cell layer and holds inserted or embedded graphic objects and charts.
|
|
|
|
| dynamic cell range | A named range that uses the INDEX and COUNTA functions to expand and contract the referenced area automatically as information is entered or removed.
|
|
|
|
| embedded chart | A chart that is placed on the draw layer of a worksheet.
|
|
|
|
| embedding | A way of sharing data and exchanging information; refers to the process of inserting an object into a destination document.
|
|
|
|
| event | "An action or reaction that occurs in Windows programming. You can code unique responses to events, such as performing a procedure whenever a button is clicked."
|
|
|
|
| event-driven programming | "Coding a program to respond to events that may occur, such as clicking a button; uses objects, properties, and methods to describe elements, attributes, and actions."
|
|
|
|
| Extensible Markup Language (XML) | "A standardized meta-markup language used for defining, maintaining, and exchanging structured data using Web-based documents. Microsoft provides an XML Spreadsheet schema specification that defines a special XML file format for storing and manipulating workbook data."
|
|
|
|
| field | "A piece of information in a record, such as a person's last name in a phone book listing. In Excel, a field is represented by a column in the worksheet list."
|
|
|
|
| field buttons | "In working with PivotTables and PivotCharts, the buttons (taken from the column or field headings in the data source) that represent the data stored in a particular field."
|
|
|
|
| field header row | "The top row in a worksheet list that contains the field names or column headings; describes the contents of each column. The field header row is usually row 1, but not necessarily so."
|
|
|
|
| fill handle | The small black square that is located in the bottom right-hand corner of a cell or cell range. You use the fill handle to create a series or to copy cell information.
|
|
|
|
| filter | The process or method of temporarily restricting the display of records in a worksheet list to those that match a particular search specification.
|
|
|
|
| flat-file database | "A two-dimensional, stand-alone database that is comprised of rows and columns. Excel provides flat-file database capabilities through the use of worksheet lists."
|
|
|
|
| font(s) | "All the characters of one size in a particular typeface; includes numbers, punctuation marks, and upper- and lowercase letters."
|
|
|
|
| footer(s) | Descriptive information (such as page number and date) that appears at the bottom of each page of a document.
|
|
|
|
| Format Painter | A software feature that enables you to copy only the formatting attributes and styles from one location to another.
|
|
|
|
| formula | A mathematical expression that typically defines the relationships among various cells in a worksheet or table.
|
|
|
|
| Function procedure | "In VBA, a procedure that typically performs a calculation and returns a value to the calling program."
|
|
|
|
| functions | Built-in shortcuts that can be used in formulas to perform calculations.
|
|
|
|
| future value | The value in future dollars of a series of equal cash payments.
|
|
|
|
| goal seeking | The process of stating a desired outcome and then working backwards to solve the input values necessary to produce the outcome.
|
|
|
|
| graphic file | "A computer graphic, created by an artist or scanned from an existing picture, that you can insert into your worksheets."
|
|
|
|
| gridlines | The lines on a worksheet that assist the user in lining up the cell pointer with a particular column letter or row number.
|
|
|
|
| Group mode | "In Excel, a special mode for working with multiple-sheet workbooks; enables you to perform commands on a single sheet and have those commands reflected in all other sheets in the file."
|
|
|
|
| hard-coded | "A formula or module that contains a constant value rather than using a cell reference, range name, or implicit intersection (as in natural language formulas.)"
|
|
|
|
| header(s) | Descriptive information (such as page number and data) that appears at the top of each page of a document.
|
|
|
|
| HTML | "An acronym for Hypertext Markup Language, which is the standardized markup language used in creating documents for display on the World Wide Web."
|
|
|
|
| HTML round-tripping | "The back and forth publishing and editing of content between Office XP applications and the Microsoft Internet Explorer Web browser. After creating and saving a workbook as an interactive Web page using the Spreadsheet component, the process of editing and then exporting the spreadsheet from Internet Explorer back to Excel for further editing."
|
|
|
|
| hyperlinks | "In terms of Internet technologies, a text string or graphics that when clicked take you to another location, either within the same document or to a separate document stored on your computer, an intranet resource, or onto the Internet."
|
|
|
|
| in-cell editing | "In Excel, the feature that enables you to revise text labels, numbers, dates, and other entries directly within a cell. To activate in-cell editing, you double-click a cell."
|
|
|
|
| independent variable | "A worksheet value that is used in testing for a hypothesized relationship with another worksheet value called the dependent variable. Having proven a relationship exists, you can use regression analysis to forecast the value of a dependent variable for a given independent variable. "
|
|
|
|
| input cells | Worksheet cells in which you store dynamic and variable data; input cells contain the values that are referenced by outcome formulas in a worksheet model.
|
|
|
|
| integer value | "The value of a number to the left of the decimal point. For example, the integer of 123.987 is 123."
|
|
|
|
| Internet | "A worldwide network of computer networks that are interconnected by standard telephone lines, fiber optics, and satellites."
|
|
|
|
| intranet | A private local or wide area network that uses Internet protocols and technologies to share information within an institution or corporation.
|
|
|
|
| keyword | "A reserved word that holds special meaning for the VBA compiler and, therefore, cannot be used as a variable or constant name."
|
|
|
|
| legend | A key for deciphering the data series appearing in the plot area of a chart.
|
|
|
|
| line chart | A chart that plots trends or shows changes over a period of time.
|
|
|
|
| linking | A way of sharing data and exchanging information; refers to the process of copying data from a source document into a destination document and establishing a dynamic link between the two.
|
|
|
|
| list | A worksheet range containing column headings as fields and row entries as records. A worksheet list is useful for storing and manipulating large amounts of data.
|
|
|
|
| lookup formula | "A formula expression that uses one of Excel's built-in lookup functions (LOOKUP, VLOOKUP, HLOOKUP, MATCH, or INDEX) to retrieve a value from a lookup table."
|
|
|
|
| lookup table | "A worksheet range, bounded by row and column labels, that you can use to look up information in a table format."
|
|
|
|
| Macro Recorder | "A special tool that you use to record, translate, and store keystrokes as VBA code in a programming module."
|
|
|
|
| macros | Programs that you create to automate repetitive procedures.
|
|
|
|
| macro virus | A malicious program that attaches itself to a document or template and performs instructions that may damage files on your computer.
|
|
|
|
| margins | "Space between the edge of the paper and the top, bottom, left, and right edges of the printed document."
|
|
|
|
| method | "The actions that can be performed on or by an object, such as activate, open, and close."
|
|
|
|
| Microsoft Map | A shared application in Microsoft Office that enables you to create and plot an embedded map from geographic data stored in a worksheet.
|
|
|
|
| Microsoft Office Web Components | Component objects of executable program code that allow you to view and interact with Microsoft Office XP data using the Microsoft Internet Explorer Web browser software.
|
|
|
|
| Microsoft Query | A software program that allows you to develop queries for retrieving data from external database files.
|
|
|
|
| mixed cell address | "Cell reference in a worksheet that includes both relative and absolute cell references. For example, the address C$4 provides a ""relative"" column letter and an ""absolute"" row number."
|
|
|
|
| module | "In the Visual Basic Editor, a module is a container for storing and organizing VBA macros and procedures."
|
|
|
|
| Name box | The text box appearing at the left-hand side of the Formula bar that displays the current cell address and that enables you to navigate quickly to any cell location in the worksheet.
|
|
|
|
| natural language formula | "In Excel, a type of formula that allows you to use the column and row labels within a worksheet in building a mathematical expression."
|
|
|
|
| nesting | "Using a formula or function as an operand or argument in another formula or function; placing a formula within an expression using parentheses, such as (2+3)*4. A formula or function can contain up to seven levels of nested expressions."
|
|
|
|
| Normal view | "In Excel, the standard view mode used for creating a workbook. You can adjust a zoom factor for viewing more or less of a worksheet in this mode."
|
|
|
|
| object model | A conceptual map for the hierarchical chain of objects that are exposed by an application.
|
|
|
|
| objects | "Any type of data , such as a graphic image or WordArt, that has been pasted or embedded into a worksheet."
|
|
|
|
| Office Clipboard | "A program, in Office XP, that allows you to copy and move information within or among Office XP applications. Unlike the Windows Clipboard, the Office Clipboard can store up to 24 items and then paste them all at once."
|
|
|
|
| one-input data table | A worksheet table that displays the results from one or more outcome formulas as a set of values is substituted into a single input cell.
|
|
|
|
| operand | "In Excel, a constant value, range name, or cell address that you use in building formula expressions."
|
|
|
|
| operator | "In Excel, a symbol used to determine what calculations to perform on operands. Excel provides four types of operators-arithmetic, comparison or logical, text, and reference."
|
|
|
|
| order of precedence | The sequential order in which formula expressions are evaluated is determined by the use of parentheses and the operator order of precedence.
|
|
|
|
| outlining | "In Excel, the process of grouping data together on a worksheet in order to hide (collapse) or display (expand) detailed information."
|
|
|
|
| Page Break Preview | "In Excel, the preview mode used prior to printing in order to adjust the print area and page breaks that occur in a workbook."
|
|
|
|
| panes | "When a worksheet window has been divided into separate areas using the Window, Freeze Panes command or the Window, Split command, these areas are called window panes or panes. A worksheet can have a maximum of four panes at any one time."
|
|
|
|
| parsing | "In Excel, dividing a single cell entry or text string across multiple cells; extracting a character or characters from a string. To parse data in Excel, you use functions from the Text category."
|
|
|
|
| password | "A series of characters that you can use as a lock and key to restrict access to a workbook. The best passwords combine letters, numbers, and special symbols, which makes them difficult to guess."
|
|
|
|
| password-protect | The process of restricting access to information using an easily remembered word or group of characters that will prove difficult for others to guess.
|
|
|
|
| Personal Macro Workbook | "A special Excel workbook, stored in the XLStart folder, used for storing macros that you want made available for use in all workbooks."
|
|
|
|
| pie chart | A chart that shows the proportions of individual components compared to the whole.
|
|
|
|
| PivotChart report | "An interactive chart sheet, based on an associated PivotTable report, that summarizes and displays data graphically."
|
|
|
|
| PivotTable and PivotChart Wizard | A series of dialog boxes that lead you through creating a PivotTable report or PivotChart report.
|
|
|
|
| PivotTable component | A Microsoft Office Web Component; an ActiveX object that enables the presentation of an interactive PivotTable list using the Microsoft Internet Explorer Web browser.
|
|
|
|
| PivotTable list | "A PivotTable report that is saved as an interactive Web page, incorporating the Microsoft Office Web Components, for display using the Microsoft Internet Explorer Web browser software."
|
|
|
|
| PivotTable report | "An interactive worksheet table that summarizes data stored in a worksheet list or an external data source using Excel's summary functions, such as SUM, AVERAGE, MIN, MAX, and COUNT."
|
|
|
|
| Places bar | The strip of icon buttons appearing in the Open and Save As dialog boxes that allow you to display the most common areas for retrieving and storing files using a single mouse click.
|
|
|
|
| plot area | The area for plotting values in a chart. The plot area contains the axes and data series.
|
|
|
|
| present value | The value in present-day dollars of a series of equal cash payments made sometime in the future.
|
|
|
|
| primary sort key | The field or column used to sort the contents of a worksheet list; also called the primary sort order.
|
|
|
|
| Print Preview | "In Excel, the preview mode used to view a workbook in a full-page WYSIWYG display prior to printing. You can use Print Preview to move through pages, zoom in and out on areas of a worksheet, and adjust page margins and column widths."
|
|
|
|
| print titles | Row and column data that is stored in a worksheet and used to display repeating header information across page breaks for printed output.
|
|
|
|
| program statement | "A line of code combining objects, properties, methods, variables, constants, symbols, and/or other elements to perform a task."
|
|
|
|
| Project Explorer window | "In the Visual Basic Editor, the window that displays the open project files, including workbook objects, modules, and user forms."
|
|
|
|
| project file | "In the Visual Basic Editor, a project file is a container for storing and organizing related or associated workbook, worksheet, and module objects. Each workbook typically has its own project file, as does the Personal Macro Workbook."
|
|
|
|
| Properties window | "In the Visual Basic Editor, the window that displays property settings for the selected object(s); you can change an object's properties at design time using this window."
|
|
|
|
| property | "A characteristic or attribute of an object, such as its name or color."
|
|
|
|
| Property procedure | "In VBA, a procedure that you use to create or apply a user-defined property."
|
|
|
|
| query | A question that you ask of the contents of a worksheet list or database file.
|
|
|
|
| query-by-example (QBE) | The process of querying a worksheet list in a visual mode by specifying criteria in an empty criteria form.
|
|
|
|
| random number | "In Excel, a value between 0 and 1 that results by chance, but with equal probability of any other value between 0 and 1."
|
|
|
|
| random number | "In Excel, a value between 0 and 1 that results by chance, but with equal probability of any other value between 0 and 1."
|
|
|
|
| Range Finder | An Excel feature that color-codes the cell or range references in a formula expression for easy reference and error-checking.
|
|
|
|
| range name | A name that is given to a range of cells in the worksheet. This name can then be used in formulas and functions to refer to the cell range.
|
|
|
|
| read-only | "A mode that you use or specify for opening a workbook. In read-only mode, you can only save changes that you make to a workbook under a new file name. You cannot replace or ""save over"" an existing workbook."
|
|
|
|
| record | "An individual item or entry, such as a person's name, address, and phone number, in a phone book listing. In Excel, a record is represented by a row in the worksheet list."
|
|
|
|
| Redo command | A command that makes it possible to reverse the effects of an Undo command.
|
|
|
|
| regression analysis | The process of calculating an equation that fits a straight line to a set of historical data points; used in forecasting future values based on past results.
|
|
|
|
| relational database | A collection of individual table objects that are related to one another through a common field for the purpose of sharing information and reducing data redundancy. One example of relational database management software is Microsoft Access
|
|
|
|
| relative cell address | Default cell reference in a worksheet that automatically adjusts when copied to other cells.
|
|
|
|
| Report Manager | "An Excel add-in program; used to print a variety of worksheets, custom views, and scenarios as a single report. You can name and store a report's specifications within a workbook."
|
|
|
|
| rounded value | "The value of a number rounded to a specific number of decimal places. For example, the number 2.378 rounded to a single decimal returns the number 2.4."
|
|
|
|
| R-square | "A statistical measure of the extent to which two variables are associated. In statistics, this measure is also referred to as the coefficient of determination."
|
|
|
|
| run time | During program execution; as the program code is being run.
|
|
|
|
| scanner | "A hardware device that converts an existing paper-based image, such as a photograph or drawing, into a computer image that is stored digitally on the disk."
|
|
|
|
| scatter plot chart | A chart that shows how one or more data elements relate to another data element. Also called XY charts.
|
|
|
|
| scenario | "In Excel, a set of assumptions and outcomes that can be saved, documented, and summarized by the Excel Scenario Manager."
|
|
|
|
| scope | "The level of visibility in which a procedure or variable operates. A variable's scope or visibility may be at the procedure-level (private), module-level, or macro-level (public)."
|
|
|
|
| secondary sort key | The field or column used to sort the contents of an already sorted worksheet list; also called the secondary sort order.
|
|
|
|
| series | A sequence of numbers or dates that follows a mathematical or date pattern.
|
|
|
|
| shared workbook | A workbook that you expressly share for use in a workgroup or networked environment; workbooks that allow editing functions to be performed by multiple users simultaneously.
|
|
|
|
| sizing handles | The white boxes or circles that appear around an object that is selected on the draw layer. You use the sizing handles to increase or decrease the size of an object.
|
|
|
|
| smart tags | "An extension of the AutoCorrect feature that attempts to match the contents of a cell with pre-defined “recognizer” keywords. When a match is made, the contents are underlined and the Smart Tag Actions button appears next to the cell. Click the button to perform context sensitive tasks, such as retrieving stock information from the Web given a stock symbol."
|
|
|
|
| Spelling Checker | A shared proofing tool in Microsoft Office XP that you use to check your workbooks for typing errors and spelling mistakes.
|
|
|
|
| Spreadsheet component | A Microsoft Office Web Component; an ActiveX object that provides basic interactive spreadsheet functionality using the Microsoft Internet Explorer Web browser.
|
|
|
|
| style | A set of formatting specifications that are named and stored with the workbook in which they were created.
|
|
|
|
| Sub procedure | "In VBA, the default procedure type that is used to perform a series of instructions and to effect change on its environment."
|
|
|
|
| syntax | "In a workbook, the rules, structure, and order of arguments used in entering a formula or function. In VBA code, the rules that each program statement must follow in order to execute properly."
|
|
|
|
| Task Pane | "A toolbar-like window providing quick access to frequently used commands. By default, the Task Pane appears docked to the right side of the application window, but it may be displayed and hidden using the View menu command."
|
|
|
|
| template | A workbook or document that has been saved to a special file and location so that it may be used again and again as a model for creating new documents.
|
|
|
|
| Text Import Wizard | A series of dialog boxes that lead you through importing and converting a text file to an Excel worksheet.
|
|
|
|
| tracer arrows | "The lines that appear on the worksheet when performing an audit. Blue tracer arrows identify cell relationships, while red tracer arrows show cells producing errors."
|
|
|
|
| tracing dependents | "When performing an audit, the process of identifying formulas that reference a particular cell. The cells containing formulas are known as dependents."
|
|
|
|
| tracing precedents | "When performing an audit, the process of identifying the cells that are used in a formula to calculate a result. The cells containing data are known as precedents."
|
|
|
|
| trendline | "In an Excel chart, a line that overlays a data series in an attempt to show a linear, exponential, or other statistical trend."
|
|
|
|
| two-input data table | A worksheet table that displays the results from a single outcome formula as two sets of values are substituted into two input cells.
|
|
|
|
| typeface(s) | "The shape and appearance of characters. There are two categories of typefaces: serif and sans serif. Serif type (for example, Times Roman) is more decorative and, some say, easier to read than sans serif type (for example, Arial)."
|
|
|
|
| Undo command | A command that makes it possible to reverse up to the last 16 commands or actions performed.
|
|
|
|
| users | The target audience for a workbook application; the people who will be working with the workbook on a daily basis.
|
|
|
|
| variable | A temporary value or storage location in memory for data that can be adjusted and modified.
|
|
|
|
| variant | The default data type in VBA that allows you to store any kind of data.
|
|
|
|
| VB Script | Short for Visual Basic Scripting Edition. A subset of Visual Basic functionality created specifically for programming Web content.
|
|
|
|
| virus | Program that is created with the intention of doing harm to a computer system.
|
|
|
|
| Visual Basic Editor | "A special utility program for creating, editing, and managing VBA macros and procedures. See Visual Basic for Applications (VBA)."
|
|
|
|
| Visual Basic for Applications (VBA) | "A subset of the Microsoft Visual Basic programming language that is shared by Microsoft Office XP applications, including Excel, for developing macros."
|
|
|
|
| Watch Window | A window displayed during the auditing of a worksheet that enables you to view a cell's formula and its calculated result.
|
|
|
|
| Web queries | "A set of instructions stored in a text file that allow you to query and interact with Internet Web servers in real-time; used to gain access to and import ""live"" data from the Web into your local workbooks."
|
|
|
|
| what-if analysis | The process of changing values in a worksheet model in order to observe the results produced by outcome formulas that are directly or indirectly dependent on the values being changed.
|
|
|
|
| wildcard characters | "Special symbols that are used to represent other alphanumeric characters in search and filter operations. In Excel, you can use the ? (question mark) to represent any single character and the * (asterisk) to represent any group of characters."
|
|
|
|
| Windows Clipboard | "A program, in Windows, that allows you to copy and move information within an application or among applications. The system or Windows Clipboard temporarily stores the information in memory before you paste the data in a new location"
|
|
|
|
| wizard | A program or process whereby a series of dialog boxes lead you step-by-step through performing a procedure.
|
|
|
|
| WordArt | A shared application in Microsoft Office that lets you manipulate and apply special effects to text and then insert the text into a worksheet.
|
|
|
|
| workbook | The disk file that contains the worksheets and chart sheets that you create in Excel.
|
|
|
|
| worksheet | "A sheet tab or page within a workbook file that is used to create, modify, and display a worksheet grid of columns and rows."
|
|
|
|
| workspace | "A disk file that stores the names, locations, window positions, and window sizes of open workbooks in the Microsoft Excel 2002 application window."
|
|
|
|
| World Wide Web | "A visual interface to the Internet based on hyperlinks. Using Web browser software, you click on hyperlinks to navigate resources on the Internet."
|
|
|
|
| X-axis | The horizontal or category axis that shows the categories for which the chart is making comparisons.
|
|
|
|
| XML | See Extensible Markup Language (XML).
|
|
|
|
| XY charts | Charts that show how one or more data elements relate to another data element. Also called scatter plot diagrams.
|
|
|
|
| Y-axis | The vertical or value axis in a two-dimensional chart that shows the value or measurement unit for making comparisons among the various categories.
|
2002 McGraw-Hill Higher Education