List of things to remember of the Test

In the test, I saw: Change style of a chart, unhide a column, change the theme, protect or not access the cell and should be 0 and 5000, change the capital letters to lower letters by a formula, enter a formula to find the average, copy a comment and places them on cells on worksheets, save the workbook on another name.

Finding and Correcting Errors in Calculations

The way to do this, is to auditing. The first thing is, to fill the cell holding the formula generating ther error with an error code (#NAME?). Then when a cell with an erroneous formula is the active cell, an Error Button appears next to it. Next click the button down arrow to display a menu with a options that has information about the error and to help you fix it. Next if the cells, identified by the tracer arrows aren't the correct cells, you can hide the arrows and correct the formula. Then hide the tracer arrows, if you have elements of a formula error as text in a dialog box. You could use the Error Checking dialog box. For, to view the error and the formula in the cell in which the error occurs, so that you can ignore or move through the error. And to display the Evaluate Formula, is much more useful for examining formulas that don't produce an error but aren't generating the result you expect. Finally, by opening the Watch Window, it displays the new results of the formula.

Summarizing Data That Meets Specific Conditions

To create a conditional formula, you click the cell to hold the formula and open the Insert function dialog box. In the dialog box, select IF from the list of available funtions and then click OK. The Function Arguments dialog appears. The Logical_test box you want to check. Then you enclose the message in quotes in the Value_if_true or if_false box. Then in the IFERROR function enables you to display a custom error message instead of relying on the default Excel 2007 error messages to explain what happened. If function finds a match for the CustomerID, if it doesn't find a match, it displays the text Customer not found. This is what you do.

Creating Formulas to Calculate Values

By creating formulas to calculate values, you have to create a formula first. To start for a formula, you in cell content's with an equal sign. When it gets the expression and when the equal sign, type the formula. For example, =C2+C3. When you want to create a new calculation, you click on the Formula Tab, in the Function Library Group, click Insert Function. Then the Insert Function dialog box will appear on the screen, in the Insert Function dialog box. There will be list of functions, which you can choose. In that list you choose your argument, doing that the next thing is to, you put the formula by hand. Then you use the Formula AutoComplete. That is it.

Naming Groups of Data

Naming Group of Data:

How do you change the naming group of data, here is how you do it. You first, select the range or named range. Then second, you go to the Formula bar, find the Defined Names group and click on Define Name. When you already did that, a New Name dialog box appears, in the Name Field. You type what verify the cells, that you had selected in the Refers Field, when you did that you click Ok.
There is another way, go to Formulas tab, Defined Names Group and click Name Manager. Then the Name Manager dialog box appears, then you click the named range. Clicking Edit button, it will appear the Edit Name dialog box. Able to change a named range's definition. To get rid off a name by clicking Delete button, and then click OK.

The 10 Questions

1). The simplest way to enter data in a worksheet is to click and type it in.

2). AutoFill is to grab and fill handle and extends far enough your data and FilSeries is you can enter 2 values in a series and use the fill handle to extend the series in your worksheet.

3).Auto Fill Options appear when you add data using AutoFill:
---Copy Cells
---Fill Series
----Fill Formatting Only
----Fill Without Formatting

4). Pick from Drop-down List for in a spreadsheet is a to choose a value from existing values in a column

5). Paste Options button appears in next to data you copy from a cell, and this is use for paste another cell.

6). You locate specific data on a worksheet by Find and Replace, in the Home Tab.

7). Replace tab enable you to do in a worksheet by can find all occurrences of the word and change all of them to the same thing.

8). List three proofing and research tools available in Excel 2007
---Thesaurus
----Spelling & Grammar
---Translate

9). In Excel 2007, to create a data table, in a exisisting data list as long as your data has a different format header row.

10). The purpose of the Total Row in a table is to do it more easier, to find the total of formula or calculating.

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.

Chapter 6 Entering and Revising Data

Entering and Revising Data: Page 156-159



