Finding and correcting Errors in calculations

Chapter 7

Examining a worksheet for errors in formulas is called auditing.
first click on the formula tab and in the formula auditing group click the watch window
click the add watch and in the add watch dialog box click add
in the formulas tab in the auditing group click trace precedents and blue arrows appear.
to remove the arrows click remove arrows in the formula auditing group. Then click the error checking button when the dialog box appears click next. If the message box appears and says that there are no more errors, click OK.

Summarizing data that meets specific conditions

In this section we used a formula called a conditional formula. It displays a message if the condition is true, finds the average of the worksheet values that meet one criterion and find the sum of worksheet values that meet two criteria.
first you type the required criteria into the formula bar or the cell you want.
then you click and drag the formula down to the other cells.

Naming Groups of data

Chapter 7 Section 1

To rename a group of data first select a group of cells in a row
Then in the name box on the left of the formula bar type the name
In the Formula tab click the Name Managers in the Defined Names group

10 questions

1. The simplest way to enter data in a worksheet is to click a cell and type a value in.
2. The purpose of AutoFill and Fill Series is the ability to extend a series of values based on the contents of a single cell. Fill series is the ability to extend of values on the contents of two cells.
3. Auto Fill options that appear when you add Data using AutoFill are copy cells, fill series, fill formatting only, and fill without formatting
4. The pick from Drop-down list in a spreadsheet is for
5. The paste options button appears in the home tab on the left side of the ribbon. It is used for copying or moving data.
6. In the home tab click the find and replace button. Type in the find what text box.
7. The replace tab enables you to replace one or all instances of data
8. Three proofing and research tools are the spell-check button, the thesaurus, and the translate button.
9. Type a series of column headers in adjacent cells and then type a row of data below the headers. Select the headers and data then in the home tab click the styles group click format as table. The format as table dialog box will appear. Then the ‘my table has headers’ check box is selected then click ok.
10. The purpose of the total row is to show the total of the values in the cells above.

Defing a Table

To create a Data table, type a series of column headers in adjacent cells and then type a row of data below headers. Select the headers and data then in the home tab click the styles group click format as table. The format as table dialog box will appear. The my table hasheaders check box is selected then click ok.

Correcting and Expanding upon a worksheet Data

You can edit a word directly, pick a proper word from a list of suggestions or have the spelling checker ignore the misspelling. You could also use spelling checker to add new words to a custom dictionary so that excel will recognize them later. If you want to undo a change click the undo button if you decide you want to keep the chsnge click the redo button. You could check for alternative words by using the thesaurus.

Working with Data and Data Tables chapter 6

Enter Data quickly simplest way to enter data is to click a cell and type a value in.

Move Data within a workbook, there are several ways, you could drag and drop. You could cut and paste.

Find and replace workbook data, click the find and replace dialog box. it has two tabs that lets you search for cells that contain particular values.

Verify and extend workbook data proofing and reference tools

you can make sure that

the text is spelled correctly by using the Excel 2007 spelling checker. organize your data using tables

chapter 5 modifying workbooks summary

To display a particular worksheet, just click the worksheet’s tab on the tab bar. To create a new
worksheet, click the Insert Worksheet button at the right edge of the tab bar. You can copy worksheets from another workbook by right- clicking the tab of the sheet you want to copy and, from the shortcut menu that appears, clicking Move or Copy to display the Move Or Copy dialog box.To change a worksheet’s location in the workbook, you drag its sheet tab to the desired location on the tab bar.

Chapter 5 setting up a workbook summary

When you open Excel 2007, the program is a blank workbook with three worksheets. You can customize Excel to fit your work style. You could add a command, that you use frequently, to the Quick Access Toolbar. Chapter five teaches you how to modifly workbooks, worksheets, and makes worksheets easier to find and customize. The Custom tab in the advanced Properties dialog box allows you to either choose a categorie or create your own. To display a worksheet, click the worksheet's tab on the toolbar. To change the worksheet's tab name double-click to highlight then type the new name. To work with more than workbook ,copy a worksheet from another workbook to your current workbook. To change a worksheet's location in the workbook, drag worksheet. To deletea worksheet simply right click and click delete.

current events

East El Paso becomes wing spot.

There are so many wing places in El Paso. This article in El Paso Times lists everything from big chain restaurants to small home town restaursants. They suggest you should try them. This is very popular and a big part of our economy.