How to Save as 97-2003 &template, html

1. First go to the microsoft button
2. click save as
3. on the save as type select either 97-2003 or template or html 
4. after you've selected how you wanted to save it as click save

How to add validation rule

1. Click on the cell you wish to add the validation rule to

2. Click on the Data tab

3. Click on the Data Validation button  in the Data Tools group.

The Data Validation dialog box will open

4. And after that you can either put a validation rule for example whole numbers,integers etc.  

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 the Signature box.
 Note   You may be prompted to save the file. Save the file.
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 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 click Customize 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 & 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 Inspector dialog box.
8. Finish

Adding Images to a Document

To add an image to a document:

• Firts you need to go to the insert tab. 
• Once you are in the insert tab go to the illustrations group and click on the picture button. 
• Then you can choose which picture you want and just insert it. 

To add a background:

• First go to the page layout tab 
• In the page setup group click on the background button. 
• After that you can choose which picture you want to put as the page background.
• And lets say that you don't like the background you can delete the page background by going to the page layout tab and under the page setup group click on delete background. 

Changing the Appearance od Data Based on Its Value

To change the apperance of data:

• first select what you want to change the appearance. 
• Then go to the home tab. 
• In the styles group click on conditional formatting. 
• Then click on any of the choices and you can pick which appearance you want for the group of data that you have and what the data's value is based on.

Making Numbers Easier to Read

To make numbers easier to read:

• first you need to select the cell that you want to change.
• Second thing that you need to do is to go to the home tab
• Then go to the font group and click the dialog expander.
• After the dialog box opens you have to click on what you want to change the number to from the category list. 
• Once you choose something from the category list then you can customize it for example you can put a dollar sign or stuff like that and that's it.

Applying Workbook Themes and Table Styles

To apply an existing theme:

• first go to the page layout tab 
• Second go to the themes group and click on the themes button. 
• Then you can choose from various themes the one you want for your workbook.
• You can apply a new table style by going to the styles group on the home tab
• click on the format as table button. 
• Then click on the new table style button and you can then customize how you want the new style to look.

Definig styles

To Define a style is very easy for example:

•  first go to the home tab.
•  go to the styles group and click on cell styles.
• There are multiple styles that you can choose.
• You can also create a new style by going to the home tab and going to the styles group and clicking on cell styles.
• Then click on new cell style.
• A style dialog box will pop up and you can name the new style to whatever you want it to be named.
• Then click on the format button and the format cells dialog box will pop up and you can customize the new style the way you want it by clicking on the different tabs and creating it the way you want it to look.

Formating cells

How to format cells is easy:
cells are easy to do depending on what you want to format and most of the tools that you need are available in the home tab. Formating cells is easy first you have to select the cell or cells that you want to format and lets say that you want to make it bold so you select the cells first and the click the bold button that is on the home tab and in the font group.

What i learned from this activity is that you can select non-adjacent cells by holding the control key and select your cells.

Things We Remember On The Test

There is not so many things about the test that i remember. Maybe one of the things is to insert functions, and things that we don't even know or haven't seen ever. Not so many things we have seen like all the big words and the word terminology we haven't even touched at all. It was a terrible and not good idea on taking the test because most of the stuff that was on the test we didn't even learned or we had not been thought. Some thing that i remember is the functions that we had to put and it involved like a lot of words and functions that messed me up. This experience i guess it was good but it was just not planned for.

Finding and Correcting Errors in Calculations

Finding and correcting errors within formulas is an easy way:

1. First click on the cell that has the error Or if you dont know where the erros is click the trace precedents
2. Next is to go to the Formulas tab
3. Go to the Auditing group and click the Error Checking button
4. Adialog box pops up.
5. and it gives you options of what you want to do and you are done.

Summarizing Data That Meets Specific Conditions

Another use that use formulas to display messages when ceratain conditions are met. The type of formula that is neede for this data that meets specific conditions is called a conditional formula. The conditional formula uses the IF function. To create a conditional formula is very easy first step is to:

1. click the cell to hold the formula and open the insert functiondialog box.
2. From within the dialog box, select the IF from the list of functions that are available and then click OK.
3. Now you need for excell to have excell to display messages that indicate (whatever you want it to be) should evaluate the account for a possible rate adjustment.
4. whenever you put this messages you have to put them in quotation marks.
5. and press and enter and you are done and just make sure that you type your arguments.