Entering sequence can be handled by copying and pasting. But there is a easy way, just by using the AutoFill. Autofill is grab and fill handle, and extends far enough your data. FillSeries, is you can enter 2 values ia a series and use the fill handle to extend the series in your worksheet. In Excel 2007, AutoComplete, which detects when a value you're entering is similar to previously entered values. Along with that comes, Pick from Dropdown List, what this does is able to choose a value from existing values in a column. All this tool is just to enter and revise data, there are other tools, such as Copy Cells, Fill Formatting Only, Fill Without Formatting, and Fill Days, Weekdays, etc. These have in common of copying and filling in. This is entering and revising data.

Moving Data Within a Workbook: Page 160-162

This specific topic is about, moving to specific cells in lots of ways. In one of the use, is Active Cell what this does is can modify it contents. There is one use kind of way such, as the Actice Cell, that is Cell Range. This is, is to click the first cell in the range and drag the mouse pointer over the remaining cells you want to select. Copying cell contain set of column labels to a new page, that summarize the data. This is not a limited to selecting cells individually or part of a range.
The Pasting Options, this appears next to data you copy from a cell, and this use does paste another cell. In, moving data within a workbook, there are more tools, such as Use Destination Theme, Match Destination Formatting, Keep Source Formatting, Values Only, Values and Number Formatting, Values and Source Formatting, Keep Source Column Widths, and Formatting Only.

Modifying Worksheets & Customizing Excel 2007

Modifying Worksheets:





In modifying worksheets, you could put up the signposts. What it does, it is easy to find, and do the workbooks easier to work with. Modifying column width and row height can make a workbook's contents easy to work. For example, Adding space between edges of a worksheet, makes less crowded and easy to work with. It also explains how to use this Adding space.

Delete a row or column, by right-click the row or column, then click Delete. Hide & Unhide row and columns. By this is easy way to delete or remove rows and columns. Insert individual cells into a worksheet. By this, you could delete cells, arrange columns, shift cells and move around the cells. And it explains what to do, to use this. Move data in a group of cells to another location in your worksheet. It explains how to do this moving. And what will it do, is you could move it in your desire location on the worksheet.

Customizing Excel 2007:

How Excel 2007 is use, in what different ways. It could be used by, team interviews customers, observes how differing organizations use the program, and sets up the user interface. In Excel 2007 there is zoom, and zoom is a tool for zoom in or zoom out on size of an object. To find the Zoom control, at the lower-right corner of the Excel 2007 window. In Excel 2007, you could have more than one workbook, using this you can arrange your workbooks. Adding buttons to the Quick Access Toolbar, what this does is, you can choose programs to be added on the quick access toolbar. You could also remove programs too, out of the quick access toolbar. This is what is about customizing excel 2007 is about.

Chapter 5: Setting Up a Workbook

Intro:

Create a new workbook in Excel 2007.

A blank workbook, contains 3 worksheets. Add, Delete and Hide worksheets withing the workbook.

To exercise with the workbooks that have been already created for Consolidated Messenger. This is to show how the Excel 2007, be used in workbooks.

Creating Workbooks:

When you use the save file, you could overwrite the copy you did before or make changes to where you want to save it.

But in the Save As dialog box, its different for the new file and location in which to save the new version to the file.

Property or information, save specific information about your file.

It is how to set up the workbook's properties.

In Properties dialog box, that is the Custom tab. It explains how can you use it, for example. Text, Date, Number, Yes/No) selecting or typing a value in the Value field, and then clicking Add.

Modyfying Workbooks:

Create a workbook to record information, that should thus represent a subdivision of that activity. So, it is about how to put in a worksheet information of some source of activity.

Create a worksheet in Excel 2007, has options such as to put a name, such as Sheet4, Sheet5, Sheet6 and stuff like that. Basically is about changing the name to the worksheet and how to do it.

How to copy one worksheet to more copy, from another workbook to the one in the current workbook. And it is explained too.

In the selecting the Create Box, this makes a copy check box leaves the copied worksheet in the same workbook. This explains how the Create Box do.

Changing the locations of the worksheet or worksheet's, in the workbook. And explains how to do this changing location of the worksheet in the workbook.

Copy a worksheet to another workbook. This does when it is in active workbook, the worksheet retains its tab color. Also, if there is another workbook with different theme applied, it changes the tab colors, that make the same theme.

If you don't want or use a worksheet, it can be deleted. And explains how to do delete the worksheet.

