Friday, January 22, 2010

Excel 11-20

Enter Number


To enter a number select the cell and write down the number you choose to write





Exit Excel:


To exit Excel go to your Microsoft Office button. On the far right bottom corner click on the Exit Excel button.





Fill Series - Drag and Drop:


To fill in series click on the cell you wish to drag and drop. If you put pointer and the bottom right corner of that cell the pointer turns into a cross. Click on that and hold it. Drag it to the cell you want the series to continue.





Font Size:


To change the font size of a text. Select the cell and on the home tab in the font group go to the font size button. Change it to the font size you want it to.





Fonts:
To change the fonts highlight the text and go to the home tab and in the font group click the fonts button. Change it to the one you want.







Function - Autosum:
To autosum make sure you select the cell that's under the other cells you are going to sum. In the home tab in the editing group click the autosum button.







Go To:
To "go to" go to the find and select button on the home tab in the editing group and click go to and type in what you want.







Help - Display Help Contents:
To display help contents go to the help button and at the top of the menu bar on the help display box click the button that says Table of Contents with the book on it and click it.







Help - Search:
To search for something go the help button and and in the text box type the question or thing you want to find and click search.







Modify Formula:
To modify a formula click on the cell that you want to modify the formula. On the top of the page an "fx" will appear and a formula next to it. Click on the the numbers and delete them. Put the letter and number you wish to have and press enter.

Thursday, January 14, 2010

Excel Intro 1-10

1.Apply Style

First make sure you are on your home tab. Next go to your style group and click on the Cell styles. Next click on the style that you want.

2.Auto Correct

First click on the office, then go to your Excel Options. After that go to the Proofing tab. In the proofing tab go to your Auto Correct Options. A screen fill pop out with all your options. Check the Capitalize Name box, then click OK.


3.Bold cell contents

On your home go to your Font group and click on the Bold Button.

4.Cell formatting-Remove

On your Home Tab go to your Styles group. Then click on the Cell Styles button a drop down box will open, then click on the normal style and all formatting is cleared.

5.Center Across cells

On your home tab, go to your Alignment Group. click on the Merge and Center button.

6.Chart-create

On your Insert tab go to your Illustrations Group, then click the column chart button a drop down will give you all your options.

7.Clear cells

In your home tab, go to your Editing Group and click the Clear Button, a drop down will give you your options, click on the Clear Contents Button.

8.Color Text

In the home tab go to your Font Group and click on the Font color arrow. Your Options are given to you.

9.Copy cells

In your home tab go to your Clipboard group and click on the copy button, the context is copied to your clipboard.

10.Create New workbook-blank

Go to the office Button and click on the New,the New Workbook will open Click on the Blank Workbook then click on the create Button

Wednesday, January 13, 2010

Current Events (Earthquake HIts Haiti)

Yesterday, around 5 p.m an 7.0 magnitude earthquake hit the country of Haiti. Now, you might say what does a earthquake have to with our economy. Well this is your answer. The United States always feels that it should help other countries in time of need. Seeding needed supplies to other countries spends a lot of our government's money. Now who's the one that provides that money. BINGO! Non other than tax payers. Tax payer's are the one's that support this countries economical franchise. So, what do you think should the United State spends million's to help other countries, our should we lay back and help our fallen economy.

Wednesday, January 6, 2010

Connecting Word and Excel, Game plan

Last semester was a hard but worth it. All the work and effort paid off by a certification. This semester will be no different, I know there will be things that I will not like but I know they will benefit me. This semester, I will give all my attention to the task at hand and I will turn in Company worthy papers. My game plan will be to push throw the things that I don't like, and learn and prepare for the Excel test. Here We Go!