Creating Formulas to Calculate Values

After creating data in a worksheet and define ranges to simplify data references, you can create formulas:

1. Lets say that you have a worksheet that displays numbers an you need to add a formula to get the total amount first go to the cell where you want the result to be.
2. Next type an equals sign and that is the first step to create a formula.
3. Lets say that you need to get an average of a certain range of the worksheet so after the equal signs just type average and then type a parenthesis.
4. After the parenthesis write the cells that you want the function to calculate.
5. When you are done typing the cells you want to make sure that you close the Parenthesis.
6. Press Enter and you are done.

For Example:
=AVERAGE(A1:B4)

Naming Groups Of Data

When you work with large amounts of data it is often useful to identify the groups of cells by naming them. The way you can do it is first to:

1. Select a range of cells that you want to name and that are related to each other.
2. Go to the Name box on the left of the formula bar, Type whatever you want to name it.

Editing

1. Go to the Formulas Tab and in the defined groups click the Name Manager.
2. A dialog box appears click on the name that you gave it
3. You can edit the cell range in the Refers to button and after going to the edit click ok.
4. It closes and it takes you back to the Name Manager dialog box and just click close and you are done.

Test

Marco Lara

1.    The simplest way to enter data is to click on a cell.
2.    The purpose of AutoFill and FillSeries is to make it easier when you need to enter data.
3.    1. Text and Formulas 2.Numbers 3. Days of the week. 4. Dates
4.    A pick from Drop-down list in a spreadsheet is to help you format stuff.
5.    The Paste options button appears on the Home tab on the clipboard group and it is used for pasting data.
6.    To locate specific data on a worksheet is easy there is a quick easy way called the Finding and Replacing Data button. The only thing you have to do is type the word and it will find it for you.
7.    The replace table enables you to replace data or anything that you need to replace.
8.    1.Spelling Checker Button 2.Research 3.Thesaurus
9.    To create data in a table you have to click on a cell that is inside the table then just click format as table and choose the one that you may need.
10.    The purpose of the Total Row in a table is that it creates a formula and calculates the sum of the values in the rightmost table column.

Chapter 6

Entering and Revising data
Entering and Revising data is easy you only have to click on a cell. To fill cells you can use the fill handle and autofill options and fill series.

Series are done when you drag the fill handle. The fill handle will replace contents on the cells based on the one that you started on.

Autocomplete is another technique that you can uss to enter similar values. Also you can pick from Drop down list. Which enables you to chose a value from existing values in a column.

There is also another handy feature that is the autofill options and appears next to the data that you add to a worksheet.

Moving Data Within a Workbook
There is lots of ways to move a cell but there is a quick method by clicking it. It makes the cell active.

There is not a limit on selecting cells you can select a whole column and on the paste options you can move it to another place.

Finding and Replacing Data
It basically tells you that when there is lots of data in a worksheet and you need to find a word or replace words there is a quick process and that is to click the Find and Replace and a dialog box appears and your set to go.

If you want to replace or format a word then you can click the format button and click either replace or replace all.

Correcting and Expanding Upon Worksheet Data
There is a quick way to correct instances of words by using the Spelling checker button to correct words that might be mispelled. Or also you can look fr the meaning of a word.

Also if you want to translate a word to another language you can do so by clicking the translate button on the Proofing group on the review tab.

Defining a Table
You can add tables to a worksheet and also you can display data in it.

Excell 2007 can also create a table based on an existing data list. You just have to select a cell wherever you want to add data.

You can also add rows and columns to a table you can also remove them if you don't want them by dragging the resize handle.

When you add the Total Row, Excell creates a formula and calculates the sum of the values in the rightmost table column. You can also change the table names by clicking any names in the table and then go to the design tab that appears and then in the properties group.

If for any reason you want to convert your table back to normal range cells. You can do so by clicking any cell in the table and then in the design tab in the tools group click the Convert to range.

Sumarize

The first paragraph talks about opening Microsoft office Excel 2007. It basically says that when Excel opens it displays a brand new blank document.

The second paragraph talks about customizing Excel so it can be easy to use and to fit your work style.

