ࡱ> supqr#` ьbjbj5G5G W-W-6 6 6 6   t t!؀؀؀l.|0^mP t$hxA imA6 6 VB&&&6 8 &&&ln  !p cHl؀i*oHXT!!" C, )&7 CYAA l.l.$1F4xl.l.14x  6 6 6 6 6 6  Microsoft Office Excel 2007 Chapter Two: Formulas, Functions, Formatting, and Web Queries A Guide to this Instructors Manual: We have designed this Instructors Manual to supplement and enhance your teaching experience through classroom activities and a cohesive chapter summary. This document is organized chronologically, using the same heading in red that you see in the textbook. Under each heading you will find (in order): Lecture Notes that summarize the section, Figures and Boxes found in the section, if any, Teacher Tips, Classroom Activities, and Lab Activities. Pay special attention to teaching tips, and activities geared towards quizzing your students, enhancing their critical thinking skills, and encouraging experimentation within the software. In addition to this Instructors Manual, our Instructors Resources CD also contains PowerPoint Presentations, Test Banks, and other supplements to aid in your teaching experience. For your students: Our latest online feature, CourseCasts, is a library of weekly podcasts designed to keep your students up to date with the latest in technology news. Direct your students to http://coursecasts.course.com, where they can download the most recent CourseCast onto their mp3 player. Ken Baldauf, host of CourseCasts, is a faculty member of the Florida State University Computer Science Department where he is responsible for teaching technology classes to thousands of FSU students each year. Ken is an expert in the latest technology and sorts through and aggregates the most pertinent news and information for CourseCasts so your students can spend their time enjoying technology, rather than trying to figure it out. Open or close your lecture with a discussion based on the latest CourseCast. Table of Contents  HYPERLINK \l "_Chapter_Objectives" Chapter Objectives2 HYPERLINK \l "_EX_82_Introduction?" EX 82: Introduction2 HYPERLINK \l "_EX_82_Project" EX 82: Project Worksheet with Formulas, Functions, and Web Queries2 HYPERLINK \l "_EX_85_General" EX 85: Plan Ahead Box (Critical Thinking): General Project Decisions3 HYPERLINK \l "_EX_87_Entering" EX 87: Entering the Titles and Numbers into the Worksheet4 HYPERLINK \l "_EX_90:_Plan" EX 90: Plan Ahead Box (Critical Thinking): Determine the Necessary Formulas and Functions Needed4 HYPERLINK \l "_EX_90_Entering" EX 90: Entering Formulas5 HYPERLINK \l "_EX_98_Using" EX 98: Using the AVERAGE, MAX, and MIN Functions6 HYPERLINK \l "_EX_106_Verifying" EX 106: Verifying Formulas Using Range Finder7 HYPERLINK \l "_EX_107_Formatting" EX 107: Formatting the Worksheet8 HYPERLINK \l "_EX_108:_Plan" EX 108: Plan Ahead Box (Critical Thinking): Identify How to Format Various Elements of the Worksheet.9 HYPERLINK \l "_EX_127_Checking" EX 127: Checking Spelling10 HYPERLINK \l "_EX_129:_Plan" EX 129: Plan Ahead Box (Critical Thinking): Specify How the Printed Worksheet Should Appear.10 HYPERLINK \l "_EX_129_Preparing" EX 129: Preparing to Print the Worksheet10 HYPERLINK \l "_EX_132_Previewing" EX 132: Previewing and Printing the Worksheet11 HYPERLINK \l "_EX_135_Displaying" EX 135: Displaying and Printing the Formulas Version of the Worksheet12 HYPERLINK \l "_EX_137:_Plan" EX 137: Plan Ahead Box (Critical Thinking): Gather Information Regarding the Needed Web Query.12 HYPERLINK \l "_EX_137_Importing" EX 137: Importing External Data from a Web Source Using a Web Query12 HYPERLINK \l "_EX_140:_Plan" EX 140: Plan Ahead Box (Critical Thinking): Choose Names for the Worksheets13 HYPERLINK \l "_EX_140_Changing" EX 140: Changing the Worksheet Names13 HYPERLINK \l "_EX_142_E-Mailing" EX 142: E-Mailing a Workbook from within Excel14HYPERLINK \l "End_of_Chapter_Material"End of Chapter Material 14HYPERLINK \l "Glossary"Glossary of Key Terms17 Chapter Objectives Students will have mastered the material in Chapter Two when they can: Enter formulas using the keyboard and Point mode Apply the AVERAGE, MAX, and MIN functions Verify a formula using Range Finder Apply a theme to a workbook Add conditional formatting to cells Change column width and row height Check the spelling of a worksheet Set margins, headers and footers in Page Layout View Preview and print versions of a worksheet Use a Web query to get real-time data from a Web site Rename sheets in a workbook E-mail the active workbook from within Excel EX 82: Introduction LECTURE NOTES Describe a function Discuss the new topics in Excel including: Function Formula and verification Smart tags and option buttons Worksheet themes, formatting, and conditional formatting Spell checking E-mailing from within an application Printing options Web queries with real time data EX 82: Project Worksheet with Formulas, Functions, and Web Queries LECTURE NOTES Describe the project to add formulas, functions, and queries to a worksheet Review a requirements document and sketch Review the steps to start Excel For figures that match those in the book, change screen resolution to 1024 x 768 FIGURES: 21a, 21b, 22, 2-3 BOXES: 1. BTW: Aesthetics versus Function. Differentiate between function and visual look and that functional considerations should come first, before visual aesthetics. The user wants to know the information. Emphasize not to use graphics that interfere with the purpose of the worksheet. 2. BTW: Starting Excel. Explain how to use a command-line switch to start Excel and control how it starts. Explain the switch that starts Excel without opening a workbook. TEACHER TIPS A formula can be defined as an equation with more than one variable that is used to solve practical problems. Students probably have worked with formulas in mathematics, science, and business classes. Perhaps surprisingly, however, formulas also are used in psychology, anthropology, sports, art, music, the language arts, and other areas. Formulas can ascertain abstract possibilities, such as an objects length as its speed approaches the speed of light. Worksheets make formulas even more powerful. CLASSROOM ACTIVITIES 1. Group Activity: Divide the class into small groups. Ask each group to refer to the requirements document and the sketch in Figures 2-2 and 2-3 on pages 84 and 85 and discuss the requirements and the sketch, making certain they understand the needs, source of data, required calculations, and Web requirements for this chapter. 2. Assign a Project: Ask the students to regroup into the same groups they were with before. Ask them to list the aesthetics versus the function of implementing the information in the requirements document. For example, the aesthetics might be some of the graphics, charts, colors, or fonts that would enhance the worksheet. The function might be ease-of-use in understanding the data. EX 85: Plan Ahead Box (Critical Thinking): General Project Decisions LECTURE NOTES Review decisions to determine appearance and characteristics of the finished worksheet Discuss how the sketch (Figure 2-3 on page EX 85) helps determine the worksheets visual layout and design CLASSROOM ACTIVITIES 1. Quick Quiz: 1) Name at least 3 decisions to make before determining the appearance and characteristics of the worksheet for this chapter. (Answer: 1) Plan the layout of the worksheet, 2) Determine the necessary formulas and functions needed, 3) Identify how to format various elements of the worksheet, 4) Establish rules for conditional formatting, 5) Specify how the printed worksheet should appear, 6) Gather information regarding the needed Web query, and 7) Choose names for the worksheets. 2. Group Activity: Have the class brainstorm about the circumstances in which they would choose to have a cell stand out from similar cells and determine in what way the cell will stand out. For example, placing a different background color in cells that show losses could be an appropriate format for a column. EX 87: Entering the Titles and Numbers into the Worksheet LECTURE NOTES Using the steps, discuss how to enter titles: worksheet title and subtitle, column and row titles Refer to the steps and Table 2-1 to discuss how to enter portfolio summary data Describe how to format and change workbook properties Using the steps, illustrate how to change workbook properties and save the workbook FIGURE: 2-4 BOXES: 1. BTW: Wrapping Text. Mention how to wrap lengthy text within a cell and that Excel automatically increases the cell height to accommodate the text. 2. BTW: Two-Digit Years. Explain that Excel has internal calculations to covert a two-digit year to the correct four-digit year. Provide an example of a year from 19xx and a year from 20xx. 3. BTW: Formatting a Worksheet. Explain that Excel allows the user to increase vertical white space to improve the appearance. 4. BTW: Entering Numbers in a Range. Describe how Excel automatically moves the active cell during entry of data in a selected range. CLASSROOM ACTIVITIES 1. Quick Quiz: 1) If a cell A3 contains a word that has 6 characters, such as Stocks and cell A8 contains 5 words causing the text to wrap within the cell, what effect does this have on cell A3? (Answer: The height of cell A3 would be increased due to the height that cell A8 required for text.) 2) Quick Quiz: When the cursor is in a cell and you click the right arrow, what happens to the cursor? (Answer: It moves to the next cell to the right.) LAB ACTIVITIES 1. Have students research the Web for information about Excel tips for working with worksheets, ranges of numbers, and using Excel for Web queries. Have them bring their most interesting tip to share with the class. EX 90: Plan Ahead Box (Critical Thinking): Determine the Necessary Formulas and Functions Needed LECTURE NOTES Review the formulas that are used in this chapter and that are noted in the requirements document. CLASS ACTIVITIES 1. Group Activity: Ask the students, in a group discussion, which formulas would produce a negative value and why. For example, the current value minus the initial cost could cause a negative value if an item cost more to purchase than it would be to sell at current prices. 2. Project to Assign: Have students spend 10-15 minutes to study the formulas that will be used and compare them to how the formulas are used in Figures 2-5 and 2-6. EX 90: Entering Formulas LECTURE NOTES Explain the functions and formulas (and operators) for the project and how to enter them with different modes. Using Figures 2-5 and 2-6 illustrate how to enter a formula using the keyboard Use Table 2-2 to summarize arithmetic operations Use Table 2-3 to illustrate examples of Excel formulas Use Figures 2-7 through 2-10 to illustrate entering formulas using Point mode Use Figures 2-11 through 2-13 to illustrate how to copy formulas using the fill handle Introduce smart tags. and option buttons using Table 2-4 Describe SUM functions, percent gains, and losses Use Figure 2-15 to determine the total percent gain/loss FIGURES: 2-5, 2-6, 2-7, 2-8, 2-9, 2-10, 2-11, 2-12, 2-13, 2-14, 2-15 TEACHER TIPS One common error is to create a formula with a circular reference. This occurs when a cell reference in a formula refers to the formulas result. For example, the formula = B1 + B2 + B3 in cell B3 is a circular reference because the result of the formula in cell B3 depends on the value in cell B3. Therefore, Excel is unable to determine the formulas result. When a formula with a circular reference is entered, Excel immediately points out the problem and offers Help. BOXES: 1. BTW: Automatic Recalculation. Indicate that Excel automatically recalculates all cells affected by number entry in the active cell but this feature can be overridden to allow for manual recalculation of those cells. 2. BTW: Troubling Formulas. Explain how to work around and then resolve problems encountered due to the equals sign. 3. BTW: Selecting a Range. Describe how to use the keyboard to select a range and how to toggle between selecting and turning off selection of the range. 4. BTW: Entering Functions. Describe how to hide or move the Function Arguments dialog box. 5. Other Ways: Review the other ways of copying and pasting from source to destination areas. CLASSROOM ACTIVITIES 1. Critical Thinking: As students work through this chapter, encourage them to recognize the symbiotic relationship between formulas and worksheets. 2. Class Discussion: Cell references are an integral part of a formula. When the value in a cell changes, the result of the formula used with that cell automatically changes. Therefore, specific numbers should be used in formulas only if they are constants (i.e., if they will not change). What are some examples in which entering specific numbers in formulas would be appropriate? 3. Group Activity: Explore the effect of parentheses by presenting an expression, such as 3 * 4 ^ 2 - 12 / 2 + 1, evaluating it using the order of operations (43), then adding parentheses in one or more places, such as (3 * 4) ^ 2 - 12 / (2 + 1), and reevaluating the expression (140), noting how the result has changed. Write the following expression on the board: 6 * 2 ^ 4 - 12 / 3 + 1 Have students determine all of the different values that can be derived from this expression, depending on where pairs of parentheses are placed. EX 98: Using the AVERAGE, MAX, and MIN Functions LECTURE NOTES: Introduce functions and arguments Examine the functions AVERAGE, MAX, and MIN and their arguments Use Figures 2-16 through 2-18 to determine the average of a range of numbers using the keyboard and mouse Discuss entry of functions into the worksheet and show examples Use Figures 2-19 through 2-21 to illustrate how to determine the highest number in a range of numbers using the Insert Function box Use Figures 2-22 through 2-25 to determine the lowest number in a range of numbers using the Sum menu Demonstrate the fill handle to copy a range to another range Use Figures 2-26 through 2-28 to copy a range of cells across columns to an adjacent range using the fill handle Review the steps to save a workbook using the same file name FIGURES: 2-16, 2-17, 2-18, 2-19, 2-20, 2-21, 2-22, 2-23, 2-24, 2-25, 2-26, 2-27, 2-28 BOXES: 1. BTW: Statistical Functions. Illustrate how the statistical functions ignore blank (value 0) cells in calculations. 2. Other Ways: Review the alternate ways to implement the AVERAGE function. 3. Other Ways: Emphasize the alternative ways of using the MAX function. 4. Other Ways: Review the other ways to use the MIN function. 5. Other Ways: Review the other ways to move things to a destination area. TEACHER TIPS Arguments can be numbers, text, logical values (such as TRUE or FALSE), constants, arrays (specially arranged groups of constants or areas of cells), error values (such as #N/A), cell references, formulas, or other functions. The argument designated must produce a valid value for that function. CLASSROOM ACTIVITIES 1. Critical Thinking: Sometimes, it is just as easy simply to scan a list and pick out the highest value as it is to use the MAX function. Consider various numerical lists, such as a list of the ages of family members, a list of class grades, a list of stock prices, a list of the areas of states, a list of city populations, and so on. When would it make more sense to use the MAX function than simply to scan the list to determine the highest value? Why? Does the answer depend on the amount of data, the type of data, or both? Why? 2. Quick Quiz: 1) With Excel, you can enter functions using any of five methods. What are they? (Answer: 1) the keyboard or mouse, 2) the Insert Function box in the formula bar, 3) the Sum menu, 4) the AutoSum command on the Formulas tab on the Ribbon, and 5) the Name box area in the formula bar.) LAB ACTIVITIES 1. Have the students work in small groups. Have each group select six stocks two technology stocks, two retail stocks, and two bank stocks this can be done by researching on the Web. Each student should submit the stock names, their symbols, and a stock price of one year ago. Have each group create a sketch for a worksheet that lists the stock names, symbols, price, and number of shares for each stock (500 shares as the number of shares for all stocks). Have students suggest ways to format the worksheet by listing formatting suggestions directly on the sketch. EX 106: Verifying Formulas Using Range Finder LECTURE NOTES Explain how the Range Finder works to verify formulas Use Figure 2-29 to illustrate how to verify a formula using Range Finder FIGURE: 2-19 CLASSROOM ACTIVITIES Quick Quiz: You use Range Finder to verify that a formula contains the intended cell references. Double-click the cell with the formula you want to check. How does Excel respond? (Answer: Excel responds by highlighting the cells referenced in the formula so you can check that the cell references are correct. Cells referenced in the formula in the active cell are highlighted with corresponding colors; the color of cell references corresponds to the color of the highlighted cells.) EX 107: Formatting the Worksheet LECTURE NOTES Introduce theme as a predefined set of formatting elements Use Figures 2-31 and 2-32 to illustrate changing workbook themes Review the steps to format the worksheet titles Use Figures 2-34 through 2-37 to illustrate changing the background color and applying a box border to the worksheet title and subtitle Use Figure 2-38 to discuss cell styles and applying them to headings Review the steps for formatting numbers, centering data, and formatting dates Explain the Accounting Number Format and Comma Style format Use Figures 2-41 through 2-43 to illustrate applying an Accounting Style Format and Comma Style format using the Ribbon Using the steps, discuss Currency and formatting and decimals Use Figure 2-47 to illustrate applying a Percent Style format and using the Increase Decimal button Use Figures 2-48 through 2-52 to illustrate applying conditional formatting Refer to Table 2-5 to summarize conditional formatting relational operators Using Figures 2-53 through 2-57, discuss changing the widths of columns Using Figures 2-58 through 2-60, describe changing the heights of rows FIGURES: 2-30a, 2-30b, 2-31, 2-32, 2-33, 2-34, 2-35, 2-36, 2-37, 2-38, 2-39, 2-40, 2-41, 2-42, 2-43, 2-44, 2-45, 2-46, 2-47, 2-48, 2-49, 2-50, 2-51, 2-52, 2-53, 2-54, 2-55, 2-56, 2-57, 2-58, 2-59, 2-60 BOXES: 1. BTW: Colors. Discuss how colors have different effects on peoples moods and feelings. Knowing this information can help the students determine what colors to use in a worksheet. 2. BTW: Background Colors. State again how color affects mood and feelings. 3. BTW: Rotating and Shrinking Entries in Cells. Discuss the capability of manipulating the position and size of cell entries. 4. BTW: Conditional Formatting. Briefly describe how this affects different levels of a workbook. 5. BTW: Hidden Columns. Explain how to display the hidden columns. 6 BTW: Hidden Rows. Describe how to hide/unhide a range of rows. 7. Other Ways: Describe three other ways to format worksheets. 8. Other Ways: Describe two other ways to format on the tabs. 9. Other Ways: Review the other ways to apply a Currency Style format. 10. Other Ways: Explain the three other ways to show percents. 11. Other Ways: Describe two other ways to modify the width. 12. Other Ways: Describe another way to hide a row. TEACHER TIPS In many financial documents, such as this worksheet, dollar signs ($) are displayed only in the first row where values appear and in the summary rows (e.g., total, average, highest, and lowest). CLASSROOM ACTIVITIES 1. Group Activity: Hold up various color chips (from the paint store, for example) or a color wheel, or point to a color in Excels Theme or Standard Colors gallery). Ask the students to write down what mood this color puts them in, and what is the first thing they think of when they see this color. Do about four or five colors. Have the class share their results. 2. Critical Thinking: Think about background colors for text. Do they interfere with thinking? Do they really enhance a worksheet or detract from it? Think about borders. Do they feel too confining or do they help to group some idea or related group of data? Think about the position of text headings in a column. Do they look better centered within the cell or better left-aligned? How would their position affect the contents of the column they head? For example, would a centered heading look good at the top of a column of right-aligned numbers? Would a left-aligned heading look good over a right-aligned column of numbers? 3 Group Activity: Ask each student to choose which of the following statements best represents his or her opinion: It is better to change fonts before any data is entered. It is better to change fonts as you enter data. It is better to change fonts after all the data is entered. Divide the class into three groups based on their choice. Ask each group to prepare a defense of their choice. Conduct an informal debate among the three groups. EX 108: Plan Ahead Box (Critical Thinking): Identify How to Format Various Elements of the Worksheet. LECTURE NOTES Use Figure 2-3 of the sketch on page EX 85 to review the formatting elements in the list as suggested by the sketch. CLASSROOM ACTIVITIES 1. Quick Quiz: 1) What is the measurement unit for the row heights?(Answer: points) 2) What is the measurement unit for the column widths? (Answer: characters) 2. Critical Thinking: Does the light red background suggested for negative percentages help the reader differentiate from the positive numbers more easily? What would happen if the reader wants to print the spreadsheet on a black and white printer? Would the negative percentages show up as clearly as the spreadsheet specialist had in mind? EX 127: Checking Spelling LECTURE NOTES Introduce the spell checker and how to use it Use Figures 2-61 and 2-62 to illustrate checking spelling on the worksheet Review the spell checker considerations FIGURES: 2-61, 2-62 BOXES: 1. BTW: Spell Checking. Emphasize that students should always proofread their work because the automatic spell checking is not foolproof. 2. BTW: Error Checking. Discuss the Error Checking button and its use for validating formulas. 3. Other Ways: Describe the f7 keys function. CLASSROOM ACTIVITIES 1. Group Activity: Discuss that when spell checkers first became available, they did not recognize first names and suggested some very unusual alternatives such as Dive for the name Dave and Start for Stewart. Brainstorm with the class about types of spelling errors that could easily be undetected by a spell checker. Also think of funny spelling suggestions that the students have seen offered by Microsoft Excel or other spell check programs. Quick Quiz: 1) What are some of the functions in the Spelling dialog box? (Answer: Ignore Once, Ignore All, Add to Dictionary, Change (instance), Change All, AutoCorrect, Language selection, more Options) EX 129: Plan Ahead Box (Critical Thinking): Specify How the Printed Worksheet Should Appear. Discuss some of the limitations and aspects of printing: Describe that the paper is only a fixed size so planning the worksheet should account for size. Define portrait and landscape orientation. CLASSROOM ACTIVITIES 1. Group Activity: Brainstorm about situations for which portrait orientation would be an acceptable presentation format for a worksheet. 2. Quick Quiz: What happens to a worksheet if more data is added to the page than fits on the page? (Answer: Excel extends it to multiple pages) EX 129: Preparing to Print the Worksheet LECTURE NOTES Introduce the terms Page Layout View and Normal View, portrait orientation, and landscape orientation Use Figures 2-63 through 2-67 to illustrate changing the worksheets margins, header, and orientation in Page Layout View FIGURES: 2-63, 2-64, 2-65, 2-66, 2-67 BOXES: 1. BTW: Certification. For more information on the MCAS program see Appendix F or visit the Excel 2007 Certification Web page. 2. Other Ways: Describe the other way to adjust layout settings. CLASSROOM ACTIVITIES 1. Quick Quiz: What is the difference between Page Layout View and Normal View? (Answer: Page Layout View allows you to create or modify a worksheet while viewing how it will look in printed format. The default view that you have worked in up until this point in the book is called Normal View.) What is the difference between landscape orientation and portrait orientation? (Answer: Portrait orientation means the printout is printed across the width of the page. Landscape orientation means the printout is printed across the length of the page.) 2. Assignment: Visit the Excel 2007 Certification Web page (scsite.com/ex2007/cert). Print out or list the requirements for becoming certified.) EX 132: Previewing and Printing the Worksheet LECTURE NOTES Discuss print preview and options Use Figures 2-68 through 2-71 to illustrate previewing and printing a worksheet Use Figures 2-72 and 2-73 to describe how to print sections of a worksheet FIGURES: 2-68, 2-69, 2-70, 2-71, 2-72, 2-73 BOXES: 1. Other Ways: Describe another way to modify the print options. 2. Other Ways: Describe another way to print an area of the worksheet. CLASSROOM ACTIVITIES 1. Class Discussion: Discuss the other ways to change the print options. 2. Quick Quiz: Which option button in the Print what area of the Print dialog box instructs Excel to print the worksheet currently on the screen? (Answer: The Active sheet(s) option button) Which option button in the Print what area of the Print dialog box instructs Excel to print all of the worksheets in the workbook? (Answer: The Entire workbook option button) EX 135: Displaying and Printing the Formulas Version of the Worksheet LECTURE NOTES Differentiate between printing a values version and formulas version worksheet Introduce the term debugging Use Figures 2-74 and 2-75 to illustrate displaying the formulas in the worksheet and fit the printout on one page Review the steps to change the Print Scaling option back to 100% FIGURES: 2-74, 2-75 BOXES: 1. BTW: Values versus Formulas. Explain that the formulas version prints the formulas rather than values of the cells. TEACHER TIPS The term debugging is said to have originated with famed computer programmer Grace Hopper (inventor of COBOL), who traced a computer malfunction to a bug (a moth) in the machine. CLASSROOM ACTIVITIES 1. Group Activity: Have the class look at Figure 2-74, which shows the formulas version of the worksheet. Ask the students how displaying the worksheet in this version might make it easier to find and correct errors? 2. Quick Quiz: What is displayed in the formulas version of the worksheet? (Answer: Formulas instead of values) How do you toggle between the values version and the formulas version of a worksheet? (Answer: Press ctrl+` (ctrl+accent mark)) How does Excel make a worksheet fit on one page when you choose the Fit to option? (Answer: Excel automatically changes to the percentage required to fit the printout on one page.) EX 137: Plan Ahead Box (Critical Thinking): Gather Information Regarding the Needed Web Query. LECTURE NOTES Use Table 2-6 to discuss the plan for importing data from a Web source with a Web query. EX 137: Importing External Data from a Web Source Using a Web Query LECTURE NOTES Introduce the term Web query Use Table 2-6 to discuss the three Web queries available when Excel is installed Use Figures 2-76 through 2-79 to illustrate importing data from a Web source using a Web query Explain how to import real time data from a Web site and show examples. FIGURES: 2-76, 2-77, 2-78, 2-79 BOXES: 1. BTW: Web Queries. Explain the relationship of the Web query and feeding data to another worksheet. 2. Other Ways: Describe another way to get the source data. TEACHER TIPS In addition to obtaining real-time stock quotes, major indices, and currency rates, Web queries can be used for many other purposes. For example, Web queries can be used to acquire the latest sales information from an e-commerce Web site. Web queries are suitable for almost any content that involves dynamic lists of data or tables of information. CLASSROOM ACTIVITIES 1. Group Activity: Ask for a show of hands who has heard of or used Web queries before with other programs? Ask students to name any. 2. Quick Quiz: What types of external data can be returned by the built-in Web queries in Excel? (Answer: Currency rates, major stock indices, and stocks) LAB ACTIVITIES 1. Encourage students to use a Web query to obtain up-to-date information on a topic of interest. Using a search engine and appropriate keywords, they should locate a Web site that has the required information readily available. Ideally, the site should have validity, reliability, and longevity. (Government or professional organization sites often offer a good source of useful information.) After locating a site, they should record the URL. Then, they should open a new Excel workbook and use the Import Data dialog box in Figure 2-77 to import the data. Have students print and turn in the worksheet that results, including the URL they used to obtain their information. EX 140: Plan Ahead Box (Critical Thinking): Choose Names for the Worksheets LECTURE NOTES Discuss the naming guidelines for reflecting the worksheet contents EX 140: Changing the Worksheet Names LECTURE NOTES Discuss the methods for renaming worksheets Use Figures 2-80 and 2-81 to illustrate changing worksheet names FIGURES: 2-80, 2-81 TEACHER TIPS Tab scrolling buttons do indeed allow you to move to different worksheets. If the number of worksheets in a workbook exceeds the ease of scrolling convenience, however, you can right-click on a worksheet tab to bring up a list of worksheet names. Then, to access the worksheet, simply select its name from the list. CLASSROOM ACTIVITIES: 1. Quick Quiz: What is the maximum number of characters for a worksheet name? (Answer: 31 characters, including spaces) Where are the tab scrolling buttons located? (Answer: To the left of the sheet tabs) 2. Group Activity: Divide the students into groups. Ask them to brainstorm in their groups about types of projects they can think of that would have multiple worksheets. Ask them to list the types of projects and the specific worksheet names they would use. EX 142: E-Mailing a Workbook from within Excel LECTURE NOTES Use Figures 2-82 and 2-83 to explain how to e-mail a workbook directly from Excel FIGURES: 2-82, 2-83 BOXES: 1. BTW: Obtaining an E-Mail Account. Discuss the free e-mail account sites. 2. BTW: Quick Reference. Point out the location for the Quick Reference Summary and the Excel 2007 Quick Reference Web page. TEACHER TIPS Students will be able to complete e-mailing an activity only if they have an e-mail address with Outlook, Outlook Express, Microsoft Exchange Client, or another 32-bit e-mail program compatible with Messaging Application Interface. CLASSROOM ACTIVITIES 1. Assign a Project: Explain to students that if they currently do not have an e-mail address, they can obtain a free one. Encourage students to use a search engine to find sources for free e-mail addresses, and follow the instructions to sign up. 2. Quick Quiz: What is the difference between the way sending a workbook through e-mail used to work and the way it works in Excel 2007? (Answer: In the past, if you wanted to e-mail a workbook, you saved the workbook, closed the file, started your e-mail program, and then attached the workbook to the e-mail message before sending it. With Excel, you have the capability of e-mailing a worksheet or workbook directly from within Excel.) End of Chapter Material Learn It Online is a series of online student exercises that test your knowledge of chapter content and key terms. Apply Your Knowledge is a student assignment that helps you to reinforce the skills and apply the concepts you learned in this chapter. Extend Your Knowledge is a student assignment that challenges you to extend the skills you learned in this chapter and to experiment with new skills. You may need to use Help to complete the assignment. Make It Right is a student assignment that requires you to analyze a presentation and correct all errors and/or improve the design. In the Lab (Lab): In the Lab is a series of student assignments that ask you to design and/or create a presentation using the guidelines, concepts, and skills presented in this chapter. The assignments are listed in order of increasing difficulty. Cases and Places is a series of student assignments where you apply your creative thinking and problem solving skills to design and implement a solution. Glossary of Key Terms Accounting Number Format (EX 114) arguments (EX 98) asterisk (EX 91) AVERAGE function (EX 99) best fit (EX 122 ) blank cell (EX 98) Comma Style format (EX 114) condition (EX 118) conditional formatting (EX 118) debugging (EX 135) e-mail (EX 142) fixed dollar sign (EX 114) floating dollar sign (EX 114) formula (EX 90) formulas version (EX 135) function (EX 82, EX 98) hiding cells (EX 122) landscape orientation (EX 129) MAX function (EX 101) MIN function (EX 102) Normal View (EX 129) order of operations (EX 92) Page Layout View (EX 129) pixel (EX 122 ) Point mode (EX 93) portrait orientation (EX 129) previewing the worksheet (EX 132) Range Finder (EX 106) relative cell references (EX 96) smart tag indicator (EX 96) smart tags (EX 96)  HYPERLINK \l "_Excel_2007" Top of Document spell checker (EX 127) theme (EX 107) values version (EX 135) Web query (EX 137)     Page  PAGE 22 of  NUMPAGES 16 Project 1: Creating a Worksheet and an Embedded Chart Excel 2007 Instructors Manual Page  PAGE 1 of  NUMPAGES 16 PPT 1. PAGE 1 $')YZwx}   ` c teYJe2eYe.hB h5>*B*CJOJQJXaJphhB hLCJOJQJaJhB CJOJQJaJhB hCJOJQJaJ"hB h 65;CJOJQJaJ"hB h \5;CJOJQJaJ"hB hsQ.5;CJOJQJaJ+hB hG5;B*CJ$OJQJaJ$ph+hB h~i5;B*CJ$OJQJaJ$ph+hB h~i5;B*CJ0OJQJaJ0ph%hXm5;B*CJ0OJQJaJ0phZ  02 $Ifgd Z!gd!#lgd gd7gda dgda$d-DM a$gd}e͌ΌЌ    ' ? @ A Z c Ě⚋qbS=*hB h!#5>*B*OJQJXaJphhB h CJOJQJaJh h CJOJQJaJh-ah 5OJQJaJhCJOJQJaJhB h60CJOJQJaJhB CJOJQJaJhB hvICJOJQJaJhB hTCJOJQJaJhB h(6CJOJQJaJhB hHsCJOJQJaJhB hCJOJQJaJhB hGCJOJQJaJ./0134Z[\abopqtݪݗraPaA2hB h`~CJOJQJaJhB hfGCJOJQJaJ hB h}e0JCJOJQJaJ hB hfG0JCJOJQJaJ+jhB hPxCJOJQJUaJhB hqCJOJQJaJ%jhB hqCJOJQJUaJhW~CJOJQJaJ hB hHs0JCJOJQJaJ+jhB h Z!CJOJQJUaJhB hHsCJOJQJaJ%jhB hHsCJOJQJUaJ23qs}t $Ifgd$ $IfgdfGykd$$Ifl0 !\ t044 lastIKIRkd$$Ifl0 !\ t44 la $Ifgd$ $IfgdfGRkd~$$Ifl0 !\ t44 latu  .GHLMnopuv춥݀춥j춥^h CJOJQJaJ+j)hB hPxCJOJQJUaJ+jhB hPxCJOJQJUaJhB h`~CJOJQJaJ hB h}e0JCJOJQJaJ hB hfG0JCJOJQJaJ+j hB hPxCJOJQJUaJhB hqCJOJQJaJ%jhB hqCJOJQJUaJKL13IRkd$$Ifl0 !\ t44 la $Ifgd$ $IfgdfGRkd$$Ifl0 !\ t44 la/01245VWX]^pqrsuv㭚udSdDDhB h`~CJOJQJaJ hB h}e0JCJOJQJaJ hB hfG0JCJOJQJaJ+jChB hPxCJOJQJUaJhB hqCJOJQJaJ%jhB hqCJOJQJUaJhB hW~CJOJQJaJ hW~hW~0JCJOJQJaJ+j9hW~hbCJOJQJUaJhW~CJOJQJaJjhW~CJOJQJUaJ34rtuIRkd$$Ifl0 !\ t44 la $Ifgd$ $IfgdfGRkd$$Ifl0 !\ t44 la#$HIJPQjklmopŴ֥֖Ŵ֥֖jŴ֥^Njh.CJOJQJUaJh CJOJQJaJ+jq hB hPxCJOJQJUaJ+j]hB hPxCJOJQJUaJhB hqCJOJQJaJhB h`~CJOJQJaJ hB h}e0JCJOJQJaJ hB hfG0JCJOJQJaJ%jhB hqCJOJQJUaJ+jShB hPxCJOJQJUaJ "#lnIRkd$$Ifl0 !\ t44 la $Ifgd$ $IfgdfGRkd$$Ifl0 !\ t44 lano;>IRkd $$Ifl0 !\ t44 la $Ifgd$ $IfgdfGRkd $$Ifl0 !\ t44 lap &'9:;=?νήveTeE9Eh CJOJQJaJhB h`~CJOJQJaJ hB h}e0JCJOJQJaJ hB hfG0JCJOJQJaJ+j hB hPxCJOJQJUaJhB hqCJOJQJaJ%jhB hqCJOJQJUaJhB h.CJOJQJaJ h.h.0JCJOJQJaJjh.CJOJQJUaJ+j h.h3{CJOJQJUaJh.CJOJQJaJ>?IRkd" $$Ifl0 !\ t44 la $Ifgd$ $IfgdfGRkd $$Ifl0 !\ t44 la?@_`a㭚udSdD5hB hW~CJOJQJaJhB h`~CJOJQJaJ hB h}e0JCJOJQJaJ hB hfG0JCJOJQJaJ+j hB hPxCJOJQJUaJhB hqCJOJQJaJ%jhB hqCJOJQJUaJhB hT%CJOJQJaJ hT%hT%0JCJOJQJaJ+j hT%h3{CJOJQJUaJhT%CJOJQJaJjhT%CJOJQJUaJ<=>DEklmnoqríҜ|fҜ|ZJjh3{CJOJQJUaJh CJOJQJaJ+jhB hPxCJOJQJUaJhB hW~CJOJQJaJ hB h}e0JCJOJQJaJ hB hfG0JCJOJQJaJ+jhB hPxCJOJQJUaJhB hqCJOJQJaJ%jhB hqCJOJQJUaJhB h`~CJOJQJaJhW~CJOJQJaJmpqIRkdL$$Ifl0 !\ t44 la $Ifgd$ $IfgdfGRkd6$$Ifl0 !\ t44 lafijIRkdn$$Ifl0 !\ t44 la $Ifgd$ $IfgdfGRkdb$$Ifl0 !\ t44 ladefhjkνήjYHY9hB h`~CJOJQJaJ hB h}e0JCJOJQJaJ hB hfG0JCJOJQJaJ+jhB hPxCJOJQJUaJhB hqCJOJQJaJ%jhB hqCJOJQJUaJhW~CJOJQJaJhB h3{CJOJQJaJ h3{h3{0JCJOJQJaJjh3{CJOJQJUaJ+jh3{h3{CJOJQJUaJh3{CJOJQJaJGHIKMNpqrxƺƓƄqbLq; hB hfG0JCJOJQJaJ+jhB hPxCJOJQJUaJhB hqCJOJQJaJ%jhB hqCJOJQJUaJhB h#CJOJQJaJ h#h#0JCJOJQJaJ+jh#hbCJOJQJUaJh#CJOJQJaJjh#CJOJQJUaJhB h`~CJOJQJaJhW~CJOJQJaJhB hW~CJOJQJaJILMIRkd$$Ifl0 !\ t44 la $Ifgd$ $IfgdfGRkd$$Ifl0 !\ t44 laxy 78˼˒|˼iZDii+jChB h=CJOJQJUaJhB h}eCJOJQJaJ%jhB h-CJOJQJUaJ+j/hB hPxCJOJQJUaJhB hqCJOJQJaJhW~CJOJQJaJhB hW~CJOJQJaJhB h`~CJOJQJaJ%jhB hqCJOJQJUaJ hB hfG0JCJOJQJaJ hB h}e0JCJOJQJaJ:=RRkd$$Ifl0 !\ t44 la $Ifgd$Rkd$$Ifl0 !\ t44 la89:;<>?WXYnopqrtuxⴥ~o`YR91hB h8o5;>*B*CJOJQJXaJph hB hq hB hHshB hqCJOJQJaJhB h,\CJOJQJaJ hB h-0JCJOJQJaJ+jchB hCJOJQJUaJhB hCJOJQJaJ%jhB h-CJOJQJUaJhW~CJOJQJaJhB hW~CJOJQJaJhB h`~CJOJQJaJhB h-CJOJQJaJ=>pstuvwxRMMMMgdHsRkd$$Ifl0 !\ t44 la $Ifgd$Rkd$$Ifl0 !\ t44 lamn  56kl;zb/hB hfG56>*B*OJQJX\]phhB hsQ.OJQJhB h/CJOJQJaJhB CJOJQJaJhB h%CJOJQJaJhB hGCJOJQJaJhB hsQ.CJOJQJaJ1hB hsQ.5;>*B*CJOJQJXaJph1hB h~5;>*B*CJOJQJXaJphx.ZI & FEƀlgd%I & FEƀlgd%gdsQ. dxgdsQ..Rnk!I & FEƀlgd%I & FEƀlgd%I & FEƀlgd% k!I & FEƀlgd%I & FEƀlgd%I & FEƀlgd% 6lk!I & FEƀ lgd%I & FEƀ lgd%I & FEƀ lgd%aI & FEƀgdngdfGgdsQ.I & FEƀ lgdsQ. !9:;vϷyhWhyhyFyFyFyF hB hnCJOJQJ^JaJ hB hTCJOJQJ^JaJ hB h}eCJOJQJ^JaJ hB hnCJOJQJ^JaJhB h}eCJOJQJaJhB hsQ.CJOJQJaJhB h~CJOJQJaJ/hB hsQ.56>*B*OJQJX\]ph/hB hfG56>*B*OJQJX\]ph/hB h}e56>*B*OJQJX\]ph!cN & F7$8$EƀoH$gd}eN & F7$8$EƀH$gdn!:XcN & F7$8$EƀoH$gd}eN & F7$8$EƀoH$gd}evz:;HIRVz~$/͵vgXIXIXgXIXI:I:hB hCJOJQJaJhB h}eCJOJQJaJhB hqCJOJQJaJhB hCJOJQJaJhB h~CJOJQJaJ/hB hsQ.56>*B*OJQJX\]ph/hB h}e56>*B*OJQJX\]ph/hB hfG56>*B*OJQJX\]ph hB h~kCJOJQJ^JaJ hB hnCJOJQJ^JaJ hB h}eCJOJQJ^JaJXcN & F7$8$EƀoH$gd}eN & F7$8$EƀoH$gd}ecN & F7$8$EƀoH$gd}eN & F7$8$EƀoH$gd}e;I]I & FEƀgdgdsQ.gdfGN & F7$8$EƀoH$gd}e0k!I & FEƀgdI & FEƀgdI & FEƀgd/01:NPUVWZ_y{tux}!"ⵦxiXIxiX:hB hh_8CJOJQJaJhB h*CJOJQJaJ hB h CJOJQJ^JaJhB h CJOJQJaJhB hc~6CJOJQJaJhB hc~CJOJQJaJhB hMCJOJQJaJhB hTCJOJQJaJhB hXYCJOJQJaJhB h`tCJOJQJaJhB h$CJOJQJaJhB hCJOJQJaJhB hqCJOJQJaJ01OPWtu!"/& ' < !! #N#\#gd$gdTgd$gd -DM gdh_8gdh_8gdc~ 7$8$H$gd gdgdsQ."-./% & ' < > ? O !!!!!!" """""ufffWfuHfHfHfhB h DCJOJQJaJhB hnCJOJQJaJhB h}eCJOJQJaJhB h>lCJOJQJaJhB hq\CJOJQJaJhB hTCJOJQJaJhB hCJOJQJaJhB h#{CJOJQJaJhB hCJOJQJ]aJhB hCJOJQJaJhB h}eCJOJQJ]aJhB hh_8CJOJQJ]aJ"""# ##3#M#N#[#\#######$$A$B$C$F$$$'%(%d%e%ӾvvvvgXIIhB hcCJOJQJaJhB hTCJOJQJaJhB hO9CJOJQJaJhB hCJOJQJaJhB h8oCJOJQJaJ)hB h56>*B*OJQJXph)hB h}e56>*B*OJQJXph)hB hfG56>*B*OJQJXphhB hCJOJQJaJhB h}eCJOJQJaJhB h DCJOJQJaJ\##$$4$C$'&kf`ZE <0^`gdc$gd D$gdngdI & FEƀgdI & FEƀgde%%%%%%%%&&&&'&(&+&9&:&;&[&`'e'f'''ĵq\qJ#hB 56>*B*OJQJXph)hB hc56>*B*OJQJXph)hB hfG56>*B*OJQJXph hB hCJOJQJ^JaJhB hCJOJQJaJhB hO9CJOJQJaJhB h8CJOJQJaJhB hnCJOJQJaJhB h%CJOJQJaJhB hcCJOJQJaJhB h DCJOJQJaJ'&(&`''' (Z(XI & FEƀgdI & FEƀgdgdgd 7$8$H$gd'''' (/(q(((((((((((())))ĵӵ⦗yj[K[<hB hqCJOJQJaJhB hc~6CJOJQJaJhB hc~CJOJQJaJhB hMCJOJQJaJhB h%CJOJQJaJhB hJCJOJQJaJhB h`tCJOJQJaJhB hJ~CJOJQJaJhB hkMCJOJQJaJhB hCJOJQJaJhB hcCJOJQJaJhB hCJOJQJaJhB h8oCJOJQJaJZ((((((())N*O**kffffaaaaagdc~gdI & FEƀgdI & FEƀgd )))))))))))**M*N*O*R*W*m*n*o*********T+U+V+{l]hB hlCJOJQJaJhB hkCJOJQJaJhB h7CJOJQJaJhB h*CJOJQJaJhB hcCJOJQJaJhB hqCJOJQJaJhB hc~6CJOJQJaJhB hMCJOJQJaJhB CJOJQJaJhB hc~CJOJQJaJhB hivCJOJQJaJ**U+V+k+l+{+,/-0-?-..y..gdgd <0^`gdc 0^`gdi` 0gdi`gdgdc~V+k+l+m+n+o+y+z+~+,,,,,,-.-/-0->-?-F--..[.񵦗ĦymU/hh>`56>*B*OJQJX\]phh>`CJOJQJaJhB hcCJOJQJaJhB hh CJOJQJaJhB hcCJOJQJaJhB hTCJOJQJaJhB h TCJOJQJaJhB hO9CJOJQJaJhB h;5CJOJQJaJhB h$CJOJQJaJhB hi`CJOJQJaJ[.c.y.0000000000N12222{leVG8VhB hJOJQJaJhB hT,~CJOJQJaJhB hcCJOJQJaJ hB h[hB h8oCJOJQJaJ)hB hc56>*B*OJQJXph)hB hfG56>*B*OJQJXphhB CJOJQJaJhhEJCJOJQJaJhh>`CJOJQJaJ/hh>`56>*B*OJQJX\]ph/hh!@56>*B*OJQJX\]ph....000000gd8ogdc 0^`gdi`gdI & FEƀgd 0N111k!I & FEƀgd & FEƀgd & F Eƀgd[12S22k!I & FEƀgd & FEƀgd & FEƀgd[22222223 33M3N3O3X3333333x5y5z5{5555ӵyjj[LLhB h(jmCJOJQJaJhB hLCJOJQJaJhB h@?#CJOJQJaJhB h(6CJOJQJaJhB hGCJOJQJaJhB h`tCJOJQJaJhB hKCJOJQJaJhB hcCJOJQJaJhB hJCJOJQJaJhB hJOJQJaJhB hcCJOJQJaJhB h%CJOJQJaJ223N3k!I & FEƀgd & FEƀgd & FEƀgd[N3O3333z5{55]6^666n7o777*8+8@888T:U:l<<gdv6%$gdq\gdcgdc~gdnU -DM gdLgdc55555\6]6^6_6a6f6x6y666666666m7n7o7p7r7w777777*8+8ⴥⴥxⴥiZZhB h(jmCJOJQJaJhB h_CJOJQJaJhB hbSCJOJQJaJhB h{ >CJOJQJaJhB hMCJOJQJaJhB hcCJOJQJaJhB h*CJOJQJaJhB hnZCJOJQJaJhB hc~6CJOJQJaJhB hc~CJOJQJaJhB h+CJOJQJaJ!+8U8V8b8n8888888888'9/999G:S:T:l<q<񸩚|mm]mN9)hB hfG56>*B*OJQJXphhB hgCJOJQJaJhB h+i6CJOJQJaJhB h+iCJOJQJaJhB hTCJOJQJaJhB hqCJOJQJaJhB hGCJOJQJaJhB hwCJOJQJaJhB hnUCJOJQJaJhB h;5CJOJQJaJhB h]CJOJQJaJhB CJOJQJaJhB hq\CJOJQJaJq<r<<<<<<<< =="=x===>>>>?????ôxiZixiZK<hB hc~CJOJQJaJhB h`tCJOJQJaJhB hv6%CJOJQJaJhB hcCJOJQJaJhB h%CJOJQJaJhB h2+CJOJQJaJhB hJCJOJQJaJhB hT,~CJOJQJaJhB h8oCJOJQJaJ#hB 56>*B*OJQJXph)hB hfG56>*B*OJQJXph)hB hc56>*B*OJQJXph<<<=fI & FEƀgdJI & FEƀ gdJgd8o=x==<>k!I & FEƀgdv6%I & FEƀgdv6%I & FEƀgdv6%<>>>P?k!I & FEƀ gdv6%I & FEƀ gdv6%I & FEƀgdv6%P??????b@c@@@@@8A9AAAgd{'=gdMNgdwgd[i 0gdv6%I & FEƀ gdv6%?????? @ @ @a@b@c@d@f@q@r@@@@@@@@@@8A9A:A*B*OJQJXph)hB h=56>*B*OJQJXph)hB hfG56>*B*OJQJXphhB hZCJOJQJaJhB hw*CJOJQJaJhB h`lCJOJQJaJhB h=CJOJQJaJhB h<^CJOJQJaJhB hFiCJOJQJaJ hB h`lCJOJQJ^JaJHHII"I&I'I(I=IGIHIIIQIIIIIIIfJĵĥueTCTCT2T hB h\sCJOJQJ^JaJ hB h=CJOJQJ^JaJ hB hCJOJQJ^JaJhB hCJOJQJ]aJhB h=CJOJQJ]aJhB hTCJOJQJ]aJhB h CJOJQJ]aJhB hGCJOJQJ]aJhB h`tCJOJQJaJhB h CJOJQJaJhB hTvCJOJQJaJhB h=CJOJQJaJhB h CJOJQJaJHHII'I(I=IIIkffQQH 7$8$H$gd= 0^`gd gd I & FEƀ gd I & FEƀ gd fJrJsJyJJJJJJJJK KKK K!K"K(K)KCKQKZKKKKKLLLM񯚯|m^mmOhB h8-CJOJQJaJhB h CJOJQJaJhB h@ CJOJQJaJhB hT,~CJOJQJaJhB h8oCJOJQJaJ)hB h=56>*B*OJQJXph)hB hfG56>*B*OJQJXphhB h=CJOJQJaJhB h<^CJOJQJaJhB h\sCJOJQJaJhB hCJOJQJaJII"KCKQKK]I & FEƀgd gd8ogd N & F 7$8$Eƀ)H$gd%KKKLk!I & FEƀgd I & FEƀgd I & FEƀgd LLMTMk!I & FEƀgd I & FEƀgd I & FEƀgd MMMLMMMM NnNNNOOO_PaPgPhPiPjPlPqPwPxPyP񵦵|m^N^?hB h[CJOJQJaJhB hc~6CJOJQJaJhB hc~CJOJQJaJhB hMCJOJQJaJhB h*CJOJQJaJhB CJOJQJaJhB hY/CJOJQJaJhB h`tCJOJQJaJhB h CJOJQJaJhB h<CJOJQJaJhB h=CJOJQJaJhB h@ CJOJQJaJhB h8-CJOJQJaJTMM NnNk!I & FEƀgd I & FEƀgd I & FEƀgd nNNONOk!I & FEƀgd I & FEƀgd I & FEƀgd NOOO`PaPhPiPQ QlQmQQQORPRRRRRSgd=gdc~gd I & FEƀgd yPQQ Q!Q#Q(Q9Q:Q;QkQlQmQuQQQ RXRfRRRRRRRRRSSSSSSS$S%S.Sĵ▇{kkkkĵ{\\ĵ{hB h<CJOJQJaJhB h=6CJOJQJaJhB CJOJQJaJhB h5CJOJQJaJhB h[CJOJQJaJhB hc~6CJOJQJaJhB hMCJOJQJaJhB h=CJOJQJaJhB h*CJOJQJaJhB hc~CJOJQJaJhB h9CJOJQJaJ$SSTSUSSSSSTTOTPT]T U!U6UVVYYYgd-gdc!gdG$ 0^`gd  0-DM ^`gd-gd gdc~.S2SSSTSSSSSSSSSSSSSSSSSSSTTTTTT*T+TNTөċө|ċm^hB hQ;CJOJQJaJhB h[CJOJQJaJhB h%CJOJQJaJhB h=CJOJQJaJhB h{cCJOJQJaJhB CJOJQJaJhB hMCJOJQJaJhB h*CJOJQJaJhB hc~CJOJQJaJhB h5CJOJQJaJhB h<CJOJQJaJNTPT[T\T]TU U!U5U6U9UGUHUUUUV#VlVqVtVyV²teVeGeG8G8G8hB h<CJOJQJaJhB hZDCJOJQJaJhB hTCJOJQJaJhB h<^CJOJQJaJhB hGCJOJQJaJhB h CJOJQJ]aJhB hGCJOJQJ]aJhB h-CJOJQJaJhB hDuCJOJQJ]aJhB hDuCJOJQJaJhB h=CJOJQJ]aJhB h-CJOJQJ]aJhB hY/CJOJQJaJyVVVVVX#XYYYYZZ<[J[Y[u[y[[[[[[[[[[\!\'\(\ӵӵөvj^jv^vjO^O^O^O^OhB hh&\CJOJQJaJhh&\CJOJQJaJh!CJOJQJaJh!h!CJOJQJaJ/h!h!56>*B*OJQJX\]phh-CJOJQJaJhB CJOJQJaJhB h-CJOJQJaJhB hc!CJOJQJaJhB hnCJOJQJaJhB hGCJOJQJaJhB hZDCJOJQJaJYYYSU & F 88Eƀ()^8`gdCmU & F 88Eƀ()^8`gdCmY4ZZ<[J[[[PI & FEƀgdh&\gd!gd!gd-U & F 88Eƀ()^8`gdCm[[[)\u\v\]]]"^|I & FEƀgdGgd8ogdG 0^`gdh&\gdh&\ 0^`gdh&\ (\t\u\v\]]]]]]]!^l^m^^^^^^ʵsdUsUFU7hB hHsCJOJQJaJhB h`tCJOJQJaJhB hGCJOJQJaJhB h<CJOJQJaJhB hWdCJOJQJaJhB hT,~CJOJQJaJhB h8oCJOJQJaJ)hB h<56>*B*OJQJXph)hB hfG56>*B*OJQJXphhB h.CJOJQJaJh.CJOJQJaJhB hh&\CJOJQJaJhh&\CJOJQJaJ"^m^^^^^^<_=___kffffaaaagd<gdGI & FEƀgdGI & FEƀgdG ^^^^^E_S_____________6`:`}``ӴwӇhYJ;;hB h,HeCJOJQJaJhB hJCJOJQJaJhB hdjCJOJQJaJhB hUMCJOJQJaJhB h<:CJOJQJaJhB hLCJOJQJaJhB hc~CJOJQJaJhB hMCJOJQJaJhB hHCJOJQJaJhB h<6CJOJQJaJhB h<CJOJQJaJhB hGCJOJQJaJhB h%CJOJQJaJ____aaavbb c[I & FEƀgd}~gd. 0^`gd<  0gd<$ 0gd<gdJ 0^`gdGgdGgdc~ ``````aa)aaaaaaaaubvbbbb cclcmcsctcccĴ⥙rfrfrfZfrNh.CJOJQJaJhmCJOJQJaJh}~CJOJQJaJhB h.CJOJQJaJ/h.h.56>*B*OJQJX\]phhdjCJOJQJaJhB h*CJOJQJaJhB h<CJOJQJ]aJhB hdjCJOJQJaJhB hJCJOJQJaJhB h<CJOJQJaJhB h,HeCJOJQJaJ cmcccckVA 0^`gdm 0h^h`gd.I & FEƀogd}~I & FEƀogd}~cc9dGdHdddddddddee6e@eLe[egeheeeƷ~o`QBQBoBohB h<CJOJQJaJhB h }CJOJQJaJhB hT,~CJOJQJaJhB h+uCJOJQJaJhB h8oCJOJQJaJ)hB h<56>*B*OJQJXph)hB hfG56>*B*OJQJXphhB hdCJOJQJaJhB hdCJaJhdCJaJhdCJOJQJaJhmCJOJQJaJhB hmCJOJQJaJc8d9dHddddeheHI & FEƀgd+ugd8ogd+uN & F 7$8$Eƀ)H$gdd 0h^h`gdmheee f ffffffff 7$8$H$gd'h 0^`gd,?sgdc~gd+uI & FEƀ gd+u ef fffffff&f'f(f+f,f@fQfTf`frfffffffffĵxiĦZZZKZhB h*CJOJQJaJhB hk.CJOJQJaJhB h&8CJOJQJaJhB hc~6CJOJQJaJhB hc~CJOJQJaJhB hMCJOJQJaJhB h<CJOJQJaJhB hdjCJOJQJaJhB h%CJOJQJaJhB hHsCJOJQJaJhB h+uCJOJQJaJhB h`tCJOJQJaJffffffffffAgQgRgh hhhh/h0hIhRhhhih i iiӹzmmbbbZKhB hdjCJOJQJaJhB CJaJhB h#kOCJaJhB h'hCJ^JaJhB h'h5CJ\^JaJhB h'hCJ\^JaJhB hMXCJaJhB hTCJaJhB h'hCJaJhB hdjCJaJhB h#kOCJOJQJaJhB h?~CJOJQJaJhB h+uCJOJQJaJhB hCJOJQJaJfh iiiiicNE@;gd8ogd 7$8$H$gdo 0^`gd,?sN & F 7$8$Eƀ)H$gdMXN & F 7$8$Eƀ)H$gd<ii'i9iiiiiiiikjjjjjνrcTcE6EhB h`tCJOJQJaJhB hCJOJQJaJhB h#kOCJOJQJaJhB h-CJOJQJaJhB h8oCJOJQJaJ#hB 56>*B*OJQJXph)hB h#kO56>*B*OJQJXph)hB hfG56>*B*OJQJXph hB hoCJOJQJ^JaJ hB hB.CJOJQJ^JaJhB hoCJOJQJ]aJhB h'hCJOJQJ]aJiiMjjk!I & FEƀ#gdI & FEƀ"gdI & FEƀ!gd-jjjjjkkVkWklkkkktlI & F Eƀ)gd#kOgd@  0^`gd_Agdc~gds%Vgd jjjjjjj kkkkVkWklkokkkkĵyjZK<-hB hBfCJOJQJaJhB hTCJOJQJaJhB hM/MhB hM CJOJQJaJhB h-CJOJQJaJhB hCJOJQJaJhB h8oCJOJQJaJ#hB 56>*B*OJQJXph)hB h#kO56>*B*OJQJXph)hB hfG56>*B*OJQJXph hB hBf hB h@ hB h@ CJOJQJaJhB hTCJOJQJaJhB hdjCJOJQJaJhB h_ACJOJQJaJhB hrrrrҲufVVJhB CJOJQJaJhB hgd>gd>rrrrrrrrrrrrrrrrsKsLsRsSssssss߸ufWHhB hCJOJQJaJhB h8oCJOJQJaJhB hHsCJOJQJaJ#hB 56>*B*OJQJXph)hB h#kO56>*B*OJQJXph)hB hfG56>*B*OJQJXph h>h>h>h>CJOJQJaJ/h>h>56>*B*OJQJX\]ph)h>56>*B*OJQJX\]phh>CJOJQJaJsskttttttttttttttAuBuCuDuFuQuĵ⦟paRF7hB hMCJOJQJaJh>CJOJQJaJhB h*CJOJQJaJhB h;)CJOJQJaJhB hc~6CJOJQJaJhB h&86CJOJQJaJhB hc~CJOJQJaJ hB hg]hB hg]CJOJQJaJhB h`tCJOJQJaJhB hHsCJOJQJaJhB hCJOJQJaJhB h#kOCJOJQJaJhB hM CJOJQJaJs tkttk!I & FEƀ+gdM I & FEƀ*gdM I & FEƀ)gdM tttttBuCuuuuvvwww#x$x3xI & FEƀ)gd#kOgd` -DM gd&gd&gdc~gdM Qu~uuuuuvvvvwwIwJwwwwwĵĩyiYIY*B*OJQJX\]ph/hQohQo56>*B*OJQJX\]phhQoCJOJQJaJhB h#kOCJOJQJaJhB hkCJOJQJaJhB h1CJOJQJaJh3{CJOJQJaJhB h`CJOJQJaJhB h`CJOJQJ]aJhB hTCJOJQJ]aJhB huYCJOJQJ]aJ3xzz%{3{w{x{{{`[Vgd3gdsI & FEƀgdQogdQogdQoFEƀSgdQogd&3{P{v{w{x{~{{{{{||"|-|.|9|:|;|||||w}x}ɴɥxiZKKD=D=DK hB h#kO hB h[zhB h[zCJOJQJaJhB h*CJOJQJaJhB h`tCJOJQJaJhB h]_CJOJQJaJhB h#kOCJOJQJaJhB hCJOJQJaJhB h3CJOJQJaJ)hB h#kO56>*B*OJQJXph)hB hfG56>*B*OJQJXph hQohQohjyCJOJQJaJhB hQoCJOJQJaJ{{||-|.|;|w}x}}kffaTTff -DM gd[zgdc~gd]_I & FEƀ-gd3I & FEƀ,gd3 x}}}[~\~m~]^de ³ѳzk\M>M/khB hHsCJOJQJaJhB h`tCJOJQJaJhB hsCJOJQJaJhB hCJOJQJaJhB h#kOCJOJQJaJhB h8oCJOJQJaJ)hB h#kO56>*B*OJQJXph)hB hfG56>*B*OJQJXphhB h;CJOJQJaJhB h1CJOJQJaJhB hpCJOJQJaJhB h-CJOJQJaJ*hB h>p5>*B*OJQJXaJph*hB h-5>*B*OJQJXaJph"hB h'>*CJOJQJXaJhB hhCJOJQJaJhB hsCJOJQJaJhB hTCJOJQJaJhB huYCJOJQJaJhB h FCJOJQJaJhB h|I CJOJQJaJhB hmCJOJQJaJhB h_CJOJQJaJقVI `gd>pI & FEƀgd>pgd>p$gd~gd'I & FEƀ)gd Fgd FVvqsٻٻwaO@hB h:CJOJQJaJ"hB hh>*CJOJQJXaJ*hB h>p5>*B*OJQJXaJph*hB h~5>*B*OJQJXaJph*hB hh5>*B*OJQJXaJph.hB h F5>*B*CJOJQJXaJphhB h FCJOJQJaJhB h>pCJOJQJaJhB h-CJOJQJaJ.hB h>p5>*B*CJOJQJXaJphrs^I & FEƀgd>p `gd>pI & FEƀgd>ps^Ygd FI & FEƀgd F `gd>pI & FEƀgd>pfI & FEƀgd FN & FEƀgd FofI & FEƀgd>pƈ؈]L$ & F1$Eƀgd:L$ & F1$Eƀgd:$1$gdZJ؈eL$ & F1$Eƀ gd:L$ & F1$Eƀ gd:(eL$ & F1$Eƀ gd:L$ & F1$Eƀ gd:(DWeL$ & F1$Eƀgd:L$ & F1$Eƀ gd:WweL$ & F1$Eƀgd:L$ & F1$Eƀgd:eL$ & F1$Eƀgd:L$ & F1$Eƀgd:ӉeL$ & F1$Eƀgd:L$ & F1$Eƀgd:eL$ & F1$EƀgdZJL$ & F1$Eƀgd: ъۊ܊:RSWY[wʋϋҋԋĢČ{ӵ hB h F0JCJOJQJaJ+jehB h FCJOJQJUaJ%jhB h FCJOJQJUaJhB h:CJOJQJaJhB h FCJOJQJaJhB hMCJOJQJaJhB h~CJOJQJaJhB hobCJOJQJaJ-+JeL$ & F1$Eƀgd:L$ & F1$Eƀgd:J`veL$ & F1$Eƀgd:L$ & F1$Eƀgd:veL$ & F1$EƀgdZJL$ & F1$Eƀgd:ъeL$ & F1$Eƀgd:L$ & F1$Eƀgd:ъeL$ & F1$Eƀ gd:L$ & F1$Eƀ gdZJ$:eL$ & F1$Eƀ gd:L$ & F1$Eƀ gd::[weL$ & F1$Eƀgd:L$ & F1$Eƀ gdZJw]L$ & F1$Eƀgd F$1$gd FL$ & F1$EƀgdZJԋeL$ & F1$Eƀgd:L$ & F1$EƀgdM  !'(*+/0:;=>unjȌɌʌ̌ΌόļhXm0JmHnHuh3{h3{0JmHnHujh3{0JU h3{0JhmjhmUhB h'CJOJQJaJhB h~CJOJQJaJhB hMCJOJQJaJhB hsCJOJQJaJ6e][[[[[[[$1$gdZJL$ & F1$EƀgdZJL$ & F1$EƀgdM uvwˌ̌͌ΌόЌь$1$gdZJ$a$ !$ όЌьhB h'CJOJQJaJh$6&P1h:pZJ/ =!h"`#$`% = 0&P1h:pZJ/ =!"`#$`% P 9 0&P1h:pZJ/ =!"`#$`% 9 0&P1h:pZJ/ =!"`#$`% 9 0&P1h:pZJ/ =!"`#$`% 6&P1h:p F/ =!"`#$`% = 0&P1h:p F/ =!"`#$`% P DyK _Chapter_Objectivesh$$If!vh5\5#v\#v:Vl t5\5/ DyK _EX_82_Introduction?$$If!vh5\5#v\#v:Vl t05\5DyK _EX_82_Project$$If!vh5\5#v\#v:Vl t05\5DyK _EX_85_General$$If!vh5\5#v\#v:Vl t05\5DyK _EX_87_Entering$$If!vh5\5#v\#v:Vl t05\5{DyK  _EX_90:_Plan$$If!vh5\5#v\#v:Vl t05\5DyK _EX_90_Entering$$If!vh5\5#v\#v:Vl t05\5{DyK  _EX_98_Using$$If!vh5\5#v\#v:Vl t05\5DyK _EX_106_Verifying$$If!vh5\5#v\#v:Vl t05\5DyK _EX_107_Formatting$$If!vh5\5#v\#v:Vl t05\5}DyK _EX_108:_Plan$$If!vh5\5#v\#v:Vl t05\5DyK _EX_127_Checking$$If!vh5\5#v\#v:Vl t05\5}DyK _EX_129:_Plan$$If!vh5\5#v\#v:Vl t05\5DyK _EX_129_Preparing$$If!vh5\5#v\#v:Vl t05\5DyK _EX_132_Previewing$$If!vh5\5#v\#v:Vl t05\5DyK _EX_135_Displaying$$If!vh5\5#v\#v:Vl t05\5}DyK _EX_137:_Plan$$If!vh5\5#v\#v:Vl t05\5DyK _EX_137_Importing$$If!vh5\5#v\#v:Vl t05\5}DyK _EX_140:_Plan$$If!vh5\5#v\#v:Vl t05\5DyK _EX_140_Changing$$If!vh5\5#v\#v:Vl t05\5DyK _EX_142_E-Mailing$$If!vh5\5#v\#v:Vl t05\5DyK End_of_Chapter_Material$$If!vh5\5#v\#v:Vl t05\5sDyK  Glossary$$If!vh5\5#v\#v:Vl t05\5yDyK  _Excel_2007<@< aNormalCJ_HmH sH tH F@F sQ. Heading 1$dh@&;CJL@L sQ. Heading 2$$dh@&a$;CJ V@V L Heading 3$<@&5CJOJQJ\^JaJ>@> sQ. Heading 7 <@&aJD@D sQ. Heading 8 <@& 6]aJN @N  Heading 9 <@&CJOJQJ^JaJDA@D Default Paragraph FontRi@R  Table Normal4 l4a (k@(No List4@4 sQ.Header  !4 @4 sQ.Footer  !.)@. sQ. Page NumberFB@"F sQ. Body Text$$dhxa$CJ$NO2N i`Level 1>1$7$8$H$^`>CJaJB'@AB wComment ReferenceCJaJ8@R8 w Comment TextCJ@jQR@ wComment Subject5\H@rH w Balloon TextCJOJQJ^JaJj@j Z Table Grid7:V0 Z Table Web 2h:V03j B*`Jph6U@6 n Hyperlink >*B*phFV@F nFollowedHyperlink >*B* ph<O< !#Head B5CJOJQJO aUnitW$d!%d$&d!'d$-DM 3N!O$P!Q$56B*CJ(OJQJaJ(ph(O( !#Unit tффf|ф8w(` z"zzzzzzz z z z z zzz"z (&/8"CKU]#eflt|}фVQ8c>!= f F     Z023qstIKL1 3 4 r t u " # l n o ; > ?    m p q f i j ILM:=>pstuvwx.Rn 6l!:X;I01OPWtu!"/&'< N\4C'(` Z !!N"O"""U#V#k#l#{#$/%0%?%&&y&&&&&((((((N)))*S***+N+O++++z-{--].^...n/o///*0+0@000T2U2l44445x55<666P777777b8c888888999999:::<<<>>#>^@@@@AA'A(A=AIA"CCCQCCCCDDETEE FnFFGNGGG`HaHhHiHI IlImIIIOJPJJJJJKKTKUKKKKKLLOLPL]L M!M6MNNQQQQQ4RR ?   p q =>҄00d 1t" 00 1Pl00 0 ol00 000 D 0 +0 0  00 0 8 0  l"ކ00p 0 00 f60 ͌#j 00 d ͌#j 00$ "au~,-000\ -0 B00 Z023qstIKL1 3 4 r t u " # l n o ; > ?    m p q f i j ILM:=>pstuvwx.Rn 6l!:X;I01OPWtu!"/&'< N\4C'(` Z !!N"O"""U#V#k#l#{#$/%0%?%&&y&&&&&((((((N)))*S***+N+O++++z-{--].^...n/o///*0+0@000T2U2l44445x55<666P777777b8c888888999999:::<<<>>#>^@@@@AA'A(A=AIA"CCCQCCCCDDETEE FnFFGNGGG`HaHhHiHI IlImIIIOJPJJJJJKKTKUKKKKKLLOLPL]L M!M6MNNQQQQQ4RR ?   p q f i j LM=>st҄000000>?O00=00;00 000 00 00000000 #k00 0 0 4$k00 0 0 k00 00Lk00 00k00 00k00 00Tk00 00Tk00 004Uk00 00 00  <    00 00  <   % L 00 00 0 00 00d 00&0'Vk00 0(0)\g00 00d 00 0 00 00( 00001=x. !X0\#'&Z(*.012N3<=<>P?AHIIKLTMnNNOSYY["^_ cchefijtlmnprst3x{}قs؈(WJvъ:wьHLMOQSTVYZ]_acdefgijlmnoqtvxz}~ЌI.3[otGLo/ 4 W p u  # I j o  9 ? `   = k q  d j GMq7>XnфXXXXXXXXXXXXXXXXXXXXXXXX +.!!!8@0(  B S  ?ф\ _Toc150248910 OLE_LINK1 OLE_LINK2 _Hlt150310516 _Hlt150310379 _Hlt150310380 _Hlt158968032 _Hlt158968026 _Hlt161295465 _Hlt161295466 _Hlt161295477 _Hlt158968017 _Hlt158968002 _Hlt161300518 _Hlt158967991 _Hlt158967983 _Hlt158967968 _Hlt161297789 _Hlt161297653 _Hlt158967961 _Hlt161297681 _Hlt161297764 _Hlt158967948 _Hlt158967937 _Hlt158967923 _Hlt158967910 _Hlt158967900 _Hlt161300626 _Hlt161299228 _Hlt158967879 _Hlt158967893 _Hlt161300011 _Hlt158967867 _Hlt158967807 _Hlt158967841 _Hlt161300671 _Hlt150575747 _Hlt150575748 _Hlt150249993 _Toc150248911_Chapter_Objectives$_EX_4:_What_is Microsoft Excel 2007? _Toc150248912 _EX_2:_What_EX_82_Introduction?$_EX_5:_Project_One  Worksheet with _EX_82_Project_EX_6:_Starting_Excel _Toc150248914_EX_85_General_EX_9:_The_Excel worksheet _Toc150248915_EX_87_Entering _EX_90:_Plan_EX_11:_Worksheet_window _Toc150248916_EX_90_Entering_EX_13:_Selecting_a cell _Toc150248917 _EX_98_Using_EX_16:_Entering_text _Toc150248918_EX_106_Verifying_EX_21:_Entering_numbers _Toc150248919_EX_107_Formatting _EX_108:_Plan_EX_23:_Calculating_a sum _Toc150248920_EX_127_Checking _EX_129:_Plan$_EX_24:_Using_the fill handle to cop _Toc150248921_EX_129_Preparing_EX_28:_Saving_the project _Toc150248922_EX_132_Previewing _EX_38:_Formatting_the worksheet _Toc150248923_EX_135_Displaying _EX_137:_Plan$_EX_39:_Using_the Name box to select _Toc150248924_EX_137_Importing _EX_140:_Plan$_EX_41:_Changing_document properties _Toc150248925_EX_140_Changing_EX_142_E-Mailing_EX_44:_Printing_a worksheetEnd_of_Chapter_MaterialGlossary!''hFd j  W X \ .  V Z   +ddhtx   ```&(((l4l4l4^@^@^@"C"C"CRUUUvZ\\\aaa#e#e#ejLkLkLkrxsxsxs^w||҄@@@@@@ @ @ @ @ @@@@@@@@@@@@@@@@@@@ @!@"@#@$@%@&@('),*+-./1024356879;:<>=?A@BCEDFGIHJLKMONPQSRTUXVWYZ[~"((iGe k  X Y ] /  W [   ,eeix  M``&(((l4l44^@^@@"C"CCCRUUUvZ\\\aaa#e#ehejLkLkkrxsxs^ww||҄-)J҄M҄?*urn:schemas-microsoft-com:office:smarttags stockticker (̈́΄҄ n s 1 D 5(:(RRTTZZjjno,o/orr̈́΄҄:::::::::::w̄̈́̈́΄΄τ҄̈́΄҄/^tSp~ ʄf`.| ^!<*'? #%D3x%:b@ >kF&iTG @kn9LxT|% R"HMS ,a5E_  Y"ya~8l`-w"b@z{)h ^`hH)h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h ^`hH)h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.0h^`0OJQJo(hH^`OJ QJ ^J o(hHopp^p`OJ QJ o(hH@ @ ^@ `OJQJo(hH^`OJ QJ ^J o(hHo^`OJ QJ o(hH^`OJQJo(hH^`OJ QJ ^J o(hHoPP^P`OJ QJ o(hHh ^`hH)h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.^`o(()  ^ `. L ^ `L.xx^x`.HH^H`.L^`L.^`.^`.L^`L.h ^`hH)h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.0h^`0OJQJo(hHE^`E56CJo(hH.pp^p`OJ QJ o(hH@ @ ^@ `OJQJo(hH^`OJ QJ ^J o(hHo^`OJ QJ o(hH^`OJQJo(hH^`OJ QJ ^J o(hHoPP^P`OJ QJ o(hH0h^`0OJQJo(hH^`OJ QJ ^J o(hHopp^p`OJ QJ o(hH@ @ ^@ `OJQJo(hH^`OJ QJ ^J o(hHo^`OJ QJ o(hH^`OJQJo(hH^`OJ QJ ^J o(hHoPP^P`OJ QJ o(hH0h^`0OJQJo(hH^`OJ QJ ^J o(hHopp^p`OJ QJ o(hH@ @ ^@ `OJQJo(hH^`OJ QJ ^J o(hHo^`OJ QJ o(hH^`OJQJo(hH^`OJ QJ ^J o(hHoPP^P`OJ QJ o(hHhh^h`CJOJ QJ o(l0h^`0OJQJo(hH ^`o(hH.pp^p`OJ QJ o(hH@ @ ^@ `OJQJo(hH^`OJ QJ ^J o(hHo^`OJ QJ o(hH^`OJQJo(hH^`OJ QJ ^J o(hHoPP^P`OJ QJ o(hH0h^`0OJQJo(hH^`OJ QJ ^J o(hHohh^h`B*OJ QJ o(phhH@ @ ^@ `OJQJo(hH^`OJ QJ ^J o(hHo^`OJ QJ o(hH^`OJQJo(hH^`OJ QJ ^J o(hHoPP^P`OJ QJ o(hHh^`OJQJo(hHh^`OJ QJ ^J o(hHohpp^p`OJ QJ o(hHh@ @ ^@ `OJQJo(hHh^`OJ QJ ^J o(hHoh^`OJ QJ o(hHh^`OJQJo(hHh^`OJ QJ ^J o(hHohPP^P`OJ QJ o(hH0h^`0OJQJo(hH^`OJ QJ ^J o(hHopp^p`OJ QJ o(hH@ @ ^@ `OJQJo(hH^`OJ QJ ^J o(hHo^`OJ QJ o(hH^`OJQJo(hH^`OJ QJ ^J o(hHoPP^P`OJ QJ o(hHh ^`o(hH) ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.h ^`hH)h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h ^`hH)h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.hhh^h`OJQJo(hHh88^8`OJ QJ ^J o(hHoh^`OJ QJ o(hHh  ^ `OJQJo(hHh  ^ `OJ QJ ^J o(hHohxx^x`OJ QJ o(hHhHH^H`OJQJo(hHh^`OJ QJ ^J o(hHoh^`OJ QJ o(hHiTGkF%D3n9L R@z{ %:b@a5E_Sp^!Y"yaf`./^'? #-w8lMS                  h                 jG>                 h|        h        h       h        h #               h                                            P"~j"~jO */D<-l&\~-haXYFi|JBbJ~< @ F  7 `. 0 @G  |I R _ B " : iR1q)U8tn-uC<st vP]s; Vi7*5YJYu7JbO]s'clG\bj ! " N !SG! Z!\!c!q!'N"B%#@?#i$%%5%v6%T%a%f%Op%a&K&'c'Gi)z)P*w*?+ z+/,6,--8-F-sQ.+2mi3+4{,4o-4HF4G4k4 s4(5 6 {6K 7D7Tg7&8F8h_8?j8O95X:]:;;Q;kX;t<{'='=-={ >X,>??|?~?!@!@UAAZA_A>ByBD C[cC DsD-DZDF FO!F:FfG5H'IH%gHXHRIEJ pJKKf:LBCL,MAML\MkMMNvN@O]O#kOPP,P+Q>TQ!RRfHRJR&S`SbSpqiqvq rF,s,?sHs\sbs?Kt#Ut`tutDu&u+uviv-w{wPx.yMySy z zmCznzszxz[z#{z|*|w}|W}E}\L}}~T,~L~W~9X~`~r~q@eX#mqAz% HkKh _sz| #-` 2+P0,VtJKaaivIkwwMiokGJZBf>_r]_;c#+* )ck -LnD[-k8P7w }ITz,Ac!# \Dh*(6>UMp2_D^Oz-]fdwUj.#+{H2ez?~;5$%.0=dg$Mzr*bf%nm{ R_5<^ly`aAbN<xTMx|ZJQY/ C[TvnyL L=`SwZ+s~9YIn:B 7DT\PSg3Gfw*(7 vt,>9_ScCCKT`x'_2A_.ALU\. 5<Ci[%H +FLguaB.r;)13o -k.=ZZSkrfq#ksa)3{)B\[i7.jQollm.{/M /3ruP-]i`yx~Qo_r8)8(h H>lmGQ$<=>`jy}e 2IbxZ~023qstIKL1 3 4 r t u " # l n o ; > ?    m p q f i j ILM:=>pstvZ[҄'0'0'0'0'0'0%D%Da0a0a0a0a0@;@{ф@Unknown klmartinez Nancy Lamm Gz Times New Roman5Symbol3& z Arial7 SylfaenGJansonText-BoldIJansonText-RomanOFrutigerLTStd-RomanK& zaTahomaLucidasans9Garamond?5 z Courier New;Wingdings"hffJZpCZpC!h24d̃̃ 3qHX)?sQ.2Microsoft Office 2003hhawkins klmartinezT             Oh+'0  , L X d p|Microsoft Office 2003 hhawkins Normal.dot klmartinez24Microsoft Office Word@PZ@" @,ڎV@7lZp՜.+,D՜.+,P  hp   Course TechnologyC̃ Microsoft Office 2003 TitleT 8@ _PID_HLINKSA -hE _Excel_2007 B Glossary~Y?End_of_Chapter_Material,<_EX_142_E-Mailing-Y9_EX_140_Changing%6_EX_140:_Plan#N3_EX_137_Importing"0_EX_137:_PlanO -_EX_135_DisplayingA9*_EX_132_Previewing2I'_EX_129_Preparing#$_EX_129:_Plan"R!_EX_127_Checking!_EX_108:_PlanN-_EX_107_Formatting+N_EX_106_Verifying\y _EX_98_Using#_EX_90_Entering5W _EX_90:_Plan" _EX_87_Entering! _EX_85_General;_EX_82_Project\+_EX_82_Introduction?xn_Chapter_Objectives  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_abcdefgijklmnotRoot Entry FHlvData 1TableWordDocumentSummaryInformation(`DocumentSummaryInformation8hCompObjq  FMicrosoft Office Word Document MSWordDocWord.Document.89q