《excel2007 chapter1 教学ppt canadian second edition》由会员分享，可在线阅读，更多相关《excel2007 chapter1 教学ppt canadian second edition（34页珍藏版）》请在金锄头文库上搜索。
1、1 1 Copyright 2008 Prentice-Hall. All rights reserved. Committed to Shaping the Next Generation of IT Experts. Chapter 1: Introduction to Excel What Can I Do with a Spreadsheet Exploring Microsoft Office Excel 2007 2 Objectives nDefine worksheets and workbooks nUse spreadsheets across disciplines nP
2、lan for good workbook and worksheet design nIdentify Excel window components nEnter and edit data in cells 3 Objectives (continued) nDescribe and use symbols of mathematical operators and the order of mathematical calculation nDisplay cell formulas nInsert and delete rows and columns nUse cell range
3、s, move, copy, paste, paste special, and AutoFill nManage worksheets 4 Objectives (continued) nFormat worksheets nSelect page setup options for printing nManage cell comments 5 Define Worksheets and Workbooks nSpreadsheet computerized equivalent of a ledger qExcel a computerized spreadsheet applicat
4、ion used to build and manipulate worksheets and workbooks nWorksheet a spreadsheet that may contain data, values, formulas, and/or charts nWorkbook a collection of related worksheets within one file 6 Excel workbook This workbook currently has three worksheets Define Worksheets and Workbooks 7 Using
5、 Spreadsheets Across Disciplines nSpreadsheets have applications in varied disciplines nUsed for business applications, such as accounting nUsed for business planning nCan also be used in scientific applications qGeologists can use to chart data about scientific phenomena qSocial Scientists can use
6、to predict voting results 8 Planning for Good Workbook and Worksheet Design nPlan before you start entering data nSteps to ensure a good design: qDecide on the purpose of the spreadsheet and how it will be constructed qMake it obvious where data is to be entered qEnter data and set up formulas where
7、ver possible nAllow Excel to do what it was designed for automatic calculation 9 Planning for Good Workbook and Worksheet Design nTest multiple times to make sure the results are what you expect qKnow what your results should be, so that you know your result is correct nFormat（编排格式） the worksheet so
8、 it looks appealing nDocument the worksheet as thoroughly as possible nSave and print the results 10 Identifying Excel Window Components nWorksheet is divided into a grid of rows and columns qRows are numbered; columns are lettered nCell an intersection of a column and a row nCell reference the addr
9、ess of that intersection qDesignated by column letter, then row number nNavigate worksheets using either the mouse or keyboard 11 Identifying Excel Window Components nActive cell qThe cell you are working in; where data will be input nFormula bar qShows the active cells contents nName box qDisplays
10、active cells address or name it has been given nSheet tabs qWhat sheets of workbook are available 12 Identifying Excel Window Components nStatus Bar qDisplays information about a selected command or operation in progress nSelect All button qused to select all elements of the worksheet nRibbon qmade
11、up of tabs, groups, and commands nTab qEach one is made up of several groups to facilitate viewing all of its functions without opening menus 13 Active Cell Formula Bar Name Box Sheet Tabs Status Bar Select All button Identifying Excel Window Components 14 Enter Data in a Cell nCreate a new workbook
12、 and enter data nThree types of data you can enter: qText letters, numbers, symbols, and spaces qValues numbers that represent a quantity, an amount, a date or time qFormulas combination of numbers, cell references, operators, and/or functions 15 Edit Data in a Cell nThree most common methods to edi
13、t data in a cell: qSelect the cell you want to edit, click in the Formula Bar, make changes, press Enter qDouble-click in the cell to be edited, make the changes, press Enter qSelect the cell, press the F2 key, make the changes, press Enter nTwo options to clear the contents of the cell: qClick on t
14、he cell and delete qClick on Clear arrow in the Editing group on the Home tab 16 Using Save and Save As nClick the Office button, then select Save or Save As nUse the Save As option if you need to assign a name to the file qProvides the Save As dialog box nOnce named, use the Save command 17 Mathema
15、tical Operations and Formulas nMathematical operations are the backbone of Excel nFormulas are used to perform mathematical operations and arrive at a calculated result nMust begin with an equals (=) sign nUsed to automate calculations that were done manually 18 Operator Symbols（符号） and Order Preced
16、ence（优先） nOperator symbols include: qAddition (+), Subtraction (-), Multiplication (*), and Division (/), Exponentiation () nOrder of Precedence controls the sequence in which arithmetic operations are performed: qBasic rules anything in parenthesis performed first; then multiplication and division; then addition and subtraction 19 Displaying Cell Formulas nPress the Ctrl key plus the tilde () key to display for
