Exploring Microsoft Office 2007

Paperback
from $0.00

Author: Robert T. Grauer

ISBN-10: 0132393816

ISBN-13: 9780132393812

Category: Business Software

The Exploring series helps students master the How and Why of performing tasks in Office to gain a greater understanding of how to use the individual applications together to solve business problems. Exploring titles feature Perfect pages where every step of every hands-on exercise as well as every end-of-chapter problem begins on a new page and has its own screen shot to make it easier to follow. Each chapter contains Hands-on Exercises, Capstone Exercises, and Mini-Cases for practicing and...

Search in google:

The Exploring series helps students master the How and Why of performing tasks in Office to gain a greater understanding of how to use the individual applications together to solve business problems. Exploring titles feature Perfect pages where every step of every hands-on exercise as well as every end-of-chapter problem begins on a new page and has its own screen shot to make it easier to follow. Each chapter contains Hands-on Exercises, Capstone Exercises, and Mini-Cases for practicing and reviewing skills acquired.Exploring Microsoft Office 2007 Plus Edition, 1/e provides thorough coverage of Word, Excel, Access, and PowerPoint.Ideal for students and individuals seeking a comprehensive introduction to Microsoft Office 2007.

Section 1 Microsoft Office 2007 SoftwareIdentifying Common Interface ComponentsUsing Office 2007 HelpHands-on Exercise #1: Identifying Program Interface Components and Using HelpSection 2 Universal TasksOpening a FileSaving a FilePrinting a DocumentHands-on Exercise #2: Performing UniversalTasksSection 3 Basic TasksSelecting Text to EditInserting Text and Changing to the Overtype ModeMoving and Copying TextFinding, Replacing, and Going to TextUsing the Undo and Redo CommandsUsing Language ToolsApplying Font AttributesCopying Formats with the Format PainterHands-on Exercise #3: Performing Basic TasksSummaryKey TermsPractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesExploring Microsoft Office Word 2007Chapter 1 - What Will Word Processing Do for Me?Section 1 Introduction to Word ProcessingUnderstanding Word BasicsUsing AutoTextViewing a DocumentUsing the Mini ToolbarHands-On Exercise #1: Introduction to Microsoft WordSection 2 Document FormattingSetting Margins and Specifying Page OrientationInserting Page BreaksAdding Page NumbersInserting Headers and FootersCreating SectionsInserting a Cover PageUsing Find and Replace CommandsHands-On Exercise #2: Document OrganizationSection 3 The Final TouchesChecking Spelling and GrammarUsing Save and Backup OptionsSelecting Printing OptionsCustomizing WordHands-On Exercise #3: The Final TouchesSummaryKey TermsPractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesChapter 2 - Gaining Proficiency: Editing and FormattingSection 1 Text FormattingApplying Font Attributes Through the Font Dialog BoxHighlighting TextControlling Word Wrapping with Nonbreaking Hyphens and Nonbreaking SpacesCopying Formats with the Format PainterHands-on exercise #1: Character FormattingSection 2 Paragraph FormatsSetting Off Paragraphs with Tabs, Borders, Lists, and ColumnsApplying Paragraph FormatsHands-on exercise #2: Paragraph formattingSection 3 Styles and Document ReferencesCreating and Modifying StylesHands-on exercise #3: StylesTable of Contents and IndexesHands-on exercise #4: Reference PagesSummaryKey TermsPractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesChapter 3 - Enhancing a Document: Tables and GraphicsSection 1 TablesInserting a TableHands-On Exercise #1: Insert a TableSection 2 Advanced Table FeaturesFormatting a TableSort and Apply Formulas to Table DataConverting Text to a tableHands-On Exercise #2: Advanced Table FeaturesSection 3 Graphic ToolsInserting Clipart and Images into a DocumentFormatting a Graphic ElementInserting WordArt into a DocumentInserting Symbols into a DocumentHands-On Exercise #3: Clip Art, WordArt, and SymbolsSummaryKey TermsPractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesChapter 4 - Share, Compare, and DocumentSection 1 Workgroups and CollaborationInserting Comments in a DocumentTracking Changes in a DocumentHands-On Exercise #1: Document CollaborationSection 2 Multiple DocumentsViewing Documents Side by SideComparing and Combining DocumentsCreating Master Documents and SubdocumentsUsing Navigation ToolsHands-On Exercise #2: Document Comparison, Mergers, and NavigationSection 3 Reference ResourcesAcknowledging a SourceCreating a BibliographySelecting the Writing StyleCreating and Modifying Footnotes and EndnotesHands-On Exercise #3: Reference ResourcesSection 4 Additional Reference ResourcesAdding Figure ReferencesInserting a Table of FiguresAdding Legal ReferencesCreating a Cross-ReferenceModifying Document PropertiesHands-On Exercise #4: Additional Reference ResourcesSummaryKey TermsPractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesExploring Microsoft Office Excel 2007 Chapter 1 - Introduction to ExcelSection 1: Introduction to SpreadsheetsDefining Worksheets and WorkbooksUsing Spreadsheets Across DisciplinesPlanning for Good Workbook and Worksheet DesignIdentifying Excel Window ComponentsEntering and Editing Data in CellsHands-On Exercise #1: Introduction to Microsoft ExcelSection 2: Mathematics and FormulasDescribing and Using Symbols and the Order of PrecedenceDisplaying Cell FormulasInserting and Deleting Rows and ColumnsUsing Cell Ranges, Excel Move, Copy, Paste and Paste Special, and AutoFillHands-On Exercise #2: Jakes Gym ContinuedSection 3: Workbook and Worksheet EnhancementsManaging WorksheetsFormatting WorksheetsHands-On Exercise #3: Formatting Jake's Gym WorksheetSection 4: Page Setup and PrintingSelecting Page Setup Options for PrintingManaging Cell CommentsHands-On Exercise #4: Printing Jake's Gym WorksheetSummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesChapter 2 - Microsoft Excel: Formulas and Functions Section 1: Formula BasicsCreating and Copying FormulasUsing Relative and Absolute Cell AddressesHands-On Exercise #1: Smithtown Hospital Radiology Department PayrollSection 2: Function BasicsUsing AutoSumInserting Basic Statistical FunctionsUsing Date FunctionsHands-On Exercise #2: Completing the Smithtown Hospital Radiology DepartmentSection 3: Logical and Lookup FunctionsUsing the IF FunctionUsing the VLOOKUP FunctionHands-On Exercise #3: Athletic Department Eligibility GradebookSection 4: Financial FunctionsUsing the PMT FunctionUsing the FV FunctionHands-On Exercise #4: Purchasing a Van for the School for Exceptional ChildrenSummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesChapter 3 - Microsoft Excel: ChartsSection 1: A Picture is the MessageChoosing A Chart TypeCreating a ChartHands-on Exercise 1: The First ChartSection 2: Chart EnhancementsModifying a ChartEnhancing Charts with Graphic ShapesHands-on Exercise 2: Multiple Data SeriesSection 3: Chart DistributionEmbedding ChartsPrinting ChartsHands-on Exercise 3: Embedding, Printing, And Saving Chart as a Web PageSummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesChapter 4: Microsoft Excel: Working with Large Worksheets and TablesSection 1: Large Worksheet PreparationFreezing Rows and ColumnsHiding and Unhiding Rows, Columns, and WorksheetsProtecting a Cell, a Worksheet and a WorkbookControlling CalculationPrinting Large WorksheetsHands-On Exercise #1: Marching Band RosterSection 2: Excel Data TablesExploring Basic Table ManagementSorting DataFiltering and Totaling DataHands-On Exercise #2: Marching Band Roster RevisitedSummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesChapter 5 - Data to InformationSection 1 Table ManagementDesigning Tables Based on Table Data TheoryImporting Data from Text Files and Other SourcesApplying Conditional FormattingHands-on Exercise 1: Gee Airlines Human Resources DepartmentSection 2 Data ManagementApplying Advanced Filtering and Sorting MethodsCreating and Using Range NamesUsing Database FunctionsHands-on Exercise 2: Gee Airlines Human Resources Department RevisitedSection 3 Data Analysis with PivotTables and PivotChartsCreating and Deleting PivotTables and PivotChart ReportsFormatting, Sorting, Filtering, Subtotaling, and Refreshing a PivotTableHands-on Exercise 3: Eye First Advertising Department SalesSummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesChapter 6 – Data Tables and Amortization Tables Section 1 TablesSeparating and Combining TextManipulating Text with FunctionsHands-on Exercise 1: IT Department String ManipulationSection 2 Data Analysis and WindowsIdentifying and Removing Duplicate RowsGrouping and Subtotaling DataWorking with WindowsHands-on Exercise 2: Ajax College BandSection 3 Conditional and Logical FunctionsUsing Conditions in FunctionsCreating Nested IF FunctionsUsing AND, OR, NOT and IFERROR FunctionsHands-on Exercise 3: Classic Cars and SecuritySection 4 Amortization TableDefining the Amortization TableUsing Functions in Amortization TablesHands-on Exercise 4: Purchase a New HouseSummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesChapter 7 – Data Consolidation, Links, and Formula Auditing Section 1 Data ConsolidationConsolidating Data from Multiple WorksheetsDefining the Three-Dimensional WorkbookCreating Three-Dimensional References in FormulasHands-on Exercise 1: Consolidating Best Restaurant Corporate SalesSection 2 Workbook Linking and DocumentationLinking WorkbooksCreating the Documentation WorksheetHands-on Exercise 2: Consolidating Workbooks for Corporate Sales and Adding DocumentationSection 3 Workbook AuditingRestricting Values to a Drop-Down ListValidating DataAuditing FormulasSetting up a Watch WindowHands-on Exercise 3: JAS ManufacturingSummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesExploring Microsoft Office Access 2007 Chapter 1 - Introduction to Access: Finding Your Way through a DatabaseSection 1: Data and Files Everywhere!Exploring, Describing, and Navigating Among the Objects in an Access DatabaseUnderstanding the Difference Between Working in Storage and MemoryPracticing Good File ManagementBacking up, Compacting, and Repairing Access FilesHands-On Exercises 1 Introduction to DatabasesSection 2: Filters, Sorts, and Access Versus ExcelCreating FiltersSorting Table Data on One or More FieldsKnowing When to Use Access or Excel to Manage DataHands-On Exercises 2: Data Manipulation: Filters and SortsSection 3: The Relational DatabaseUsing the Relationship WindowUnderstanding Relational PowerHands-On Exercises 3: Introduction to RelationshipsSummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesChapter 2 - Relational Databases and Multi-Table Queries: Designing Databases and UsingSection 1: Related DataTable Design, Properties, Views, and WizardsDesigning DataCreating TablesHands-On Exercises 1: Table Design, Properties, Views, and WizardsSection 2: Multiple Table DatabaseUnderstanding Table RelationshipsSharing Data with ExcelEstablishing Table RelationshipsHands-on Exercises 2: Imports and RelationshipsSection 3: QueriesCreating a QuerySpecifying Criteria for Different Data TypesCopying and Running a QueryUsing the Query WizardUnderstanding Large Database DifferencesHands-On Exercises 3: Multi-Table QuerySummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesChapter 3 - Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make DecisionsSection 1: Data Summary and AnalysisUnderstanding the Order of PrecedenceCreating a Calculated Field in a QueryHands-On Exercises 1: Calculated Query FieldsSection 2: Expression BuilderCreating Expressions with the Expression BuilderCreating and Editing Access FunctionsPerforming Date ArithmeticHands-On Exercises 2: Expression Builder, Functions, and Date ArithmeticSection 3: Data AggregatesCreating and Working with Data AggregatesHands-On Exercises 3: Data AggregatesSummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesChapter 4 - Create, Edit and Perform Calculations in Reports: Creating Professional and Useful ReportsSection 1: Appearance MatterPlanning ReportsUsing Different Report ViewsCreating and Editing a ReportHands-On Exercises 1: Introduction to Access ReportsSection 2: The Anatomy of a ReportIdentifying Report Elements, Sections and ControlsAdding Grouping Levels Using the Layout ViewAdding Fields to a ReportHands-On Exercises 2: Create, Sort, Edit, Nest and Remove Groups from ReportsSection 3: The Report and Label WizardUsing the Report WizardHands-On Exercises 3: Report WizardSummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesChapter 5 – Pivot Tables and ChartsSection 1 Data MiningCreate a PivotTable viewCalculate aggregate statisticsModify a PivotTableHands-on Exercise 1: Create and Use a PivotTableSection 2 Charts Convey InformationSelect an appropriate chart typeIdentify chart elementsEdit a PivotChartHands-on Exercise 2: PivotCharts and ModificationsSection 3 Calculations in PivotTables and PivotChartsCreate calculations in a PivotTableHands-on Exercise 3: 3 Calculating Field Values in PivotTablesSummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesChapter 6 – Data Protection: Integrity, Validation, ReliabilitySection 1 Data ValidityEstablish Data ValidityCreate a LookupModify a Lookup by Adding and Deleting ValuesCreate and Modify a Multivalue Lookup FieldWork with Input MasksHands-on Exercise 1: Data ProtectionSection 2 FormsCreate Forms Using the Forms ToolsHands-on Exercise 2: Form Creation ToolsSection 3 Form CustomizationCreate Custom Forms Using Design ViewAdd Action Buttons and Combo Box ControlsCreate SubformsFashion Functional FormatsHands-on Exercise 3: Customizing FormsSummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesExploring MS Office PowerPoint 2007Chapter 1: Introduction to PowerPoint: Presentations Made EasySection 1 Introduction to PowerPointIdentifying PowerPoint User Interface ElementsUser PowerPoint ViewsOpening and Saving a Slide ShowGetting HelpHands-On Exercise 1: Introduction to PowerPointSection 2 Presentation CreationCreating a StoryboardUsing Slide LayoutsApplying Design ThemeReviewing the PresentationHands-On Exercise 2: Creating a PresentationSection 3 Presentation DevelopmentAdding a TableInserting Clip ArtUsing Transitions and AnimationsHands-On Exercise 3: Strengthening a PresentationSection 4 Navigation and PrintingRunning and Navigating a Slide ShowPrinting with PowerPointHands-On Exercise 4: Navigating and PrintingSummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesChapter 2: Presentation Development: Planning and Preparing a PresentationSection 1 TemplatesCreating a Presentation Using a TemplateModifying a TemplateHands-On Exercise 1: Using a templateSection 2 OutlinesCreating a Presentation in Outline ViewModifying an Outline StructurePrinting an OutlineHands-On Exercise 2: Creating and Modifying an OutlineSection 3 Data ImportsImporting an OutlineAdding Existing Content to a PresentationHands-On Exercise 3: Importing an Outline and Reusing SlidesSection 4 DesignExamining Slide Show Design PrinciplesApplying and Modifying a Design ThemeInserting a Header or FooterHands-On Exercise 4: Applying and Modifying a Design ThemeSummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini CasesWindows XPSection 1 Basics of Windows XPIdentifying Components on the Windows DesktopWorking with Windows, Menus, and Dialog BoxesIdentify Dialog Box ComponentsUsing the Help and Support CenterHands-on Exercise #1: Introduction to Windows XPSection 2 Files and FoldersWorking with FoldersManaging Folders and Files in Windows ExplorerDeleting Items and Managing the Recycle BinHands-on Exercise #2: File and Folder ManagementSection 3 Windows CustomizationChanging the Display SettingsChanging Computer SettingsUsing the Control PanelCreating Shortcuts on the Desktop and Quick Launch ToolbarUsing Windows Desktop SearchHands-on Exercise #3: Customizing Your SystemSummaryKey TermsMultiple ChoicePractice ExercisesMid-Level ExercisesCapstone ExerciseMini Cases