EXCEL2007chapter1教学PPTCanadiansecondedition
合集下载
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
done manually
16
Operator Symbols（符号） and Order Precedence（优先）
Operator symbols include:
Addition (+), Subtraction (-), Multiplication (*), and Division (/), Exponentiation (^)
Mathematical operations are the backbone of
Excel
Formulas are used to perform mathematical
operations and arrive at a calculated result Must begin with an equals (=) sign Used to automate calculations that were
Workbooks
Excel workbook
This workbook currently has three worksheets
5
Using Spreadsheets Across Disciplines
Spreadsheets have applications in varied disciplines Used for business applications, such as accounting Used for business planning Can also be used in scientific applications
Spreadsheet ─ computerized equivalent of a ledger
Excel ─ a computerized spreadsheet application used to build and manipulate worksheets and workbooks
Double-click in the cell to be edited, make the changes, press Enter
Select the cell, press the F2 key, make the changes, press Enter
Two options to clear the contents of the cell:
Click on the cell and delete Click on Clear arrow in the Editing group on
the Home tab
14
Using Save and Save As
Click the Office button, then select Save or Save As
Objectives
Define worksheets and workbooks Use spreadsheets across disciplines Plan for good workbook and worksheet
design Identify Excel window components Enter and edit data in cells
Text ─ letters, numbers, symbols, and spaces Values ─ numbers that represent a quantity, an
amount, a date or time
Formulas ─ combination of numbers, cell
1
Objectives (continued)
Describe and use symbols of mathematical operators and the order of mathematical calculation
Display cell formulas Insert and delete rows and columns Use cell ranges, move, copy, paste, paste
17
Displaying Cell Formulas
Press the Ctrl key plus the tilde (~) key to display formulas in a worksheet
18
Insert/Delete Rows or Columns
To insert a new row
Designated by column letter, then row number
Navigate worksheets using either the mouse or keyboard
9
Identifying Excel Window Components
Active cell
The cell you are working in; where data will be input
Allow Excel to do what it was designed for – automatic calculation
7
Planning for Good Workbook and Worksheet Design
Test multiple times to make sure the results are what you expect
10
Identifying Excel Window Components
Status Bar
Displays information about a selected command or operation in progress
Select All button
used to select all elements of the worksheet
Ribbon
made up of tabs, groups, and commands
Tab
Each one is made up of several groups to facilitate viewing all of its functions without opening menus
Worksheet ─ a spreadsheet that may contain data, values, formulas, and/or charts
Workbook ─ a collection of related woHale Waihona Puke Baiduksheets within one file
4
Define Worksheets and
special, and AutoFill Manage worksheets
2
Objectives (continued)
Format worksheets Select page setup options for printing Manage cell comments
3
Define Worksheets and Workbooks
8
Identifying Excel Window Components
Worksheet is divided into a grid of rows and columns
Rows are numbered; columns are lettered
Cell ─ an intersection of a column and a row Cell reference ─ the address of that intersection
Geologists can use to chart data about scientific phenomena
Social Scientists can use to predict voting results
6
Planning for Good Workbook and Worksheet Design
Click the Insert pull-down arrow on the Cells group on the Home tab
Select Insert Sheet Rows or Insert Sheet Columns
19
Insert/Delete Individual Cells
Plan before you start entering data Steps to ensure a good design:
Decide on the purpose of the spreadsheet and how it will be constructed
Make it obvious where data is to be entered Enter data and set up formulas wherever possible
Click on the row number below where you want the new row inserted
To insert a new column
Click on the column letter to the right of where you want the new column inserted
references, operators, and/or functions
13
Edit Data in a Cell
Three most common methods to edit data in a cell:
Select the cell you want to edit, click in the Formula Bar, make changes, press Enter
11
Identifying Excel Window
Components
Name Box
Formula Bar
Select All button
Active Cell
Sheet Tabs
Status Bar
12
Enter Data in a Cell
Create a new workbook and enter data Three types of data you can enter:
Know what your results should be, so that you know your result is correct
Format（编排格式） the worksheet so it looks appealing
Document the worksheet as thoroughly as possible Save and print the results
Use the Save As option if you need to assign a name to the file
Provides the Save As dialog box
Once named, use the Save command
15
Mathematical Operations and Formulas
Order of Precedence controls the sequence
in which arithmetic operations are performed:
Basic rules – anything in parenthesis performed first; then multiplication and division; then addition and subtraction
Formula bar
Shows the active cell’s contents
Name box
Displays active cell’s address or name it has been given
Sheet tabs
What sheets of workbook are available
16
Operator Symbols（符号） and Order Precedence（优先）
Operator symbols include:
Addition (+), Subtraction (-), Multiplication (*), and Division (/), Exponentiation (^)
Mathematical operations are the backbone of
Excel
Formulas are used to perform mathematical
operations and arrive at a calculated result Must begin with an equals (=) sign Used to automate calculations that were
Workbooks
Excel workbook
This workbook currently has three worksheets
5
Using Spreadsheets Across Disciplines
Spreadsheets have applications in varied disciplines Used for business applications, such as accounting Used for business planning Can also be used in scientific applications
Spreadsheet ─ computerized equivalent of a ledger
Excel ─ a computerized spreadsheet application used to build and manipulate worksheets and workbooks
Double-click in the cell to be edited, make the changes, press Enter
Select the cell, press the F2 key, make the changes, press Enter
Two options to clear the contents of the cell:
Click on the cell and delete Click on Clear arrow in the Editing group on
the Home tab
14
Using Save and Save As
Click the Office button, then select Save or Save As
Objectives
Define worksheets and workbooks Use spreadsheets across disciplines Plan for good workbook and worksheet
design Identify Excel window components Enter and edit data in cells
Text ─ letters, numbers, symbols, and spaces Values ─ numbers that represent a quantity, an
amount, a date or time
Formulas ─ combination of numbers, cell
1
Objectives (continued)
Describe and use symbols of mathematical operators and the order of mathematical calculation
Display cell formulas Insert and delete rows and columns Use cell ranges, move, copy, paste, paste
17
Displaying Cell Formulas
Press the Ctrl key plus the tilde (~) key to display formulas in a worksheet
18
Insert/Delete Rows or Columns
To insert a new row
Designated by column letter, then row number
Navigate worksheets using either the mouse or keyboard
9
Identifying Excel Window Components
Active cell
The cell you are working in; where data will be input
Allow Excel to do what it was designed for – automatic calculation
7
Planning for Good Workbook and Worksheet Design
Test multiple times to make sure the results are what you expect
10
Identifying Excel Window Components
Status Bar
Displays information about a selected command or operation in progress
Select All button
used to select all elements of the worksheet
Ribbon
made up of tabs, groups, and commands
Tab
Each one is made up of several groups to facilitate viewing all of its functions without opening menus
Worksheet ─ a spreadsheet that may contain data, values, formulas, and/or charts
Workbook ─ a collection of related woHale Waihona Puke Baiduksheets within one file
4
Define Worksheets and
special, and AutoFill Manage worksheets
2
Objectives (continued)
Format worksheets Select page setup options for printing Manage cell comments
3
Define Worksheets and Workbooks
8
Identifying Excel Window Components
Worksheet is divided into a grid of rows and columns
Rows are numbered; columns are lettered
Cell ─ an intersection of a column and a row Cell reference ─ the address of that intersection
Geologists can use to chart data about scientific phenomena
Social Scientists can use to predict voting results
6
Planning for Good Workbook and Worksheet Design
Click the Insert pull-down arrow on the Cells group on the Home tab
Select Insert Sheet Rows or Insert Sheet Columns
19
Insert/Delete Individual Cells
Plan before you start entering data Steps to ensure a good design:
Decide on the purpose of the spreadsheet and how it will be constructed
Make it obvious where data is to be entered Enter data and set up formulas wherever possible
Click on the row number below where you want the new row inserted
To insert a new column
Click on the column letter to the right of where you want the new column inserted
references, operators, and/or functions
13
Edit Data in a Cell
Three most common methods to edit data in a cell:
Select the cell you want to edit, click in the Formula Bar, make changes, press Enter
11
Identifying Excel Window
Components
Name Box
Formula Bar
Select All button
Active Cell
Sheet Tabs
Status Bar
12
Enter Data in a Cell
Create a new workbook and enter data Three types of data you can enter:
Know what your results should be, so that you know your result is correct
Format（编排格式） the worksheet so it looks appealing
Document the worksheet as thoroughly as possible Save and print the results
Use the Save As option if you need to assign a name to the file
Provides the Save As dialog box
Once named, use the Save command
15
Mathematical Operations and Formulas
Order of Precedence controls the sequence
in which arithmetic operations are performed:
Basic rules – anything in parenthesis performed first; then multiplication and division; then addition and subtraction
Formula bar
Shows the active cell’s contents
Name box
Displays active cell’s address or name it has been given
Sheet tabs
What sheets of workbook are available