Powered By Blogger

Friday, March 26, 2010

How to do a digital signature

  1. In Excel or Word, click the Insert tab.
  2. In the Text group, double-click Signature Line. The Signature Setup dialog appears.
  3. Type the needed information and select the options that you want. Click OK.
  4. The Signature box appears.
  5. To sign the document or spreadsheet, double-click theSignature box.
  6. Note You may be prompted to save the file. Save the file.
  7. The Sign dialog appears.
  8. You can type your signature or click Select Image to insert a signature image file.

How to Customize Quick Acces Toolbar

  1. First you need to know where the quick acces toolbar is located at
  2. Left corner next to the microsoft button
  3. click the arrow that is on the quick acces toolbar and clickCustomize Quick Access Toolbar

How to protect w&wo password

  1. Click the office button and then click save as
  2. Click the tools button in the save as dialog box
  3. Then click General Options on the tools menu
  4. after it displays the general options dialog box just type the passwords that you want on the workbook.
  5. Click Ok
  6. Then excel displays a confirm passowrd box and just re enter your password
  7. click ok
  8. and then click ok in the save as box

How To Track Changes

  1. First open Excel
  2. click on the Review Tab.
  3. Under the changes group click on Track changes
  4. After that you have several options either to accept the changes or reject change and that is all.
  5. that is basically how to track changes in a workbook.

How to Inspect for hidden and personal information

  1. Open the workbook that you want to inspect for hidden data and personal information.
  2. Click the Microsoft Office Button
  3. click Save As, and then type a name in the File name box to save a copy of your original workbook.
  4. In the copy of your original workbook, click the Microsoft Office Button, point to Prepare, and then click Inspect Document.
  5. In the Document Inspector dialog box, select the check boxes to choose the types of hidden content that you want to be inspected.
  6. Click Inspect.
  7. Review the results of the inspection in the Document Inspectordialog box.
  8. Finish

Friday, February 26, 2010

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.

Wednesday, February 24, 2010

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 :)

Tuesday, February 23, 2010

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...