Key Terms

 <  Day Day Up  >  

Don't let unfamiliar terms discourage you from learning all you can about 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


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


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


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


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


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


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


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


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


A predesigned slide layout for Impress presentation slides. 302


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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

Regular expressions

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

Relative reference

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


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


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 documents that hold one or more sheets (called workbooks in Microsoft Excel). 160


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


Documents held and organized inside a master document. 461


Collections of information organized in rows and columns. 111


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


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


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


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 All In One
Sams Teach Yourself All In One
ISBN: 0672326183
EAN: 2147483647
Year: 2003
Pages: 205
Authors: Greg Perry

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: