Microsoft Office Tutorials and References
In Depth Information
Understanding data lists
Understanding data lists
With Excel, you can maintain a large collection of related data in a data list, also known as
a database, which is a table of worksheet data that uses only column headings. Each row,
referred to as a record, contains information about the category displayed in the column
heading. The top row of the worksheet holds the categories that you want to track, such as a
name or street address.
Each column heading must be unique.
Sorting a range
A range is a collection of two or more cells that you can work with as a group. You can
then i ll the range with values and sort the range data, based on the values in one or more
columns. Sorting makes the range easier to read and analyze. You can sort the data in
ascending or descending order. Ascending order arranges the values alphabetically from A to
Z or numerically from 0 to 9; descending order arranges the values alphabetically from Z to
A or numerically from 9 to 0.
Sorting data on a single i eld
In this exercise, you’ll sort data on a single i eld, the year of the movie, in ascending order.
To open the i le you need for this lesson:
1 Choose File > Open. Excel displays the Open dialog box.
2 Navigate to the Excel07lessons folder and double-click excel0701 to open the i le.
3
Select File > Save As. Excel displays the Save As dialog box.
4
In the Save As text box, type excel0701_done and then click Save.
5
In the worksheet, click cell C2; click the Data tab, and in the Sort & Filter group, click
Sort (
). Excel displays the Sort dialog box.
The Sort dialog box lets you sort by any of the headers in ascending or descending order.
Search JabSto ::




Custom Search