1.1 Glossary

This document uses the following terms:

AutoFilter: A mechanism that can be used to filter tabular data based on user-defined criteria such as values, strings, and formatting.

conditional formatting: A mechanism that changes the appearance of a user interface element based on the evaluation of a rule or expression.

data consolidation: The process of combining tabular data from various worksheets into a single list.

document: An object in a content database such as a file, folder, list, or site. Each object is identified by a URI.

embedded object: An object that is created by using one application and is hosted in a document that was created by using another application. Embedding an object, rather than inserting or pasting it, ensures that the object retains its original format. Users can double-click an embedded object and edit it with the toolbars and menus from the application that was used to create it. See also Object Linking and Embedding (OLE).

Hypertext Markup Language (HTML): An application of the Standard Generalized Markup Language (SGML) that uses tags to mark elements in a document, as described in [HTML].

locale: A collection of rules and data that are specific to a language and a geographical area. A locale can include information about sorting rules, date and time formatting, numeric and monetary conventions, and character classification.

macro: A set of instructions that are recorded or written, and then typically saved to a file. When a macro is run, all of the instructions are performed automatically.

macro sheet: A single, logical container that is used to store and run Microsoft Excel 4.0 for Windows macro formulas.

page break: A divider that breaks a worksheet into separate pages for printing. Page breaks are inserted automatically based on the paper size, margin settings, scaling options, and the positions of any page breaks that are inserted manually.

page margin: The white space at the top, bottom, and sides of a document when a document is printed.

phonetic information: A series of characters that appear above text in a cell and provide information that helps users pronounce the text.

presentation: A collection of slides that are intended to be viewed by an audience.

protection: A mechanism that helps restrict users from making unwanted changes to the data or structure of a workbook.

range: An addressable region that is in a workbook. A range typically consists of zero or more cells and represents a single, contiguous rectangle of cells on a single sheet.

sheet: A part of an Excel workbook. There are four types of sheets: worksheet, macro sheet, dialog sheet, and chart sheet. Multiple sheets are stored together within a workbook.

sheet view: A collection of display settings, such as which cells are shown, and the zoom level for a sheet window.

sort condition: A condition that determines how to sort cells in a range.

table: A list that is defined in a workbook.

Vector Markup Language (VML): A system of marking up or tagging two-dimensional vector graphics for publication on the World Wide Web. VML graphics are scalable and editable, and typically require less disk space and less time to download.

Visual Basic for Applications (VBA): A macro-based programming language that derives from Microsoft Visual Basic and can be used to customize and extend an application. Unlike Visual Basic, Microsoft Visual Basic for Applications (VBA) code and macros can be run only from within a host application that supports VBA.

workbook: A container for a collection of sheets.

worksheet: A single logical container for a set of tabular data and other objects in a workbook.

XML: The Extensible Markup Language, as described in [XML1.0].

MAY, SHOULD, MUST, SHOULD NOT, MUST NOT: These terms (in all caps) are used as defined in [RFC2119]. All statements of optional behavior use either MAY, SHOULD, or SHOULD NOT.