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.

Performing calculation on Data

Performing Calculations on Data

excel 2007 gives you a handy place to store and organize your data. But not just that you can also calculate the data you have in many different ways.

Naming Groups of Data

When you use a large amount it is often useful to identify groups of cells that contain related data. Like you can get a selected group of cell to identify them compared to others. So that range of cells will be easier to find. A way to do that is to select the cells you want to name then in the reference tab click the name from selection and name your cells. Next time you want to go their just look it up in the cell name and you will get their much easier.

Creating Formulas to Calculate Values.

After you write data you can create a formula for the previous data you just wrote. And you can say where do you want your answer. You can do sums averages counts and many more just go to the formula dialog box.

Quiz

Abraham Salazar

1.The simplest way to enter data into a cell is to simply click on a cell and type what you want to put.

2.The purpose of auto fill and fill series is that it makes it easier for you to enter data.

3. The available auto fill options are numbers, days of the week, dates, formulas and text.

4. A pick form drop down list is to format stuff in a spreadsheet.

5. The paste option button appear in the home tab in the clipboard and is to enter data that has already been copied from somewhere else or previous workbooks or work sheets.

6.The way you locate specific data in a spreadsheet is by going to the home tab and on the last group click the find and replace button.

7.It lets you replace anything in the worksheet or workbook.

8.thsarus, checker button, and replace

9. The way you create a data table in a worksheet you fist go to the insert tab then go to the tables and click insert a table.

10.The purpose of a total row in a table is that it calculates the amounts of just tat row.

Working with data and data tables.

Excel allows you to show information in effective way by using graphs charts and others. Excel provides a wide variety of tolls you can use to enter and manage worksheet. like it helps you to put charts r tables so you can easily put your work into to the tables ad lets you analyze the work.

Entering and revising data.

As soonest you create a workbook you can begin to enter data into it one way is to click the cell and type in your work thats when you entering small pieces of data another way is to copy and paste some data that works good when your entering a large amount of data. Excel also helps you enter data according to the pattern that your showing.

Moving Data within a workbook

Their are many ways to move a specific cell in lots of ways, but one of the most direct method is to click the cell to which you want to move. When you click the cell it will be outlined and its contents will appear in the formula bar. Then you can modify the formula by clicking what do you want to do( add, subtract, and other) and then clicking or dragging the cell you want it to take effect on it. You can also make room for a column or rows so you can insert extra data.

Finding and replacing Data

You can have up to one million rows in excel but if you have so much Data it will be to hard to move row by row to find what your looking for. thats why you use the find and replace dialog box that is located in the home tab.

Modifying Worksheets

setting up a workbook

When adding a workbook You first appear with Three worksheets. On a workbook with that you have several options on how do you want to name your worksheets how many you want and more.

Another option you have is when you have a lot of workbooks open you can sort them out so they wont take much space.

You can also modify you your quick access toolbar so you wont have to be looking for commands every little while.ask it will always open with three blank worksheets. And you have to add any style you want.

When you save a work in a different format or over wright the previous one that you had for that workbook.

In a workbook you can click the office button and click the properties and you can look at all the comments tittles keywords and more.

On the custom tab of the advanced properties dialog box. to select of the existing custom category. or create your own like the date numbers and text.

When your doing a lot of records you have you can subdivide by adding more worksheets and to do that just click the worksheet tab on the tab bar ( just below the grid of cells).

A name of a worksheet doesn't always have to be sheet 1 or sheet 2 or so on. You can change the name of a worksheet depending on what you doing or depending on the tittle of the Workbook.

another way to work with ore than one workbook is to copy a worksheet from a workbook to a current one you can copy a worksheet by right clicking it and then it will tell you how you want to copy it or when do you want to move it to.

You can also change the order of the worksheets by clicking and dragging. or if you want one worksheet to out stand from the others you can right click it and change the color or make it 3D so it will out stand.

You can also temporarily delete or hide a worksheet fro a certain amount of time.

Daily news

Almost 20% of the billions of dollars America taxpayers are spending to rebuild Iraq are lost to theft, kickbacks and corruption. And important reason of why to know this is cause most of our taxes are being lost.

six weeks plan

well were going to do is the same thing but this time study Mcas excel. Of course learn all the shortcuts and learn the basic things as in how to add stuff or how to secure the document.