List of things to remember of the Test

In the test, I saw: Change style of a chart, unhide a column, change the theme, protect or not access the cell and should be 0 and 5000, change the capital letters to lower letters by a formula, enter a formula to find the average, copy a comment and places them on cells on worksheets, save the workbook on another name.

Finding and Correcting Errors in Calculations

The way to do this, is to auditing. The first thing is, to fill the cell holding the formula generating ther error with an error code (#NAME?). Then when a cell with an erroneous formula is the active cell, an Error Button appears next to it. Next click the button down arrow to display a menu with a options that has information about the error and to help you fix it. Next if the cells, identified by the tracer arrows aren't the correct cells, you can hide the arrows and correct the formula. Then hide the tracer arrows, if you have elements of a formula error as text in a dialog box. You could use the Error Checking dialog box. For, to view the error and the formula in the cell in which the error occurs, so that you can ignore or move through the error. And to display the Evaluate Formula, is much more useful for examining formulas that don't produce an error but aren't generating the result you expect. Finally, by opening the Watch Window, it displays the new results of the formula.

Summarizing Data That Meets Specific Conditions

To create a conditional formula, you click the cell to hold the formula and open the Insert function dialog box. In the dialog box, select IF from the list of available funtions and then click OK. The Function Arguments dialog appears. The Logical_test box you want to check. Then you enclose the message in quotes in the Value_if_true or if_false box. Then in the IFERROR function enables you to display a custom error message instead of relying on the default Excel 2007 error messages to explain what happened. If function finds a match for the CustomerID, if it doesn't find a match, it displays the text Customer not found. This is what you do.

Creating Formulas to Calculate Values

By creating formulas to calculate values, you have to create a formula first. To start for a formula, you in cell content's with an equal sign. When it gets the expression and when the equal sign, type the formula. For example, =C2+C3. When you want to create a new calculation, you click on the Formula Tab, in the Function Library Group, click Insert Function. Then the Insert Function dialog box will appear on the screen, in the Insert Function dialog box. There will be list of functions, which you can choose. In that list you choose your argument, doing that the next thing is to, you put the formula by hand. Then you use the Formula AutoComplete. That is it.

Naming Groups of Data

Naming Group of Data:

How do you change the naming group of data, here is how you do it. You first, select the range or named range. Then second, you go to the Formula bar, find the Defined Names group and click on Define Name. When you already did that, a New Name dialog box appears, in the Name Field. You type what verify the cells, that you had selected in the Refers Field, when you did that you click Ok.
There is another way, go to Formulas tab, Defined Names Group and click Name Manager. Then the Name Manager dialog box appears, then you click the named range. Clicking Edit button, it will appear the Edit Name dialog box. Able to change a named range's definition. To get rid off a name by clicking Delete button, and then click OK.

The 10 Questions

1). The simplest way to enter data in a worksheet is to click and type it in.

2). AutoFill is to grab and fill handle and extends far enough your data and FilSeries is you can enter 2 values in a series and use the fill handle to extend the series in your worksheet.

3).Auto Fill Options appear when you add data using AutoFill:
---Copy Cells
---Fill Series
----Fill Formatting Only
----Fill Without Formatting

4). Pick from Drop-down List for in a spreadsheet is a to choose a value from existing values in a column

5). Paste Options button appears in next to data you copy from a cell, and this is use for paste another cell.

6). You locate specific data on a worksheet by Find and Replace, in the Home Tab.

7). Replace tab enable you to do in a worksheet by can find all occurrences of the word and change all of them to the same thing.

8). List three proofing and research tools available in Excel 2007
---Thesaurus
----Spelling & Grammar
---Translate

9). In Excel 2007, to create a data table, in a exisisting data list as long as your data has a different format header row.

10). The purpose of the Total Row in a table is to do it more easier, to find the total of formula or calculating.

Chapter 6 Working with Data and Data Tables

Finding and Replacing: Page 164-165

In Excel 2007, worksheet can be used Find and Replace dialog box. This is use for you to search for cells that contain particular values. When you want to find cells, the cell value matches the value you're searching box. Including in Find and Replace dialog box, there are Options. Options could be used to identify data that requires review using a specific format. In Finding and Replacing, can change value by hand, or select the cell and then either type a new value in the cell or in the Formula Bar. Replace and type the new value. This tools are some of the Find and Replace there are others such as, Find what field, Find All button, Find Next button, Replace with field, Replace All button, Replace button, Options button, Format button, Within list box, Search list box, Look In list box, Match case check box, Match Entire Cell Contents check box, and Close button.

Correcting and Expanding Upon Worksheet Data: Page 168-169

Checking and correcting, by using on piece of numeric data is correct, make sure you spelled right, that is spelling checker. In Excel 2007, can make a change you can remove the change, as long as the workbook isn't closed. Also, can undo and redo button. Undo button is to undo a change and Redo is to command and restore it. Including on spelling check, you could also use the Thesaurus, this is to check if your word is correct and if it does exist that word. Finally, to translate a word, from one language to another. By doing this you will have to, select the cell that contains the value you want to translate, and in review tab, in proofing group and by clicking Translate, the Research Task Pane, appears and displays controls that you can use to select the original.

