{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

5. Excel - Computer Application in Management Yosi Wiesel...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Computer Application in Management Yosi Wiesel Exploring Microsoft Excel From Data to Information Database Concepts Lists can be used as simple databases Record: individual information contained in a row First row contains field names Field: unique information contained in a column for a record Fields are the same for each record (row) Key is used to determine the sequence in which the rows appear
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Computer Application in Management Yosi Wiesel Creating a List There must be a blank row and a blank column between the list and the rest of the worksheet The Data Form Command Data form: provides easy way to add, edit, and delete records in a list Select the Form command on the Data menu Displays a dialog box based on the fields in the list You need to enter the field names and one row manually to use the form
Background image of page 2
Computer Application in Management Yosi Wiesel A Data Form Sort Command Arranges records in a list according to the value in designated fields Can sort on text, numeric, or date fields Can sort in ascending or descending order Can sort on up to three fields When sorting on more than one field, choose most important field as the primary sort key If you sort, then add names to the list, you need to re-sort the list
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Computer Application in Management Yosi Wiesel Sorting Primary sort by location, ascending order
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}