You are here

Organizing Data in Rows and Columns

19 January, 2016 - 17:37

If a spreadsheet is used to store data, such as a list of project activities or a list of expenses, it is prudent to arrange the data in some way that would be used by more sophisticated data management software. Most data management programs arrange data in such a way that each type of data is represented by a column with a label at the top and each row contains the specific data for one type of item. A collection of data arranged in rows and columns is a table. For example, a list of expenses would be arranged so that individual expenses are recorded on each row, and each column would be a type of information related to the expenses, as shown in Figure 6.15.

media/image11.png
Figure 6.15 Expenses Arranged in a Table in a Spreadsheet