Defining a Table: Page 172-174

Defining a Table in Excel 2007, is not always to list of data correctly, but it enables you to sort your worksheet data based on the values in one or more columns. To create a data table, you will have to type a series of column headears in adjacent cells and then type a row of data below the headers. Creating a table, in a exisisting data list as long as your data has a different format header row. In add data to a table, select a cell in the row immediately below the last row in the table or a cell in the column immediately, to the right of the table. Adding rows and columns to a table, this could be used by dragging the resize handle at the table's lower-right corner. Table can contain data, that you can summarize by calculating a sum or average. Adding a total row, in Excel 2007, can create a formula that can calculate the sum of the values in the rightmost table column.

Chapter 6 Entering and Revising Data

Entering and Revising Data: Page 156-159



Entering sequence can be handled by copying and pasting. But there is a easy way, just by using the AutoFill. Autofill is grab and fill handle, and extends far enough your data. FillSeries, is you can enter 2 values ia a series and use the fill handle to extend the series in your worksheet. In Excel 2007, AutoComplete, which detects when a value you're entering is similar to previously entered values. Along with that comes, Pick from Dropdown List, what this does is able to choose a value from existing values in a column. All this tool is just to enter and revise data, there are other tools, such as Copy Cells, Fill Formatting Only, Fill Without Formatting, and Fill Days, Weekdays, etc. These have in common of copying and filling in. This is entering and revising data.

Moving Data Within a Workbook: Page 160-162

This specific topic is about, moving to specific cells in lots of ways. In one of the use, is Active Cell what this does is can modify it contents. There is one use kind of way such, as the Actice Cell, that is Cell Range. This is, is to click the first cell in the range and drag the mouse pointer over the remaining cells you want to select. Copying cell contain set of column labels to a new page, that summarize the data. This is not a limited to selecting cells individually or part of a range.
The Pasting Options, this appears next to data you copy from a cell, and this use does paste another cell. In, moving data within a workbook, there are more tools, such as Use Destination Theme, Match Destination Formatting, Keep Source Formatting, Values Only, Values and Number Formatting, Values and Source Formatting, Keep Source Column Widths, and Formatting Only.

Modifying Worksheets & Customizing Excel 2007

Modifying Worksheets:





In modifying worksheets, you could put up the signposts. What it does, it is easy to find, and do the workbooks easier to work with. Modifying column width and row height can make a workbook's contents easy to work. For example, Adding space between edges of a worksheet, makes less crowded and easy to work with. It also explains how to use this Adding space.

Delete a row or column, by right-click the row or column, then click Delete. Hide & Unhide row and columns. By this is easy way to delete or remove rows and columns. Insert individual cells into a worksheet. By this, you could delete cells, arrange columns, shift cells and move around the cells. And it explains what to do, to use this. Move data in a group of cells to another location in your worksheet. It explains how to do this moving. And what will it do, is you could move it in your desire location on the worksheet.

Customizing Excel 2007:

How Excel 2007 is use, in what different ways. It could be used by, team interviews customers, observes how differing organizations use the program, and sets up the user interface. In Excel 2007 there is zoom, and zoom is a tool for zoom in or zoom out on size of an object. To find the Zoom control, at the lower-right corner of the Excel 2007 window. In Excel 2007, you could have more than one workbook, using this you can arrange your workbooks. Adding buttons to the Quick Access Toolbar, what this does is, you can choose programs to be added on the quick access toolbar. You could also remove programs too, out of the quick access toolbar. This is what is about customizing excel 2007 is about.

Chapter 5: Setting Up a Workbook

Intro:

Create a new workbook in Excel 2007.

A blank workbook, contains 3 worksheets. Add, Delete and Hide worksheets withing the workbook.

To exercise with the workbooks that have been already created for Consolidated Messenger. This is to show how the Excel 2007, be used in workbooks.

Creating Workbooks:

When you use the save file, you could overwrite the copy you did before or make changes to where you want to save it.

But in the Save As dialog box, its different for the new file and location in which to save the new version to the file.

Property or information, save specific information about your file.

It is how to set up the workbook's properties.

In Properties dialog box, that is the Custom tab. It explains how can you use it, for example. Text, Date, Number, Yes/No) selecting or typing a value in the Value field, and then clicking Add.

Modyfying Workbooks:

Create a workbook to record information, that should thus represent a subdivision of that activity. So, it is about how to put in a worksheet information of some source of activity.

Create a worksheet in Excel 2007, has options such as to put a name, such as Sheet4, Sheet5, Sheet6 and stuff like that. Basically is about changing the name to the worksheet and how to do it.

How to copy one worksheet to more copy, from another workbook to the one in the current workbook. And it is explained too.

In the selecting the Create Box, this makes a copy check box leaves the copied worksheet in the same workbook. This explains how the Create Box do.

Changing the locations of the worksheet or worksheet's, in the workbook. And explains how to do this changing location of the worksheet in the workbook.

