Skip to Main Content
Excel Hacks
book

Excel Hacks

by David Hawley, Raina Hawley
March 2004
Beginner content levelBeginner
304 pages
7h 2m
English
O'Reilly Media, Inc.
Content preview from Excel Hacks

Chapter 9. Glossary

ActiveX Controls

Fully programmable objects that can be used to help customize applications. In Excel use, these commonly include the Command button, the Option button, etc.

Add-In

A workbook saved with the extension XLA. It opens as a hidden workbook when installed via Tools Add-Ins. An Add-In provides extra functionality to Excel.

Application

Another term for a program. Excel is an application; some people call their spreadsheets applications.

Arguments

The information a formula or function might require to return a value. Most functions within Excel require arguments for their execution. The arguments are enclosed within parentheses and are separated by commas.

Boolean

A mathematical means of expressing statements in logic. A Boolean value will be either True or False.

Brackets

See Parentheses.

Bug

An error in code. Unfortunately, some bugs can go undetected by the most stringent tests, and therefore they are hard to get rid of.

Command Bar

One of Excel’s many objects, used to house menu items. The Worksheet menu bar is a Command bar that houses the menu items File, Edit, View, Insert, etc.

Constant

A named item that represents an unchanging value.

Contiguous

A range of cells in which all boundaries of all cells are connected, with no gaps. For instance, A1:C20 is a contiguous range.

Control Toolbox Toolbar

A toolbar that contains ActiveX controls (see ActiveX Controls).

Debugging

The process of eliminating all possible errors from code.

Dialog

A pop-up window, also referred to ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Hacks, 2nd Edition

Excel Hacks, 2nd Edition

David Hawley, Raina Hawley
101 Ready-To-Use Excel Macros

101 Ready-To-Use Excel Macros

Michael Alexander, John Walkenbach
Excel Annoyances

Excel Annoyances

Curtis D. Frye

Publisher Resources

ISBN: 059600625XErrata Page