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.