Third paragraph talks about the sytem design of excel and about the Quick Acces Toolbar.

The fourth paragraph talks about what you will learn in the chapter likecreating and modifying.

The Fifth paragraph talks about ho new workbook can be related to the data and about new workbooks.

The sixth paragraph talks about when you open a new workbook it displays a new blank workbook. And about saving changes.

New Ipad

The new ipad is just like a big Itouch but its better cause its like a touchscreen laptop.There are many features that it has its all good new things that it has because it is touchscreen.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.

Haiti Fundraiser

The poorest elementary schools in the region helped raised money for the Haiti tragedy of the last week’s earthquake. The students from Campestre Elementary Schoolgot together to raise money and went around the area and knocked on doors and waited outside the Big 8 store holding jars to raise money. The children collected thousands of pennies and much more. The school principal Isabel Andresen said that It was hard to believe that the, school with the highest percentage of children receiving free lunch and reduced meals could raise more than $1,000. According to the news over the earthquake of January 12 destroyed entire neighborhoods and an estimated toll of 200,000 thousand deaths. This is very important to do a fundraiser to help people get back to their normal life’s is an important thing to do because what if things like that happen in the US we are going to need help and by helping others it builds bonds of friendships between countries and it is also important because innocent people that had valuable stuff and family members is gone forever and people are in need of money and most important for food and a shelter where they can live.

Excel Intro 2 Tasks 11-20

Excel Intro 2 Tasks 11-20

Enter Number

• click on the cell were you want to insert it
• and type the number and click enter

Exit Excel

• Click the Microsoft Office Button, and then click on Exit Excel

Fill Series - Drag and Drop

• go to 

Font Size

• go to home tab
• and then go to font group and click the arrow that has the number and change the font size

Fonts

• to change the font just go to home tab
• under fonts group click the one that has the font names and change it 

Function - Auto sum

• home tab
• under editing group
• click the thing that looks like an E and it does it for you

Go To

• click the name box arrow to open the drop down menu and click on the one you want

Help - Display Help Contents.

•  go to the microsoft excel help button at the top. click the Show Table of Contents button in the top of the excel help window.

Help - Search

• go to the microsoft excel help button and in the box type whatever you want in the Search text box

Modify Formula

• formula bar and change the letters and numbers in the parenthesis

Excel Intro 1 Tasks 1-10

Excel Intro 1 Tasks 1-10

1-10
Apply Style

• To apply a style first go to the home tab
• go to styles group
• click on the style that you want and thats all.

Auto Correct

• Click the Microsoft Office Button, and then click Access Options.
• In the Access Options dialog box, click Proofing, and then click Auto Correct Options.

Bold Cell Contents

• First select what you want to bold
• then go to home tab 
• In the Font group there is a B that is bold
• click it

Cell Formatting - Remove

go to home tab

cells group

and then click on format

and click on clear format

Center Across Cells

• go to home tab
• go to alignment group
• click on the center cells button

Chart - Create

• go to insert tab
• under charts group pick the one that you want

Clear Cells

• go to home tab
• under cells group
• click delete and select the one that says delete cells

Color Text

• go to home tab
• go to font group
• and click the one that has the color font thing

Copy Cells

• go to home tab
• under clipboard group
• select copy 

Create New Workbook Blank

• Click the Microsoft Office Button, and then click on new
• and a dialog box pops up
• just click the create button

Summarize and why important

There's a group of people who really love the U.S. health care system the fraudsters, scammers and organized criminal gangs who are obtaining from the system of as much as $100 billion a year. Health care identity theft is on top of all other crimes in the sector last year, according to Louis Saccoccio, executive director of the National Health Care Anti-Fraud Association. It is important because people are abusing of healthcare and are are using it as fraud and this is really an important case because it affects everyone and also the economy. This case of people frauds are causing more trouble like i said it is on top of al the other crimes in the sector of last year.

This new year work

This new semester  is going to be not as hard as last years. im going to learn the excell Im going to learn all the shortcuts that are avilable and will need to know. the way were going to study is going to be similar to the one that we used last year and will be a good learning experience, but this time we are going to cover powerpoint and excell. cause im bad asss like that. Hope fully my test scores will be higher than last ones from word.i will be on task and learn as much as i can to pass it on the first try.