Quantunet.com

My Account

Joins Us
Excel QuickSkills
Indexing Cells Using Rows & Columns  

 

Indexing [Pointing To Your Data]

 

When items are indexed they are methodically organized and listed. A familiar type of index is the list that of pages that can be found in the back of a book. Words are listed alphabetically, each word in the list has a page number associated with it that tells the reader of the book on which page that subject appears.

The process of organizing the terms and listing them in a systematic way is called indexing. An index in computer programming acts in a similar way to indexes found in the back of books, it points the user in the correct direction so they can find the information they are looking for.

When using electronic spread sheets the exact location of each cell is used to reference the information inside the cell. This is important otherwise information can be lost or the wrong information referred to when a change is made.

 

 
  • Every cell in a spreadsheet is unique, each having its own name and location.

  •  

  • A cell is defined using the column letter and then row number.

  •  

  • For example this cell is C6.

 

 

 

The index term C6 automatically "points" to the cell in column C row 6.  Now you have the ability to enter or retrieve information directly from the cell.

 

The next step is learning how to manipulate  information in cells by using the equation bar.

© 2007 Quantunet LLC All Rights Reserved | Intellectual Property | Terms of Use | Privacy
Home | About Quantunet | FAQ's | Contact Us