It explains that in the bottom there is instructions, to excercise insert and rename worksheet, change worksheet's position in a workbook, hide and unhide the worksheet, copy the worksheet to another workbook, and worksheet's tab color and delete a worksheet.

The New iPad from Mac

The new iPad. People around the United States, are talking about. Everyone would want one right now, Why? Well let me tell you why, this iPad. This iPad is combined by the iPod and the new Mac Computer, they had done already. When you have it and power on, it would look like the home site, regular as a computer. It also looks like the iPod standin up, and putting it to the side it looks like a Mac computer. In my own words the size looks like a frame picture, only the side it thinner. You could personalize your home background to, whatever you want to put. You could browse the web, and it is extradionary. You could see the whole web page, in front of you. And you could put the iPad, Up, Down, Side, whatever and the page would move the same way as you put it. For mail, you could focus on the message, see your inbox, and if you turn your iPad sideways you could, get a different view on your mail, by having the keyboard (is the same as the computer) and message on top. The photos, could be stacked on every place, you could click and have a clear view on the whole screen, and slide shows. Including you could built a calendar, you could put your activites or events. There is a Address Book, for your contexts. A map, for where you want to go, satellite views, zoom in or out. Also, you could put your music, this includes with the iTunes Store, purchase the music, discover music, movies, TV shows, Podcast and much more. You could see YouTube in High-Def. The most good thing, is to watch TV Shows and Movies.

This iPad has a big impact, into technology. By seeing things easier and browse better, including the now people have the ways to, have it next to them when they need it, rather then go to a computer or a smart phone. This is my way of saying the new impact to technology, from the iPad.

Current Events- Obama Seeks $1.35B More For Education

My source was in the Internet. The website was KFOX, search this in January 18.2010. In Monday, 10:05 p.m. The title is Obama Seeks $1.35B More For Education, President Barack Obama announced, that he will ask the Congress for $1.35 Billion, for extend an education grant program, for states. Officials expect 30 states or more to apply. Also, Barack Obama wants to use some of the $1.35 Billion for a grant program for local school districts. Obama is expected to send this to the Congress his 2011 budget proposal, sometime next month.

The importance from this summary, is that in the future I and others will have the chance to have, better education and better chances to have a good college. I, think that this is a great plan, and there is no doubt, that I or eveyrone maybe someone to be recognized in the future. Including this plan has chance to have a job right away, finishing high school or college. This is my importance from this summary.

Excel Intro Tasks 1-10

1. Apply Style- You go to home tab, go to styles group. Click on the cell styles, and pick your style.

2. Auto Correct- Click on the microsoft button, click on excel options, and in the dialog box, search for Proofing and click it, and click on AutoCorrect Options. Then make your corrections.

3. Bold Cell Contents- In home tab, and font group. Click on the letter B (capitalized and dark color)

4. Cell Formatting-Remove= In home tab, and in styles group. Click cell styles. Then in a dialog box of cell styles appear, click on normal.

5. Center Across Cells- In home tab, in Alignment group. Click the merge and center button. And your done.

6. Chart- Create= In Insert tab, in Charts group, click on columns, line, pie, bar and others click on whicever and you choose. And your done.

7. Clear Cells- In home tab, in Editing group, click Clear button (figure of a white eraser) and you then a dialog box appears, you have options like, clear all, clear contents, formats and comments. Choose the one you wanted and your done.

8. Color Text- In home tab, font group, click on the font color arrow. And choose your color, and your done.

9. Copy Cells- In home tab, clipboard group. Click on the copy button and your done.

10. Create New Workbook Blank- Click on the microsoft button, click on New. Then click ont the Blank Workbook and then click on create and your done.

Excel Intro Tasks 11-20

11. Enter Number- Select the cell, click inside the cell box and put in the number, then press enter and your done.

12. Exit Excel- Click on the microsoft button, then click exit excel. Its next on excel options.

13. Fill Series-Drag and Drop= click on position holder, then fill handle till the cell you want and your done.

14. Font Size- In home tab, font group, click on the Font size arrow, choose and your done.

15. Fonts- In home tab, font group, click on the Font arrow and choose your font and your done.

16. Function-Auto Sum= In home tab, in editing group. Click the AutoSum (its a figure E), and your done.

