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.