Copy a worksheet to another workbook. This does when it is in active workbook, the worksheet retains its tab color. Also, if there is another workbook with different theme applied, it changes the tab colors, that make the same theme.

If you don't want or use a worksheet, it can be deleted. And explains how to do delete the worksheet.

It explains that in the bottom there is instructions, to excercise insert and rename worksheet, change worksheet's position in a workbook, hide and unhide the worksheet, copy the worksheet to another workbook, and worksheet's tab color and delete a worksheet.

The New iPad from Mac

The new iPad. People around the United States, are talking about. Everyone would want one right now, Why? Well let me tell you why, this iPad. This iPad is combined by the iPod and the new Mac Computer, they had done already. When you have it and power on, it would look like the home site, regular as a computer. It also looks like the iPod standin up, and putting it to the side it looks like a Mac computer. In my own words the size looks like a frame picture, only the side it thinner. You could personalize your home background to, whatever you want to put. You could browse the web, and it is extradionary. You could see the whole web page, in front of you. And you could put the iPad, Up, Down, Side, whatever and the page would move the same way as you put it. For mail, you could focus on the message, see your inbox, and if you turn your iPad sideways you could, get a different view on your mail, by having the keyboard (is the same as the computer) and message on top. The photos, could be stacked on every place, you could click and have a clear view on the whole screen, and slide shows. Including you could built a calendar, you could put your activites or events. There is a Address Book, for your contexts. A map, for where you want to go, satellite views, zoom in or out. Also, you could put your music, this includes with the iTunes Store, purchase the music, discover music, movies, TV shows, Podcast and much more. You could see YouTube in High-Def. The most good thing, is to watch TV Shows and Movies.

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.

Current Events- Obama Seeks $1.35B More For Education

My source was in the Internet. The website was KFOX, search this in January 18.2010. In Monday, 10:05 p.m. The title is Obama Seeks $1.35B More For Education, President Barack Obama announced, that he will ask the Congress for $1.35 Billion, for extend an education grant program, for states. Officials expect 30 states or more to apply. Also, Barack Obama wants to use some of the $1.35 Billion for a grant program for local school districts. Obama is expected to send this to the Congress his 2011 budget proposal, sometime next month.

The importance from this summary, is that in the future I and others will have the chance to have, better education and better chances to have a good college. I, think that this is a great plan, and there is no doubt, that I or eveyrone maybe someone to be recognized in the future. Including this plan has chance to have a job right away, finishing high school or college. This is my importance from this summary.

Excel Intro 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.

Excel Intro Tasks 11-20

11. Enter Number- Select the cell, click inside the cell box and put in the number, then press enter and your done.

12. Exit Excel- Click on the microsoft button, then click exit excel. Its next on excel options.

13. Fill Series-Drag and Drop= click on position holder, then fill handle till the cell you want and your done.

14. Font Size- In home tab, font group, click on the Font size arrow, choose and your done.

15. Fonts- In home tab, font group, click on the Font arrow and choose your font and your done.

16. Function-Auto Sum= In home tab, in editing group. Click the AutoSum (its a figure E), and your done.

17. Go To- In home tab, click on the Name Box. Click the name you wanted to select and your done.

18. Help- Display Help Contents= Click on the Help ( its a figure of a circle and inside a ?), then click on the Show Table, and your done.

19. Help- Search= Click on the microsoft excel help button, click on the search box and type what you want to search. Then you click Search and your done.

20. Modify Search- Highlight what you want, to change on function. Then their is a new value, and when you press enter. And your done.

Current News Events

Channel 14 KFOX-TV, they reported in El Paso, Texas. A 15- year old son uses household products to get high. Dexmethorphan or DXM is an ingredient in cold medicine, that is users to get high get to do this. Not only his was using DXM, but he also did some few instructions of how to get high with hand sanitizer. But his the only one doing this stuff, but also others around the US, for example in youtube videos theirs people showing how to smoke or drink nutmeg from the spice rack. This product nutmeg contains a chemical called myristicin, this causes euphoric state. Other examples, in youtube videos there is persons huffing the hand sanitizer and a man smoking banana peels. This products, if abused, can be dangerous and maybe death. This is what I watched yesterday.

What this may cause me to development as a successful individual, is that people may try to ruin my life by offering me, this type of things and maybe people around me could be doing this, too. But, it not only affects me, but others around the US. Including, this could affect me by having bad surroundings around and not let me concentrate for my education. This is what may cause me, to be successful individual.

Whats My Plan To Be Succeed in Excel

My game plan is to pay attention to the teacher, what she is saying about this topic. Go to Excel, and see how is it? what tools or materials it has? how to use it? what is it useful for? and ex... Also, practice at school and home steps to how to do things in Excel. Study the steps or process of what I learned at school. Be 100% percent into this work and know what Im doing and explain to myself what is Excel?. When I do this, my paying attention is the grades and finish strong this 2nd semester, so that I could have a good report card and finish with a certification for Excel and have another certification for this 2nd semester.