17. Go To- In home tab, click on the Name Box. Click the name you wanted to select and your done.

18. Help- Display Help Contents= Click on the Help ( its a figure of a circle and inside a ?), then click on the Show Table, and your done.

19. Help- Search= Click on the microsoft excel help button, click on the search box and type what you want to search. Then you click Search and your done.

20. Modify Search- Highlight what you want, to change on function. Then their is a new value, and when you press enter. And your done.

Current News Events

Channel 14 KFOX-TV, they reported in El Paso, Texas. A 15- year old son uses household products to get high. Dexmethorphan or DXM is an ingredient in cold medicine, that is users to get high get to do this. Not only his was using DXM, but he also did some few instructions of how to get high with hand sanitizer. But his the only one doing this stuff, but also others around the US, for example in youtube videos theirs people showing how to smoke or drink nutmeg from the spice rack. This product nutmeg contains a chemical called myristicin, this causes euphoric state. Other examples, in youtube videos there is persons huffing the hand sanitizer and a man smoking banana peels. This products, if abused, can be dangerous and maybe death. This is what I watched yesterday.

What this may cause me to development as a successful individual, is that people may try to ruin my life by offering me, this type of things and maybe people around me could be doing this, too. But, it not only affects me, but others around the US. Including, this could affect me by having bad surroundings around and not let me concentrate for my education. This is what may cause me, to be successful individual.

Whats My Plan To Be Succeed in Excel

My game plan is to pay attention to the teacher, what she is saying about this topic. Go to Excel, and see how is it? what tools or materials it has? how to use it? what is it useful for? and ex... Also, practice at school and home steps to how to do things in Excel. Study the steps or process of what I learned at school. Be 100% percent into this work and know what Im doing and explain to myself what is Excel?. When I do this, my paying attention is the grades and finish strong this 2nd semester, so that I could have a good report card and finish with a certification for Excel and have another certification for this 2nd semester.

What Do I Know About Excel?

Excel is about when we use the tables, graph, formulas, list of items and more things.

In excel, there's auto sum for the formulas. Auto sum is were you, it sums automatically the total of the average, maximum, minimum, and count numbers. Also excel, has letters (A,B,C), numbers and ruler for the cells or the boxes. Including you could also color the border, lines and the inside of the table. You could also shift down or up the cells. Also, you could sort the list A-Z or Z-A. Including, that you could copy, cut, and paste things. You could also change the size of the word, bold, underline, and italic the word. Well this is what I know about Microsoft Excel.

My Reflection on the Test

Well, the test was not the only thing, that made us put, everyone in pressure.
It was also the study that we did, over all this semester. Like the training in Sam 2007, or the notes that we took a day before the test. Also, the lessons of where to go, to do copy and pasting, inspect document, compare documents, and much more. Including the test that we took in Sam 2007, it helped a lot. It help us by knowing much more, to where to do things in Microsoft Word.
This is the preparations that I or we took to get prepared on the test.

The test was a nervous experience for me, it was a pass or fail thing and put me into a lot of pressure. This test made me, reflect to myself, as how much do I know about the Microsoft Word. And I thought, I dont even study or practice at home or anywhere else, it's only at class.
And thinking this I thought I'm not prepared, for the first test. Sure it was the first test I failed, with 333 and it was a horrible thing, I knew I needed to study or pay attention more. And that's what I did. And sure thing the second test I passed it, but I wasn't that sure that I was going to pass. I was nervous and blank minded. But, when I went to the test, I started going thinking and that helped me, too. And now I passed and I felt great. This was my experience on the test, by the way I did to get prepared for the test and when I was doing the test.

1.Go to home tab, and next to the group of styles. There's a figure of a binoculars,


click it, and it will appear a Find and Replace box. In that box, the replace tab will be there, in find what you type: expert and below in replace with you type: qualified. When you are finished, you click on replace all, and that's how you do it.





2.Insert a Bookmark, you put your insertion point, where you want to put it. Then go to Insert tab, doing that go to Links group and click on the figure of a blue wavy flag called Bookmark, then will open the Bookmark box, in Bookmark name: put what you want to type. In the side, in the work Add, it turns to blue, you click Add. And there it is, that's how you insert a bookmark





