Basic concepts in Excel

This page in 2003
Top  Previous  Next

 

Certain ideas that underpin Excel are presented here

mainly, because it is necessary to be familiar with them in order to understand the intent behind some features of OAK and why they might be useful
also, as a service to the community, because they are useful things for Excel users to know whether or not they choose to use OAK.

Multi-area ranges

Subsets of the cells on a worksheet that are arranged in shapes more elaborate than a rectangle

Used range

The area of each worksheet for which storage is reserved

Cell precedents

The cells that a formula acts on to reach a result

One-Cell rule

A rule that determines which cells commands should act on

Merged cells

A way of formatting a group of cells so that it appears to be a single cell

Arrays

An advanced kind of formula that processes lists