Naming Groups of Data

When you use large groups of data it can be helpful to name them

• You can select a range
• You then go to the Name Box on the left of the formula bar.
• Name the cell or selection of cells to whatever you want

Another way to change the name is

• To go to the Formulas tab and in the Defined Names group click Define Name
• The New Name dialog box appears
• In the Name field, type what you want.
• Click OK

Exam

Luis Avila
1. The simplest way to enter data in a worksheet is to click on a cell and enter the data
2. The purpose of autofill and fillseries is tomake it easier to enter data because all you have to do is drag the fill handle, sometimes it won’t work because excel doesn’t recognize everything. Like days of the week and months.
3. Time, days, months, numbers
4. To help you format some stuff.
5. In the clipboard group on the home tab. To help you paste things
6. The find and select button.
7. To find specific data and replace it with another text
8. Spelling, Research, Thesaurus
9. You click in a cell in a range that has information, then click format as table and choose the table you’d like
10. To help you find the totals of the numbers you have in your table

Chapter 6

Entering and revising data

Entering and Revising data can be an easy task. all you have to do is click on a cell. To fill cells you can use the fill handle and autofill options and fill series

Series are done when you drag the fill handle. The fill handle will replace contents on the cells based on the one that you started on.

Auto complete is another technique that you can use to enter similar values. Also you can pick from Drop down list. Which enables you to choose a value from existing values in a column

There is also another handy feature that is the autofill options it appears next to the data that you add to a worksheet. You have some control over the series you can move it to the left of up

Excel extends the previous values also use the ctrl button to drag a series

Auto complete detects if a value you are entering is similar to previously entered values

Ctrl and enter enters multiple value simultaneously

There is a auto fill options to format cells

Moving data within a workbook
There are many ways to move around in your workbook but the most common mehtod is to just click the cell you want to move to. You can also move columns, rows or cell ranges. The copy, paste, and cut method can also be helpful.

Finding and replacing data
basically all its telling you is just to use the find and replace dialog box. You can locate specific data in excel.
Correcting and Expanding upon worksheet Data
After you enter data you should take the time to check and correct it. You can check the spelling by usig the Excel 2007 spelling checker. It will help you with words that are not recognized or misspelled. you can also use the redo and undo buttons on the Quick Access Toolbar. You can also use the encyclopedia, thesaurus and dictionary to help you out.
Defining a Table
Excel allows you to manage tables effectively. Excel can create a table using your data. You just select a cell and make it into a table
You can also customize your tables by adding rows and columns, then remove them if you wish.