Essentials : Excel 2002 Level 1

by Metzelaar, Lawrence C.; Fox, Marianne

• ISBN13: 9780130927675
• ISBN10: 0130927678
• Edition: 1st
• Format: Paperback
• Copyright: 2002-01-01
• Publisher: Prentice Hall

Summary

For courses in Office Applications. The Essentials Series for Microsoft Office XP has be rewritten and redesigned to meet the needs of today's classroom. These hands-on tutorials with a project orientation are designed to give students a thorough knowledge of software applications. Extensive end-of-project exercises emphasize hands-on skill development.

Table of Contents

Introduction	xiii
Getting Started with Excel	1	(30)
Modifying a Worksheet	31	(24)
Improving the Appearance of a Worksheet	55	(22)
Entering Formulas in Well-Designed Worksheets	77	(30)
Working with Functions	107	(28)
Sorting, Filtering, and Editing Lists	135	(26)
Working with Charts	161	(34)
Developing a Multiple-Sheet Workbook	195	(26)
Appendix Overview of Windows	221	(24)
Task Guide	245	(8)
Glossary	253	(6)
Index	259

Excerpts

Introduction Essentialscourseware from Prentice Hall Information Technology is anchored in the practical and professional needs of all types of students. Theessentialsseries has been conceived around a "learning-by-doing" approach that encourages you to grasp application-related concepts as you expand your skills through hands-on tutorials. As such, it consists of modular lessons that are built around a series of numbered, step-by-step procedures that are clear, concise, and easy to review. The end-of-chapter exercises have likewise been carefully constructed from the routine Checking Concepts and Terms to tasks in the Discovery Zone that gently prod you into extending what you've learned into areas beyond the explicit scope of the lessons proper. Following, you'll find out more about the rationale behind each book element and how to use each to your maximum benefit. Key Features Step-by-Step Tutorials.Each lesson in a project includes numbered, bold step-by-step instructions that show you how to perform the procedures in a clear, concise, and direct manner. These hands-on tutorials let you "learn by doing." A short paragraph may appear after a step to clarify the results of that step. To review the lesson, you can easily scan the bold numbered steps. Accompanying data files eliminate unnecessary typing. End-of-Project Exercises.Check out the extensive end-of-project exercises (generally 20 percent of the pages in each project) that emphasize hands-on skill development. You'll find three levels of reinforcement: Skill Drill, Challenge, and Discovery Zone. Generally, each exercise is independent of other exercises, so you can complete your choices in any order. Accompanying data files eliminate unnecessary typing. Skill Drill.Skill Drill exercises reinforce project skills. Each skill reinforced is the same, or nearly the same, as a skill presented in the project. Each exercise includes a brief narrative introduction, followed by detailed instructions in a step-by-step format. Challenge.Challenge exercises expand on or are somewhat related to skills presented in the lessons. Each exercise provides a brief narrative introduction, followed by instructions in a numbered-step format that are not as detailed as those in the Skill Drill section. Discovery Zone.Discovery Zone exercises require advanced knowledge of topics presented in lessons, application of skills from multiple lessons, or self-directed learning of new skills. Each exercise provides a brief narrative introduction. Numbered steps are not provided. Two other sections precede the end-of-project exercises:SummaryandChecking Concepts and Terms.The Summary provides a brief recap of tasks learned in the project, and guides you to topics or places where you can expand your knowledge. The Checking Concepts and Terms section includes Multiple Choice and Discussion questions that are designed to check your comprehension and assess retention. Projects that introduce a new work area include a Screen ID question. Notes.Projects include two types of notes: "If you have problems..." and "To extend your knowledge..." The first type displays between hands-on steps. These short troubleshooting notes help you anticipate or solve common problems quickly and effectively. Many lessons in the projects end with "To extend your knowledge..." notes that provide extra tips, shortcuts, and alternative ways to complete a process, as well as special hints. You may safely ignore these for the moment to focus on the main task at hand, or you may pause to learn and appreciate the additional information. Task Guide.The Task Guide, which follows the Overview of Windows, lists common procedures and shortcuts. It can be used in two complementary ways to enhance your learning experience. You can refer