Chapter 6. Setting the Table: Database Features of Excel 2010

By now you've established a close relationship with the concept of a range—that collection of adjacent cells occupying a rectangular area on the worksheet (we'll leave aside any additional nuances I may have bothered you with earlier). Now, a range can be blank, of course—a collection of adjacent, rectangular-shaped empty cells is no less a range because of its dearth of data. But when a range is filled with records—that is, a series of consecutive rows and columns containing related information topped by headings of the First Name-Last Name-Address variety—you and I might call that assemblage of data a database. If you were compiling a seating list for a formal event—even if you wrote ...

Get Beginning Microsoft Excel 2010 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.