Excel Project 2 Formulas, Functions, Formatting, and Web Queries[Excel的项目2公式，函数，格式化和Web查询](PPT-76).pptVIP

Excel Project 2 Formulas, Functions, Formatting, and Web Queries Objectives Enter a formula using the keyboard and Point mode Recognize smart tags and option buttons Apply the AVERAGE, MAX, and MIN functions Verify a formula using Range finder Format a worksheet using buttons and commands Objectives Add conditional formatting to a range of cells Change the width of a column and height of a row Check the spelling of a worksheet Preview how a printed copy of the worksheet will look Objectives Print a partial or complete worksheet Display and print the formulas version 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 Starting and Customizing Excel Click the Start button on the Windows taskbar, point to All Programs on the Start menu, point to Microsoft Office on the All Programs submenu, and then click Microsoft Office Excel 2003 on the Microsoft Office submenu If the Excel window is not maximized, double-click its title bar to maximize it If the Language bar appears, right-click it and then click Close the Language bar on the shortcut menu If the Getting Started task pane appears in the Excel window, click its Close button in the upper-right corner If the Standard and Formatting toolbars are positioned on the same row, click the Toolbar Options button and then click Show Button on Two Rows Entering the Worksheet Title and Subtitle Select the cell A1. Type Blue Chip Stock Club in the cell and then press the DOWN ARROW key Type Investment Analysis in cell A2 and then press the DOWN ARROW key Entering the Column Titles, Stock Data, and Row Titles Enter the values in their respective cells as shown on the following slide. Use the ALT+ENTER key combination to move to the next line within a cell Entering the Column Titles, Stock Data, and Row Titles Saving the Workbook With a floppy disk in drive A, click the Save button on the Standard toolbar When Excel displays the Save As d