Naming Groups Of Data

First you open microslft and the you open chapter 7 open the naming gruops of data.
you clik and drag to a cells you go to the formula tab go to the defined names and clik Name Manager it will pop up the ne manager.

1. The simplest way to enter data in a worksheet is by the dialog box, and also has controls functions.
2. The purpose of Auto Fill is too automatic to enter series of formulas and etc…
3. I don’t know
4. I don’t know
5. The paste options button appears and it is used for a spreadsheet when you copied something to.
6. I don’t know
7. The replace table enable you to do in a worksheet
8. I don’t know
9. To create a data table in Excel 2007 you need to insert the information on the data.
10. The purpose of the Total row in a table is to be more organize and be more clean.


El Al3x :)

Carrecting and Expanding Upon Worksheet Data

After you have enter your data you take the time to check and correct it.to undo a changre just click the undo button on the quick Access toolbar. when you click to the toolbar it will show the review tab and you can research.

El Al3x :)

Finding replacing Data Summary

Excel 2007 worksheets can contain more than 1 million of row and data.
you can also find data or also replacing any worksheet. they are different ways to replace dialog box.the dialog box have controls functions.For example Replace with field , options button etc...