SELECT : Microsoft Excel 97, Blue Ribbon Edition / Edition 1

SELECT : Microsoft Excel 97, Blue Ribbon Edition / Edition 1

ISBN-10:
0201438623
ISBN-13:
9780201438628
Pub. Date:
08/12/1998
Publisher:
Pearson Education

Paperback - Rent for

Select a Purchase Option (MICROSOFT)
  • purchase options

Temporarily Out of Stock Online


Product Details

ISBN-13: 9780201438628
Publisher: Pearson Education
Publication date: 08/12/1998
Edition description: MICROSOFT
Pages: 160
Product dimensions: 8.66(w) x 11.42(h) x (d)

Table of Contents

Overview of Windows 95 1(1)
Objectives
1(1)
Launching Windows 95
2(1)
Identifying the Desktop Elements
2(1)
Using a Mouse
3(1)
Using the Basic Features of Windows 95
4(6)
Using the Start Menu
4(1)
Using Windows
5(2)
Using Menu bars and Toolbars
7(1)
Using Dialog Boxes
8(2)
Getting Help
10(6)
Exiting Windows 95
16
Windows 95 Active Desktop and Windows 98 Preview 1(1)
Objectives
1(2)
Identifying Elements of the Windows 95 Active Desktop
3(13)
Displaying the Internet Explorer Channel Bar
4(1)
Displaying the Active Desktop Wallpaper
5(1)
Using Desktop ToolTips
6(1)
Launching Programs
7(3)
Customizing the Windows 95 Active Desktop
10(1)
Sizing and Repositioning the Taskbar
10(1)
Displaying Additional Toolbars on the Taskbar
11(1)
Customizing Taskbar Toolbars
11(2)
Editing the Start Menu
13(1)
Creating Shortcuts from the Start Menu
13(1)
Adding Items to the Start Menu
14(1)
Restoring the Desktop
15(1)
Conclusion
16
Overview 2
Objectives
2(10)
Identifying the Excel 97 Features
2(1)
Launching Excel 97
3(1)
Identifying Excel 97 Screen Elements
4(2)
Working with Toolbars
6(2)
Getting Help
8(1)
Using the Office Assistant
8(2)
Getting Help from the World Wide Web
10(1)
Closing a Workbook and Exiting Excel 97
11(1)
Summary and Exercises
12(1)
Summary
12(1)
Key Terms and Operations
12(1)
Key Terms
12(1)
Operations
12(1)
Study Questions
13(1)
Multiple Choice
13(1)
Short Answer
14(1)
For Discussion
14(1)
Review Exercises
14(1)
Starting Excel and Exploring the Workbook
14(1)
Getting Help on the Web
15(1)
Displaying and Docking Toolbars and Getting Help from the Office Assistant
15(1)
Assignments
15(1)
Getting Online Help
15(1)
Using the Web Toolbar
15(1)
Creating a Workbook
16(31)
Objectives
16(1)
The Challenge
16(1)
The Solution
17(1)
The Setup
17(23)
Creating a New Workbook
18(1)
Moving Around in a Worksheet and a Workbook
18(4)
Naming Worksheets
22(2)
Entering Data
24(1)
Entering Text
24(1)
Entering Data on Multiple Worksheets
25(5)
Entering Numbers
30(1)
Entering Simple Formulas and Functions
31(5)
Saving a Workbook
36(2)
Previewing and Printing a Worksheet
38(2)
Closing a Workbook
40(1)
The Conclusion
40(1)
Summary and Exercises
41(1)
Summary
41(1)
Key Terms and Operations
41(1)
Key Terms
41(1)
Operations
41(1)
Study Questions
41(2)
Multiple Choice
41(1)
Short Answer
42(1)
For Discussion
43(1)
Review Exercises
43(3)
Creating an Expense Account
43(1)
Calculating Savings
44(1)
Creating a Sales Analysis Worksheet
45(1)
Assignments
46(1)
Creating a Timesheet
46(1)
Creating a Worksheet that Compares Menu Prices
46(1)
Editing a Workbook
47(28)
Objectives
47(1)
The Challenge
47(1)
The Solution
47(1)
The Setup
48(22)
Opening a Workbook
49(1)
Finding Data
50(2)
Editing Data
52(3)
Working with Data
55(1)
Selecting Cells
55(3)
Copying Data
58(3)
Deleting Data
61(2)
Moving Data
63(2)
Adding Comments
65(4)
Checking Spelling
69(1)
Conclusion
70(1)
Summary and Exercises
71(1)
Summary
71(1)
Key Terms and Operations
71(1)
Key Terms
71(1)
Operations
71(1)
Study Questions
71(2)
Multiple Choice
71(1)
Short Answer
72(1)
For Discussion
73(1)
Review Exercises
73(1)
Revising the Restaurant Sales Worksheet
73(1)
Revising a Time Sheet
73(1)
Moving and Copying Data in a Worksheet
74(1)
Assignments
74(1)
Creating and Revising a Budget
74(1)
Tracking the American Stock Exchange
74(1)
Enhancing the Appearance of a Workbook
75(24)
Objectives
75(1)
The Challenge
76(1)
The Solution
76(1)
The Setup
76(17)
Formatting Text
77(1)
Changing Cell Alignment
78(3)
Formatting Numbers
81(3)
Formatting Dates
84(2)
Formatting Numbers as Text
86(2)
Adding Borders and Fill
88(3)
Viewing and Changing a Page Break
91(1)
Using AutoFormat
92(1)
The Conclusion
93(1)
Summary and Exercises
94(1)
Summary
94(1)
Key Terms and Operations
94(1)
Key Terms
94(1)
Operations
94(1)
Study Questions
94(2)
Multiple Choice
94(1)
Short Answer
95(1)
For Discussion
96(1)
Review Exercises
96(1)
Enhancing the Restaurant Sales Worksheet
96(1)
Creating a Concert List
97(1)
Enhancing the Container Corporation Sales Worksheet
97(1)
Assignments
97(2)
Reformatting the Income.xls File
98(1)
Using AutoFormat
98(1)
Editing the Structure of a Worksheet and a Workbook
99(26)
Objectives
99(1)
The Challenge
99(1)
The Solution
100(1)
The Setup
100(19)
Inserting, Deleting, and Arranging Worksheets
101(3)
Changing the Size of Columns and Rows
104(2)
Using AutoFit
106(1)
Adjusting Row Height
107(2)
Inserting Columns, Rows, and Cells
109(3)
Deleting Columns, Rows, and Cells
112(2)
Creating Headers and Footers
114(3)
Creating a Custom Header and Footer
117(2)
The Conclusion
119(1)
Summary and Exercises
120(1)
Summary
120(1)
Key Terms and Operations
120(1)
Key Terms
120(1)
Operations
120(1)
Study Questions
120(2)
Multiple Choice
120(1)
Short Answer
121(1)
For Discussion
122(1)
Review Exercises
122(2)
Editing the MarApr2 Workbook
122(1)
Creating a Sales Workbook for the Sandwich Shops and Snack Bars
123(1)
Editing and Enhancing the Container Corporation Sales Worksheet
123(1)
Assignments
124(1)
Creating a Banquet Workbook
124(1)
Creating a Shopping List
124(1)
Creating a More Complex Workbook
125(33)
Objectives
125(1)
The Challenge
125(1)
The Solution
126(1)
The Setup
126(26)
Copying Data from Another Workbook
126(3)
Sorting Data
129(1)
Entering Formulas with Relative References
130(3)
Using Headings in Formulas
133(1)
Entering Formulas with Absolute References
133(2)
Pointing to Enter Absolute References
135(1)
Using Headings with Absolute References
136(1)
Creating and Modifying a Chart
136(3)
Moving and Sizing a Chart
139(1)
Changing Chart Data
140(3)
Formatting Chart Elements
143(2)
Changing the Chart Type
145(1)
Changing the Chart Options
146(1)
Creating a Pie Chart
147(5)
The Conclusion
152(1)
Summary and Exercises
153(1)
Summary
153(1)
Key Terms and Operations
153(1)
Key Terms
153(1)
Operations
153(1)
Study Questions
153(2)
Multiple Choice
153(2)
Short Answer
155(1)
For Discussion
155(1)
Review Exercises
155(2)
Revising the Gift Inventory and Sales Workbook
155(1)
Creating a New Items Workbook
156(1)
Sorting Data and Creating a Sales Charting Worksheet
156(1)
Assignments
157(1)
Creating a Chart of Expenditures
157(1)
Completing a Vacation Package Workbook
157(1)
Using Financial Functions
158
Objectives
159(1)
The Challenge
159(1)
The Solution
159(1)
The Setup
160(23)
Defining the Structure of the Amortization Schedule
161(3)
Entering Numeric Constants
164(2)
Calculating the Loan Payment
166(3)
Calculating the Beginning Balance Using the PV Function
169(1)
Calculating the Principal Paid in Each Payment
170(2)
Calculating the Interest Paid in Each Payment
172(1)
Constructing Formulas to Calculate the Cumulative Principal, Cumulative Interest, Total Payments, and Ending Balance
173(1)
Using the Fill Handle to Complete the Amortization Schedule
174(3)
Freezing Worksheet Panes to Assist in Viewing Large Worksheets
177(2)
Changing the Loan Scenario
179(2)
Creating Excel Macros
181(1)
Running a Macro
182(1)
The Conclusion
183(1)
Summary and Exercises
184(1)
Summary
184(1)
Key Terms and Operations
184(1)
Key Terms
184(1)
Operations
184(1)
Study Questions
185(2)
Multiple Choice
185(1)
Short Answer
186(1)
For Discussion
187(1)
Review Exercises
187(1)
Protecting Cells in a Workbook
187(1)
Creating a Worksheet to Predict the Future Value of an Investment
187(1)
Assignments
188(1)
Creating Macros to Enable and Disable Protection for a Worksheet
188(1)
Repaying a Loan Early
188(1)
More Excel 97
189(1)
Modifying Workbooks
189(1)
Rotating and Indenting Text
189(1)
Revise Formulas
189(1)
Print Workbooks
189(1)
Printing the Screen and Ranges
189(1)
Creating and Applying Ranges
190(1)
Creating and Naming Ranges
190(1)
Using Draw
190(1)
Creating and Modifying Lines and Objects
190(1)
Creating and Modifying 3D Shapes
190(1)
Using Charts
191(1)
Previewing and Printing Charts
191(1)
Saving Spreadsheets as HTML
191(1)
Saving Spreadsheets as HTML Documents
191(1)
Formatting Worksheets
192
Applying Outlines
192
Function Reference Guide 1(1)
Glossary 1(1)
Index 1

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews