Tables help you manage and analyze a group of related data easier. Therefore, you can turn a range of cells into a Microsoft Office 2007-2010 Excel table (previously known as an Excel list). A table typically contains related data in a series of worksheet rows and columns that have been formatted as a table. By using the table features, you can then manage the data in the table rows and columns independently from the data in other rows and columns on the worksheet.
To determine if a table is a complete table, just click in cell of that table and click CNTRL+A for Select All. See below:
Notice that the table is highlighted in blue and it is surrounded by empty clear cells like an island. Therefore, if you wanted to sum each quarter or sum by salespeople, you just click in the empty cell and click AutoSum icon. This…
View original post 382 more words