COMPSCI 1BA3 Chapter Notes -Level Of Measurement, Summary Statistics, Bottom 10
Document Summary
Common use of worksheet is to manage data such as: list of clients, products, transactions. Using excel you can: store and update data, sort data, search for and retrieve subsets of data, summarize data, create reports. Data definition table is a documentation that lists the fields to be maintained for each record and a description of the information each field will include. You can work with data by applying the following operations: add, edit, and delete data in the range, sort the data range, filter. To narrow the search: insert formulas to calculate subtotals, create summary tables based on the data in the range (usually with. Freezing a row or column lets you keep headings visible as you work the data in a large worksheet. So when scrolling down the tile goes away. By using the freezing it does not matter how far you scroll down, the title will still be visible. You can convert structured range into excel tables.