3.Search a Bookmark, click the insert tab, and then click Bookmark in the Links group. A box appear called bookmark, you click on the name you typed, and then you click on Go To. And that's how you search a bookmark.





4.Watermark, click on page layout tab, look on the page background group. Click on watermark, now if you want to do your own watermark, go to Custom Watermark. And create it with your own options, when you are finish, click apply and it will appear.





5.How to make it on to the Clipboard, go to home tab, look on clipboard group, click on the copy (figure two papers), and it is there on the clipboard.





6.Save as a template, click on the Microsoft button, then go to save as. It will appear options, click on Word Template. Then a box appear Save as box, and then click on save and that is it.





7.Save as a Properties, click on the Microsoft office button, go down to Prepare. Then click on


properties, then it will appear something and contains author, title, subject, keywords,status


and comments. If you want it on advanced properties, click on document properties on left corner. This is how you do it.





8.Mark as Final, you go to Microsoft office button, go down to prepare, and click Mark as Final.





9.Make a Comment, highlight the word you want make a comment, then click on the Review tab. On the comments group, click on New Comment. Then you just type whatever you want to type.



10. How do you Modify a Style, you click on home tab and then click the Styles Dialog Box Launcher

options come out, next to the word theres a arrow, click on it and look for Modify and your there.



11. How to Change the Font Color In a Standard Group, you select the word or paragraph that you want to highlight and then right click (control+shift+click) and change the font color.



12. How to Apply a Style

Select the text, on the home tab, go to the styles group and click the More Styles arrow and then click the Strong Style.

13. Change the font size

Select text you want to highlight, and then click on the home tab, go to Font group and then next to change font face, there would be a number, click on the arrow and change it.

14. Can you Apply Character Spacing options:

Select the word or paragraph you want to highlight. On the home tab, go to font group and click on the dialog box. In your screen, it will appear, font box, then there's two tabs Font and Character Spacing. Click on the character spacing tab and change it.

15. Before and After Spacing:

You click on Page Layout, then on the Paragraph group (remember if you see points are for paragraphs spacing) then, theres two options Indent and Spacing, you go to Spacing and change the spacing.

16. Clear All Formatting:

Select the word or paragraph, then on the Home tab, go to Font group. And below the Font size, theres the clear formatting.

17. Adding Bullets:

Select the list you want to put bullets, then on the Home tab, go to Paragraph group, on the figure that 3 dots and line, you click on arrow next to it, then there's more options and you make your adding bullets.

18. Modify the Number List to the a)b)c) Number Style:
Select the list you want to change, then on the Home tab, go to Paragraph group, then next click the figure that is 123 arrow, and then something will appear, in the numbering library there's options, if you don't find what you want go down and click Define New Number Format and make your changes.

19. Change the Paper Size for Page One to A4:

Go to Page Layout, then go to Page Setup group, find the word Size. When you already did found it, click on the arrow and there would a box appearing in your screen and options to change. Pick the one you want and that's how you change the paper size for Page One to A4.

20. Sorting Text:
Select the list, then go to home tab. On Paragraph group, click the A-Z, then a Sort Text box will appear. When it appear, just make your changes to ascending to descending or descending to ascending.

21. How to Apply A Multi Level List:

Select the list. Go to the Home tab, look for the paragraph group. Click on the third box. Called Multi Level List and their you will have all your options.

22. How to Demote in A Multi Level List

Select the list that you want to highlight, then go to home tab and then in the paragraph group. In the fifth box on the top, click on it. And then you make your changes.

23. Apply Page Border

You click on the Page Layout tab, then go to Page Background group. Then you click on the Page Borders. Later a thing will pop up saying Borders and Shading, that's were you make your border.

24. Remove A Section Break:

Go to Page Layout tab, then in Page Setup group, look for the word Breaks, then you click on the arrow next to it, make your option and done. But, to remove it, is to highlight, and press delete.

25. Create A New Style

Select the word or paragraph first, from our home tab, in style group, then the drop down on Styles. and then click on the drop down arrow and create your style.

29. Change Out the Theme

You go to Page Layout. go to Themes group. Then click on Themes and change your theme.

