Chapter 6 Working with Data and Data Tables

Finding and Replacing: Page 164-165

In Excel 2007, worksheet can be used Find and Replace dialog box. This is use for you to search for cells that contain particular values. When you want to find cells, the cell value matches the value you're searching box. Including in Find and Replace dialog box, there are Options. Options could be used to identify data that requires review using a specific format. In Finding and Replacing, can change value by hand, or select the cell and then either type a new value in the cell or in the Formula Bar. Replace and type the new value. This tools are some of the Find and Replace there are others such as, Find what field, Find All button, Find Next button, Replace with field, Replace All button, Replace button, Options button, Format button, Within list box, Search list box, Look In list box, Match case check box, Match Entire Cell Contents check box, and Close button.

Correcting and Expanding Upon Worksheet Data: Page 168-169

Checking and correcting, by using on piece of numeric data is correct, make sure you spelled right, that is spelling checker. In Excel 2007, can make a change you can remove the change, as long as the workbook isn't closed. Also, can undo and redo button. Undo button is to undo a change and Redo is to command and restore it. Including on spelling check, you could also use the Thesaurus, this is to check if your word is correct and if it does exist that word. Finally, to translate a word, from one language to another. By doing this you will have to, select the cell that contains the value you want to translate, and in review tab, in proofing group and by clicking Translate, the Research Task Pane, appears and displays controls that you can use to select the original.

Defining a Table: Page 172-174

Defining a Table in Excel 2007, is not always to list of data correctly, but it enables you to sort your worksheet data based on the values in one or more columns. To create a data table, you will have to type a series of column headears in adjacent cells and then type a row of data below the headers. Creating a table, in a exisisting data list as long as your data has a different format header row. In add data to a table, select a cell in the row immediately below the last row in the table or a cell in the column immediately, to the right of the table. Adding rows and columns to a table, this could be used by dragging the resize handle at the table's lower-right corner. Table can contain data, that you can summarize by calculating a sum or average. Adding a total row, in Excel 2007, can create a formula that can calculate the sum of the values in the rightmost table column.