save as 97-2003 and template.html

first go to the Microsoft button and then click save as.

after the dialog appears.

click the down arrow on the save as type and scroll down until you find 97-2003 template.html and then click.

insert validation rule

first select the area you want to work on.

Then on the ribbon click data

in the data group click data validation.

Then you will have all the options you want to validate as i allow what you want to validate what you want to validate and so on

how to insert a digital signature

1. first click the insert tab
2. in the text group click signature line.
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 the Signature box.
6. The Sign dialog appears.
7. You can type your signature or click Select Image to insert a signature image file.

how to Customize quick Access

Your fist go to the toolbar that is next to the Microsoft button and click the drop down arrow.

And their you will have all the options on what you want to add or take from the toolar.

How to protect w&w password

To protect your document workbook or exct in excel.

you first have to go to the review tab on the ribbon.

you then go to the changes group and click any button that says protect depending on what do you want to put a password on after you will have all the options on what specifically you want to protect.

How to Track Changes

The way you track changes is by first going to the review tab.

Then you go to the right of the ribbon.

And on the changes group click track changes.

How to inspect for hidden & personal information

First go to the to the Microsoft button and then click. After scroll down to the prepare click and then go to the inspect button when it opens. You will then have the options on what you want to inspect.

Defining Styles

To define a style you first need to go to the Home Tab, And in the styles group click cells styles. Click a cell style from the gallery that appears will added to the cells selected. but when you put your mouse over all the styles in the gallery style it will give you a live preview. When your ready to selected the style you want just simply click it.

Things i need to study from the test.

One of the things I remember . Is where it asked to add several things into one cell but all from different worksheets and into a chart. We could have done better if we had study more about more specific things or worked more on the formulas.