How to format cells

To select cells that are not adjacent to each other one way to select them is to click control and to highlight the cell ranges. In the font group on the home tab you can change the font, colors, and borders, with your cells selected.

Things We Remember

I don't remember too much things but i just remember I had a lot of trouble with charts, and formulas. I struggled with setting the formulas up because it told me to set a specific range but when i did that it just didn't seem right. We hadn't seen a plethera of things which made it much more difficult. I can't point out these certain things because of my memory. It was hard to take the test in the environment we were in because there were lots of distractions. The eighth graders, random people coming in. It was good when i took the test after school because it was serene and I was really calm. If we had studied a bit more i think we could have been ready.

Naming Groups of Data

When you use large groups of data it can be helpful to name them

• You can select a range
• You then go to the Name Box on the left of the formula bar.
• Name the cell or selection of cells to whatever you want

Another way to change the name is

• To go to the Formulas tab and in the Defined Names group click Define Name
• The New Name dialog box appears
• In the Name field, type what you want.
• Click OK

Exam

Luis Avila
1. The simplest way to enter data in a worksheet is to click on a cell and enter the data
2. The purpose of autofill and fillseries is tomake it easier to enter data because all you have to do is drag the fill handle, sometimes it won’t work because excel doesn’t recognize everything. Like days of the week and months.
3. Time, days, months, numbers
4. To help you format some stuff.
5. In the clipboard group on the home tab. To help you paste things
6. The find and select button.
7. To find specific data and replace it with another text
8. Spelling, Research, Thesaurus
9. You click in a cell in a range that has information, then click format as table and choose the table you’d like
10. To help you find the totals of the numbers you have in your table

Chapter 6

Entering and revising data

Entering and Revising data can be an easy task. all you have to do is 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.

Auto complete is another technique that you can use to enter similar values. Also you can pick from Drop down list. Which enables you to choose a value from existing values in a column

There is also another handy feature that is the autofill options it appears next to the data that you add to a worksheet. You have some control over the series you can move it to the left of up

Excel extends the previous values also use the ctrl button to drag a series

Auto complete detects if a value you are entering is similar to previously entered values

Ctrl and enter enters multiple value simultaneously

There is a auto fill options to format cells

Moving data within a workbook
There are many ways to move around in your workbook but the most common mehtod is to just click the cell you want to move to. You can also move columns, rows or cell ranges. The copy, paste, and cut method can also be helpful.

Finding and replacing data
basically all its telling you is just to use the find and replace dialog box. You can locate specific data in excel.
Correcting and Expanding upon worksheet Data
After you enter data you should take the time to check and correct it. You can check the spelling by usig the Excel 2007 spelling checker. It will help you with words that are not recognized or misspelled. you can also use the redo and undo buttons on the Quick Access Toolbar. You can also use the encyclopedia, thesaurus and dictionary to help you out.
Defining a Table
Excel allows you to manage tables effectively. Excel can create a table using your data. You just select a cell and make it into a table
You can also customize your tables by adding rows and columns, then remove them if you wish.

Boy raises money for Haiti

This seven-year-old, Charlie Simpson raise $161,000 for the Haiti earthquake. He had hoped to just raise 500 euros for UNICEF's earthquake appeal by cycling eight kilometers around a park.

Charlie had this to say, "My name is Charlie Simpson. I want to do a sponsored bike ride for Haiti because there was a big earthquake and loads of people have lost their lives, I want to make some money to buy food, water and tents for everyone in Haiti." This is important because it will help many people in Haiti who are in need and potentially save some lives.

http://www.cnn.com/2010/WORLD/europe/01/25/uk.boy.charity.haiti/index.html?hpt=T2

Tasks 1-10

1. Apply Style- You go to home tab, go to styles group. Click on the cell styles, and pick your style.

2. Auto Correct- Click on the microsoft button, click on excel options, and in the dialog box, search for Proofing and click it, and click on AutoCorrect Options. Then make your corrections.

3. Bold Cell Contents- In home tab, and font group. Click on the letter B (capitalized and dark color)

4. Cell Formatting-Remove= In home tab, and in styles group. Click cell styles. Then in a dialog box of cell styles appear, click on normal.

5. Center Across Cells- In home tab, in Alignment group. Click the merge and center button. And your done.

6. Chart- Create= In Insert tab, in Charts group, click on columns, line, pie, bar and others click on whicever and you choose. And your done.

7. Clear Cells- In home tab, in Editing group, click Clear button (figure of a white eraser) and you then a dialog box appears, you have options like, clear all, clear contents, formats and comments. Choose the one you wanted and your done.

8. Color Text- In home tab, font group, click on the font color arrow. And choose your color, and your done.

9. Copy Cells- In home tab, clipboard group. Click on the copy button and your done.

10. Create New Workbook Blank- Click on the microsoft button, click on New. Then click ont the Blank Workbook and then click on create and your done

Excell Intro 2 Tasks 11-20

Enter Number- click on the cell and enter the number then click return
Exit Excel- Go to the microsoft button and then go to exit excel at the bottom corner
Fill Series - Drag and Drop- click the cell and in the corner there'll be a box. Drag yur cursor over it and it will turn into a cross. drag and drop where you want
Font Size-go to the font group and font size box and click on the drop down arrow. Choose the font size you want and click on it.
Fonts- go to the font group and click on the fonts box and choose the one you want
Function - Autosum- click the sum button in the editing group. the sum of each column is inserted into the selected group of cells
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- in the formula bar change to cells you want

Earthquake in Haiti

The magnitude-7 earthquake that happened tuesday afternoon in Haiti is believed to have killed as much as 500,000 people. They are giving this estimation according to the extent of destruction, instead of counting the dead. President Rene Preval says he believes thousands are dead, but officials say theres more than that. The presidents palace and the main prison, cathedrals, schools and homes were destroyed. Most people are still trapped under the debris and Haitians are piling the bodies

Six weeks future plans

What I plan to do this six weeks is learn excel. I want to get experienced in excel so that I can get certified again. We're probably going to do the same type of work to practice excel. Well thats what I think.