Key Terms

 <  Day Day Up  >  

Don't let unfamiliar terms discourage you from learning all you can about OpenOffice.org. If you don't completely understand what one of these words means, flip to the indicated page, read the full definition there, and find techniques related to that term .

Absolute reference

A cell reference that does not change if you copy the formula elsewhere. Page 180



Anchor

A Writer placeholder that shows itself as an icon of a boat anchor. 122



Anchor point

One corner of a range of cells ; typically, the upper-left cell in a range is considered the anchor point. 198



Arc

Half an ellipse, such as a half-moon. 127



Arguments

Values appearing inside a function's parentheses that the function uses in some way to produce its result. 205



Ascending

The sort method where lower values are sorted early in the list and higher values fall at the end of the list. 284



AutoCorrect

The ability of OpenOffice.org programs to analyze what you just typed and replace with a corrected version if needed. 143



AutoFilter

A Calc database filter where you select from a list of values to filter by and view. 285



AutoFit

The ability of AutoFormat to keep the original widths and heights of the cells that AutoFormat formats. 229



AutoFormat

The process that Calc uses to format spreadsheets from a collection of predetermined styles. 224



AutoLayout

A predesigned slide layout for Impress presentation slides. 302



AutoPilot

Preformatted guides that help you create personal and business letters and forms more easily than if you began with a blank page. 33



Cell

A row and column intersection in a Writer or Calc table or spreadsheet. 111



Cell reference

The name of the cell, composed of its column and row intersection, such as G14. This is also called the cell address. 162



Conditional formatting

The process of formatting Calc cells automatically, based on the data they contain. 243



Crop

The cutting off of parts of an image or, in the case of Draw images, the scaled shrinking of an image to a smaller size from within the Crop dialog box. 445



Custom sort list

A predefined list of values (such as month names and the days of the week), or a list you define from the Tools, Options, Spreadsheet, Custom Lists option, that determines a special sorting rank that differs from the normal alphabetic or numerical sorts. Page 285



Data range

A range you define that specifies exactly which rows and columns comprise the records and fields of your database. 280



Data series

A single, contiguous group of data that you might select from a column or row to chart. 258



Data validity

A check to determine whether data entered into a cell is valid, defined by a set of criteria that you set up. 267



Database

A collection of data that is often organized in rows and columns to make searching and sorting easy to do. 276



Edit points

This term refers to points on your drawing, represented by small square boxes, that you drag to modify that part of the shape or freeform line. 397



Endnotes

A note at the end of a document referenced by number somewhere in the document. 152



Fill handle

A small black box, at the bottom-right corner of a selected cell or range, that you drag to the right (or down or up) to fill the range of data with values related to the selected range. 204



Footer

Text that appears at the bottom of every page in a section or document. 148



Footnotes

A note at the bottom of a page referenced by a number somewhere on the page. 152



Formulas

Equations composed of numeric values and often cell addresses and range names that produce a mathematical result. 177



Functions

Built-in mathematical and logical routines that perform common calculations. 194



Group

A set of two or more selected objects in Draw. 421



Header

Text that appears at the top of every page in a section or document. 148



Hyperlinks

Text that's usually underlined in help screens (and Web pages too) that you can click to navigate to other areas. 20



Insert mode

The state of Writer where new text you type is inserted before existing text. It is indicated by the INSRT message on the status bar. 43



Insertion point

A vertical text cursor that shows where the next character you type will appear. Page 42



Landscape

Printed across the long edge, as you might do for a wide report. 86



Layers

Groups of items, such as your drawing's graphics and text, controls you place on a drawing, or dimension lines for three-dimensional space control. 388



Legend

Tells a chart's audience what series each colored line or bar represents. 260



Long click

Click and hold your left mouse button, without dragging your mouse, until a toolbar or option appears. 17



Macros

A series of keystrokes, menu selections, dialog box selections, and other keyboard-related activities that you save as recorded steps to be rerun later. 455



Master documents

A repository of documents, called subdocuments, each of which might be a chapter or document worked on by several people, as you might find in corporate reports submitted by multiple departments. 454



Master slide

Also called a master page and refers to a page that determines the background and formatting styles in the current presentation. 318



Multilevel index

An index entry that contains a primary term such as Fruit and two or more secondary entries, offset to the right under the primary term, such as apple, banana , and pear. 109



Nonbreaking space

A space that appears between words when you print the document but does not break at the end of a line. 43



Non-proportional

Each letter, no matter how wide (such as W) or narrow (such as i) consumes the same amount of space on the line. 36



OLE object

Object Linking and Embedding; this term refers to an object that can be placed inside documents of different types, such as a Writer word processing document and an Impress presentation. 344



Operator hierarchy model

A predefined order of operators when equations are being calculated. 179



Overtype mode

The state of Writer where new text replaces existing text as you type (indicated by the OVER message on the status bar). 43



PDF

The name (and filename extension) given to documents that conform to Adobe Systems' Portable Document Format. 155



Pixels

An abbreviation for picture elements, which refers to the smallest addressable dot, or graphic element, on a screen or printer. 330



Portrait

Printed down the narrow edge, as you might do for a letter. 86



Range

One or more cells, selected adjacent to each other in a rectangular manner, that you can name and treat as a single entity or group of cells in formulas. Page 197



Records

The rows in a database representing all the data for a single item. 277



Regular expressions

The name given to OpenOffice.org's extensive wildcard character support; OpenOffice.org supports far more wildcard characters than most Windows programs. 57



Relative reference

A cell that is referenced in relation to the current cell. 180



Scale

A ratio that describes the size of objects on your screen and how that size relates to their actual printed size. 380



Sheets

Numerical information presented in a tabular row and column format with text that labels and discusses the data (also, loosely, called spreadsheets). 160



Smart quotes

The rounded quotes that curl in or out, depending on whether they begin or end a quoted phrase. 144



Snap lines

Also called snap-to lines and refers to logical lines that align the objects on your drawing to one another. 378



Spreadsheets

OpenOffice.org documents that hold one or more sheets (called workbooks in Microsoft Excel). 160



Style

A set of character and paragraph formats you can apply to text to change that text's format details. 89



Subdocuments

Documents held and organized inside a master document. 461



Tables

Collections of information organized in rows and columns. 111



Template

A predefined document with styles and other formatting, such as columns and tables, that forms a model for new documents. 89



Themes

A collection of graphic files you save as a group under a theme name. The Gallery comes with several predesigned themes, such as Backgrounds and Bullets. 430



Transition

The way one slide leaves the presentation screen and the next slide appears. 301



Typeface

A character design that determines the size and style of how your characters look. 77



User-defined index

An index that is secondary to the primary, alphabetical index, such as a figure index or a list of people index. 109



Vector graphics

Graphics defined by geometric shapes such as lines, curves, rectangles, and polygons. 378



Wildcard search

Allows you to use wildcard characters, such as *, to replace characters in a search. 57



 <  Day Day Up  >  


Sams Teach Yourself OpenOffice.org All In One
Sams Teach Yourself OpenOffice.org All In One
ISBN: 0672326183
EAN: 2147483647
Year: 2003
Pages: 205
Authors: Greg Perry

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net