31. Page Number and Page Footer

Insert tab, group Header and Footer and click on the Page Numbers and there it is. For footer, same steps, insert tab, group Header and Footer, and click on Footer.

32. Insert A Section Break

You go to Page Layout tab, in Page Setup group, look for Breaks click on it, and then you click your on whatever section break you want.

33. Change Page Numbering

You go to Insert Tab, then go to Header and Footer groups and find Page Number, click on it. Then select Format Page Numbers and your ready to change the page number.

34. Spacing Between Columns

You go to Page Layout tab, on Paragraph group, click the paragraph dialog box. A paragraph box will pop in the screen, in Indent and Spacing tab, then in Spacing section, and that's where you make your spacing between columns.

35. Insert a Bibliography

In References tab, then you go to Citations and Bibliography, you look for Bibliography, click on it and you click on Bibliography again and there you go, you have insert a Bibliography.

36. Table Center the Contents

You go to Home tab, go to the Paragraph group and click on the figure that have uneven lines centered. And there you go, you just have the table center the contents.

37. Insert Row

First click on the table, then you go to Layout tab, and in Rows and Columns group, you choose to insert a row in above, below, left, and right.

38. Split Columns

39. Change the Quick Style Set

Go to insert and click table, then go to merge group and then click spilt cells. This is how you do



the change the quick style set.


40. Create A Large Dropped Initial Capital Letter In The Margin

41. Picture Contrast

You go to home tab and click on change styles. You scroll over to style set and click on to fancy. This is how you picture contrast or this is the other way to do this, click the picture you would like to have, then in picture tools in the format group on the adjust button click in the contrast select and then you make your picture contrast options.

42. Inserting Shapes

You first click the picture you selected or want to get. Under the picture tools on the format group in the adjust button. Click contrast select the contrast you could get the selection you want.

43. Smart Art Graphics

You first do ist to. select the picture you want to select. Then in the picture tools, you go to the size group and adjust it.

Go to insert tab, next what you do is to click on smart art graphics. Below the smart tools, you click design or layout, and when you already did, just choose the thing you want.

44. Flipping Pictures

You go to insert tab, then in Illustration. You click on the smart art. Then you could select the type of style.

45. Inspect Document

You first select the picture. Then under picture tools, you go to the Arrange Group. Next you click rotate. Then from there you can rotated in horizontal or vertical.

46. Removal Personal Information

You go to the Microsoft Button, then you search for Prepare and then click on Inspect Document.

47. Scale Image Heights

You go to the Microsoft Button, search or scroll to Prepare. Then click on Inspect Document, then you click on Inspect and Remove everything.

48. Text Box

You first select the picture you want to get. Then under picture tool, you click the size group arrow. In the scale section, you click the arrow, so that you can change the scale size.

49. Delete Page Break

You go to the insert tab, and then the next thing is to go to the text group. Click on the text box, the next thing is to just select the text box you like.

50. Table of Contents

You first have to show and hide on the select the page break. Then you hilight, then you delete it.

51. Auto Corrections

You go to the references tab. Then you find the table of contents group and next you click to the update table of contents, so that you could have a new on, just by clicking on the table of contents.

52. Compare Documents

You first go the Microsoft Office button, and then you click on to the Word Options. Then you click on to Proofing Tab, next you look on to the top and then you click on to the Autocorrect
Options.

53. Proctecting and Restricting Documents

You first click on to the Review Tab, and the you go to Compare Group. Next you click on to Compare and that's it.

54. Combine Documents

You click on to the Microsoft Office Button, then you go to Prepare and Resrtict Permission.

55.Click Compare and Click Combine

You first click on to Review Tab, the in Compare Group. And you got there, and make your selections.

Free Training Website To Help Our Office 2007 Skills

This is a website that could help, to work on your Office 2007 Skills, www.free-training-tutorial.com

This contains videos, that explain you how to do Worksheets, Edit Cells, Format Cells, Rows and Columns and much more, that you need help on. Also, this website has downloads of Office Tutorial that you can have at your home. I picked this one because, when I was going through this website, I saw a lot of resources, that is really helpful to increase the skills of Office 2007. This is the helpful website to increase the Office 2007 skills.