Klientu atbalsts: 27018494

Grāmatu iegāde | Jauns profils | Ienākt

Microsoft Office Specialist Study Guide: 2007 Microsoft Office System Edition [Multiple-component retail product]

3.67/5 (12 ratings by Goodreads)

Joyce Cox, Joan Preppernau

Formāts: Multiple-component retail product, 816 pages, height x width: 229x187 mm, Contains 1 Paperback / softback and 1 CD-ROM
Izdošanas datums: 20-Sep-2010
Izdevniecība: Microsoft Press,U.S.
ISBN-10: 0735649715
ISBN-13: 9780735649712

Citas grāmatas par šo tēmu:

Microsoft Office

Multiple-component retail product
Cena: 41,50 €*
* Šī grāmata vairs netiek publicēta. Jums tiks paziņota lietotas grāmatas cena
Šī grāmata vairs netiek publicēta. Jums tiks paziņota lietotas grāmatas cena.
Daudzums:
- - 1
  - 2
  - 3
  - 4
  - 5
  - 6
  - 7
  - 8
  - 9
  - 10
Ielikt grozā
Pievienot vēlmju sarakstam

Formāts: Multiple-component retail product, 816 pages, height x width: 229x187 mm, Contains 1 Paperback / softback and 1 CD-ROM
Izdošanas datums: 20-Sep-2010
Izdevniecība: Microsoft Press,U.S.
ISBN-10: 0735649715
ISBN-13: 9780735649712

Citas grāmatas par šo tēmu:

Microsoft Office

Permanent link: https://www.kriso.lv/db/9780735649712.html

Keywords:

Demonstrate your expertise with the 2007 Microsoft Office system! This comprehensive study guide covers all the Microsoft Office Specialist Study Guide exams for Microsoft Office, including Word 2007, Excel 2007, Outlook 2007, PowerPoint 2007, and Access 2007. For each exam, youll build the skills and knowledge measured by its objectives through a series of step-by-step exercises, practice questions, and real-world scenarios. Easy-to-follow screen shots and explanations bring key concepts to life and expertly guide you through the material. The CD includes the practice files for all the book's lessons. Earn the premier credential and showcase your expertise in the popular Microsoft Office programs!

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Taking a Microsoft Office Specialist Exam

xix

The Microsoft Business Certification Program

xix

Selecting a Certification Path

Test-Taking Tips

Certification Benefits

xxii

For More Information

xxii

Using this Book to Study for a Certification Exam

xxiii

Features and Conventions of this Book

xxiv

Additional Resources

xxiv

Working in the Microsoft Office Fluent User Interface

xxv

Using the Companion CD

xxvii

CD Contents

xxviii

Minimum System Requirements

xxxvi

Installing the Practice Files

xxxvii

Using the Practice Files

xxxviii

Removing and Uninstalling the Practice Files

xxxviii

Getting Help

xxxix

Getting Help with this Book and its Companion CD

xxxix

Getting Help with an Office Program

xxxix

More Information

Exam 77-601 Using Microsoft Office Word 2007

(170)

1 Creating and Customizing Documents

(34)

1.1 Create and format documents

(7)

Templates

(2)

Borders and Backgrounds

(2)

Themes

(3)

1.2 Lay out documents

(5)

Page Settings

(1)

Headers and Footers

(2)

Columns

(2)

1.3 Make documents and content easier to find

(12)

Properties

(1)

Tables of Contents

(3)

Indexes

(2)

Bookmarks

(1)

Cross-References

(2)

Hyperlinks

(3)

1.4 Personalize Word 2007

(7)

Common Settings

(3)

More Specialized Settings

(2)

Research Settings

(2)

Objective Review

(2)

2 Formatting Content

(30)

2.1 Format text and paragraphs

(19)

Character Formatting

(3)

Paragraph Formatting

(4)

Styles

(3)

Quick Styles

(2)

Style Sets

(1)

Line Breaks and Hyphenation

(2)

Tab Stops

(2)

Copying, Finding, and Clearing

(2)

2.2 Manipulate text

(6)

Copying and Moving

(2)

Paste Special

(1)

Finding and Replacing

(3)

2.3 Control pagination

(2)

Page Breaks

(1)

Sections

(1)

Objective Review

(2)

3 Working with Visual Content

(28)

3.1 Insert illustrations

(10)

Pictures

(2)

Shapes

(1)

SmartArt Diagrams

(2)

Charts

(2)

Sizing and Positioning

(3)

3.2 Format illustrations

(10)

Text Wrapping

(1)

Cropping

(1)

Rotating

(1)

Stacking Order

(1)

Grouping

(1)

Aligning and Distributing

(1)

Styles

(1)

Color

(3)

3.3 Format text graphically

(3)

WordArt

(1)

Drop Caps

(2)

3.4 Insert and modify text boxes

(2)

Objective Review

(2)

4 Organizing Content

(40)

4.1 Structure content by using Quick Parts

(7)

Building Blocks Organizer

(2)

Custom Quick Parts

100

(2)

Fields

102

(3)

4.2 Use tables and lists to organize content

105

(9)

Tables

105

(3)

Tabular Lists

108

(1)

Bulleted and Numbered Lists

109

(5)

4.3 Modify tables

114

(8)

Table Structure

114

(4)

Table Formatting

118

(2)

Text Alignment

120

(1)

Calculations

121

(1)

4.4 Insert and format references and captions

122

(6)

Bibliographies

122

(2)

Reference Tables

124

(2)

Footnotes and Endnotes

126

(2)

4.5 Merge documents and data sources

128

(7)

Documents

128

(3)

Labels

131

(1)

Envelopes

132

(3)

Objective Review

135

(2)

5 Reviewing Documents

137

(18)

5.1 Navigate documents

138

(6)

Navigation Tricks

138

(4)

Multiple Views

142

(2)

5.2 Compare and merge document versions

144

(2)

5.3 Manage tracked changes

146

(5)

Tracking

146

(2)

Reviewing

148

(3)

5.4 Insert, modify, and delete comments

151

(2)

Objective Review

153

(2)

6 Sharing and Securing Content

155

(16)

6.1 Prepare documents for sharing

156

(5)

File Formats

156

(2)

Compatibility Checker

158

(1)

Document Inspector

159

(2)

6.2 Control document access

161

(5)

Editing and Formatting Restrictions

161

(2)

Passwords

163

(1)

Rights Management

164

(1)

Finalizing

165

(1)

6.3 Attach digital signatures

166

(3)

Objective Review

169

(2)

Exam 77-602 Using Microsoft Office Excel 2007

171

(156)

1 Creating and Manipulating Data

175

(24)

1.1 Insert data by using Auto Fill

176

(6)

Filling Series

176

(4)

Copying Data

180

(2)

1.2 Ensure data integrity

182

(6)

Data Entry Restrictions

182

(3)

Input and Error Messages

185

(1)

Duplicate Rows

186

(2)

1.3 Modify cell contents and formats

188

(2)

1.4 Change worksheet views

190

(6)

Views

190

(1)

Zoom Level

191

(1)

Program Window Area

192

(1)

Freezing and Splitting

193

(2)

Multiple Windows

195

(1)

1.5 Manage worksheets

196

(1)

Hiding and Displaying

196

(1)

Moving and Copying

196

(1)

Objective Review

197

(2)

2 Formatting Data and Content

199

(36)

2.1 Format worksheets

200

(7)

Themes

200

(1)

Gridlines and Headings

201

(2)

Worksheet Tabs

203

(1)

Worksheet Background

204

(3)

2.2 Insert and modify rows and columns

207

(9)

Inserting and Deleting

207

(3)

Formatting

210

(1)

Hiding

211

(2)

Height and Width

213

(3)

2.3 Format cells and cell content

216

(11)

Built-in Number Formats

216

(1)

Custom Formats

217

(2)

Hyperlinks

219

(1)

Merged Cells

220

(2)

Formatting

222

(2)

Cell Styles

224

(3)

2.4 Format data as a table

227

(6)

Tables

227

(3)

Table Styles

230

(2)

Total Row

232

(1)

Objective Review

233

(2)

3 Creating and Modifying Formulas

235

(26)

3.1 Reference data in formulas

236

(6)

Cell References

236

(1)

Cell Ranges

237

(1)

Worksheet References

238

(1)

Workbook References

239

(1)

Named Ranges

239

(3)

3.2 Summarize data by using a formula

242

(4)

3.3 Summarize data by using subtotals

246

(2)

3.4 Conditionally summarize data by using a formula

248

(4)

3.5 Look up data by using a formula

252

(2)

3.6 Use conditional logic in a formula

254

(2)

3.7 Format or modify text by using formulas

256

(2)

3.8 Display and print formulas

258

(1)

Objective Review

259

(2)

4 Presenting Data Visually

261

(34)

4.1 Create and format charts

262

(5)

Plotting Charts

262

(3)

Layouts and Styles

265

(2)

4.2 Modify charts

267

(7)

Moving and Sizing

267

(2)

Editing Data

269

(1)

Chart Elements

270

(4)

4.3 Apply conditional formatting

274

(4)

4.4 Insert and modify illustrations

278

(6)

Pictures

278

(2)

SmartArt Diagrams

280

(2)

Shapes

282

(2)

4.5 Outline data

284

(3)

4.6 Sort and filter data

287

(6)

Sorting

287

(2)

Filtering

289

(4)

Objective Review

293

(2)

5 Collaborating and Securing Data

295

(32)

5.1 Manage changes to workbooks

296

(6)

Change Tracking

296

(3)

Comments

299

(3)

5.2 Protect and share workbooks

302

(8)

Passwords

302

(1)

Workbook Protection

303

(2)

Worksheet Protection

305

(1)

Workbook Sharing

306

(4)

5.3 Prepare workbooks for distribution

310

(6)

Properties

310

(1)

Document Inspector

311

(1)

Permissions

312

(1)

Digital Signatures

313

(2)

Finalizing

315

(1)

5.4 Save workbooks

316

(3)

File Formats

316

(2)

Compatibility Checker

318

(1)

5.5 Set print options for printing data, worksheets, and workbooks

319

(6)

Print Area

319

(1)

Page Breaks

320

(2)

Worksheet Layout

322

(2)

Headers and Footers

324

(1)

Objective Review

325

(2)

Exam 77-603 Using Microsoft Office PowerPoint 2007

327

(126)

1 Creating and Formatting Presentations

331

(26)

1.1 Create new presentations

332

(3)

Blank Presentations

332

(1)

Templates

332

(2)

Outlines

334

(1)

1.2 Customize slide masters

335

(9)

Slide Masters

335

(3)

Themes

338

(3)

Background

341

(3)

1.3 Add elements to slide masters

344

(4)

Layouts

344

(1)

Content Placeholders

344

(3)

Custom Elements

347

(1)

1.4 Create and change presentation elements

348

(3)

Slide Orientation and Size

348

(1)

Transitions

349

(2)

1.5 Arrange slides

351

(4)

Adding and Deleting

351

(2)

Slide Order

353

(2)

Objective Review

355

(2)

2 Creating and Formatting Slide Content

357

(38)

2.1 Insert and format text boxes

358

(9)

Text Boxes

358

(1)

Size and Position

359

(2)

Shape Formatting

361

(3)

Text Layout

364

(3)

2.2 Manipulate text

367

(11)

Basic Editing

367

(2)

Bulleted and Numbered Lists

369

(3)

Basic Formatting

372

(3)

WordArt

375

(3)

2.3 Add and link existing content to presentations

378

(10)

Ready-Made Slides

378

(1)

Sounds

379

(3)

Movies

382

(1)

Other Types of Files

383

(1)

Links

384

(4)

2.4 Apply, customize, modify, and remove animations

388

(5)

Built-in Animations

388

(1)

Custom Animations

389

(4)

Objective Review

393

(2)

3 Working with Visual Content

395

(28)

3.1 Create SmartArt diagrams

396

(3)

Independent Diagrams

396

(2)

Diagrams from Bulleted Lists

398

(1)

3.2 Modify SmartArt diagrams

399

(2)

Design Changes

399

(1)

Shape Changes

400

(1)

3.3 Insert illustrations and shapes

401

(5)

Pictures

401

(1)

Clip Art

402

(2)

Shapes

404

(2)

3.4 Modify illustrations

406

(4)

Picture and Clip Art Formatting

406

(3)

Shape Formatting

409

(1)

3.5 Arrange illustrations and other content

410

(5)

Size and Position

410

(3)

Stacking Order

413

(1)

Grouping

413

(1)

Alignment

414

(1)

3.6 Insert and modify charts

415

(5)

Basic Charts

415

(2)

Chart Elements

417

(1)

Chart Formatting

418

(2)

3.7 Insert and modify tables

420

(1)

Basic Tables

420

(1)

Table Editing and Formatting

420

(1)

Objective Review

421

(2)

4 Collaborating On and Delivering Presentations

423

(30)

4.1 Review presentations

424

(3)

Comments

424

(1)

Comment Review

425

(1)

Comment Management

425

(2)

4.2 Protect presentations

427

(3)

Digital Signatures

427

(1)

Passwords

428

(2)

4.3 Secure and share presentations

430

(8)

Document Inspector

430

(2)

Permissions

432

(1)

Compression

433

(1)

Finalizing

434

(1)

File Formats

434

(4)

4.4 Prepare printed materials

438

(5)

Handouts and Notes

438

(2)

Printing

440

(3)

4.5 Prepare for and rehearse presentation delivery

443

(8)

Slide Subsets

443

(2)

Rehearsals

445

(3)

Delivery Preparation

448

(3)

Objective Review

451

(2)

Exam 77-604 Using Microsoft Office Outlook 2007

453

(136)

1 Managing Messages

459

(32)

1.1 Create and send an e-mail message

460

(4)

Sending

460

(2)

Replying and Forwarding

462

(1)

Recalling

463

(1)

1.2 Create and manage your signature and automated messages

464

(5)

Signatures

464

(2)

Automated Messages

466

(3)

1.3 Manage e-mail message attachments

469

(3)

Attachments

469

(1)

Opening and Previewing

470

(1)

Saving

471

(1)

1.4 Configure e-mail message sensitivity and importance settings

472

(2)

Sensitivity

472

(1)

Importance

473

(1)

1.5 Configure e-mail message security settings

474

(6)

Permissions

474

(1)

Digital Signatures

475

(3)

Encryption

478

(2)

1.6 Configure e-mail message delivery options

480

(7)

Flags

480

(2)

Scheduled Deliveries and Expirations

482

(1)

Receipts

483

(1)

Reply Rerouting

484

(1)

E-Mail Polls

485

(2)

1.7 View e-mail messages

487

(2)

Reading Pane

487

(1)

Message Preview

487

(1)

Header Fields

488

(1)

Objective Review

489

(2)

2 Managing Scheduling

491

(34)

2.1 Create appointments, meetings, and events

492

(7)

Appointments

492

(2)

Events

494

(2)

Recurring Appointments and Events

496

(1)

Private Appointments and Events

497

(2)

2.2 Send meeting requests

499

(7)

Meeting Requests

499

(1)

Scheduling

500

(4)

Response Tracking

504

(2)

2.3 Update, cancel, and respond to meeting requests

506

(4)

Rescheduling and Canceling

506

(1)

Additional Attendees

507

(1)

Responding

508

(2)

2.4 Customize calendar settings

510

(4)

Work Week

510

(1)

Time Zones

511

(1)

Holidays

512

(2)

2.5 Share your calendar with other people

514

(6)

Free/Busy Information

514

(1)

Sharing

515

(1)

E-Mailing

516

(1)

Delegating

517

(1)

Publishing

518

(2)

2.6 View other calendars

520

(3)

Multiple Calendars

520

(1)

Other People's Calendars

521

(1)

Internet Calendars

522

(1)

Objective Review

523

(2)

3 Managing Tasks

525

(10)

3.1 Create and modify tasks, and mark tasks as complete

526

(4)

Tasks

526

(3)

Task Management

529

(1)

3.2 Accept, decline, assign, update, and respond to tasks

530

(3)

Task Assignments

530

(1)

Assignment Responses

531

(2)

Objective Review

533

(2)

4 Managing Contacts and Personal Contact Information

535

(18)

4.1 Create and modify contacts

536

(6)

Contact Address Lists

536

(1)

Contact Records

536

(6)

4.2 Edit and use an electronic business card

542

(4)

4.3 Create and modify distribution lists

546

(3)

4.4 Create a secondary address book

549

(2)

Objective Review

551

(2)

5 Organizing Information

553

(36)

5.1 Categorize Outlook 2007 items by color

554

(5)

Color Categories

554

(2)

Custom Categories

556

(1)

Automatic Color Display

556

(2)

Sorting

558

(1)

5.2 Create and manage Outlook 2007 data files

559

(3)

5.3 Organize mail folders

562

(10)

Folder Structure

562

(2)

Archiving

564

(3)

Sent Messages

567

(1)

Deleted Items

568

(1)

Junk Mail

569

(3)

5.4 Locate Outlook 2007 items by using the search feature

572

(6)

Instant Search

572

(2)

Query Builder

574

(1)

Search Folders

575

(3)

5.5 Create, modify, and remove rules to manage e-mail messages

578

(4)

5.6 Customize your Outlook 2007 experience

582

(5)

To-Do Bar

582

(1)

Default Message Format

582

(2)

Default Message Look

584

(1)

Outlook Anywhere

585

(2)

Objective Review

587

(2)

Exam 77-605 Using Microsoft Office Access 2007

589

(148)

1 Structuring a Database

595

(16)

1.1 Define data needs and types

596

(4)

Normal Forms

596

(1)

Data Types

597

(1)

Table Analyzer

598

(2)

1.2 Define and print table relationships

600

(6)

Relationships

600

(2)

Referential Integrity

602

(1)

Join Types

603

(1)

Relationship Report

604

(2)

1.3 Add, Set, change, or remove primary keys

606

(2)

1.4 Split databases

608

(1)

Objective Review

609

(2)

2 Creating and Formatting Database Elements

611

(46)

2.1 Create databases

613

(2)

2.2 Create tables

615

(3)

2.3 Modify tables

618

(3)

2.4 Create fields and modify field properties

621

(9)

New Fields

621

(2)

Properties

623

(1)

Input Masks

624

(2)

Validation Rules

626

(1)

Lookup Lists and Multivalued Fields

627

(3)

2.5 Create forms

630

(6)

Form Tools

630

(2)

Form Wizard

632

(1)

Manual Forms

633

(1)

PivotCharts and PivotTables

634

(2)

2.6 Create reports

636

(8)

Report Tool

636

(2)

Report Wizard

638

(2)

Manual Reports

640

(1)

Printing

640

(2)

Label Wizard

642

(2)

2.7 Modify the design of reports and forms

644

(11)

Controls

644

(2)

Layout

646

(4)

Formatting

650

(3)

AutoFormats

653

(2)

Objective Review

655

(2)

3 Entering and Modifying Data

657

(18)

3.1 Enter, edit, and delete records

659

(3)

Entering and Editing

659

(1)

Deleting

660

(2)

3.2 Navigate among records

662

(2)

3.3 Find and replace data

664

(3)

Finding

664

(1)

Wildcards

665

(1)

Replacing

665

(2)

3.4 Attach documents to and detach from records

667

(2)

3.5 Import data

669

(4)

Importing

669

(2)

Linking

671

(1)

Import Specifications

672

(1)

Objective Review

673

(2)

4 Creating and Modifying Queries

675

(22)

4.1 Create queries

676

(11)

Select Queries

676

(5)

Criteria

681

(2)

Action Queries

683

(2)

Subqueries

685

(2)

4.2 Modify queries

687

(8)

Table Changes

687

(1)

Parameters

688

(1)

Joins

689

(1)

Calculations

690

(5)

Objective Review

695

(2)

5 Presenting and Sharing Data

697

(24)

5.1 Sort data

698

(5)

Text vs. Numbers

698

(1)

Tables and Forms

699

(2)

Queries

701

(2)

5.2 Filter data

703

(6)

Simple Filters

703

(1)

Common Filters

704

(2)

Filter by Selection

706

(1)

Filter by Form

706

(3)

5.3 Create and modify charts

709

(3)

5.4 Export data

712

(3)

5.5 Save database objects as other file types

715

(3)

Earlier Access Formats

715

(1)

XPS Format

716

(1)

Database Objects

717

(1)

5.6 Print database objects

718

(1)

Objective Review

719

(2)

6 Managing and Maintaining Databases

721

(16)

6.1 Perform routine database operations

722

(5)

Exlusive Use

722

(1)

Backing Up

723

(1)

Problem Prevention

724

(2)

Link Repair

726

(1)

6.2 Manage databases

727

(8)

Passwords and Encryption

727

(1)

Database Options

728

(2)

Database Information

730

(5)

Objective Review

735

(2)

Index

737

Joan Lambert is the author of more than a dozen books about Microsoft Office and Windows, including several popular Step by Step titles from Microsoft Press. Joyce Cox has 20+ years experience developing training materials on technical subjects for non-technical audiences, including dozens of books about Office and Windows.

Microsoft Office Specialist Study Guide: 2007 Microsoft Office System Edition [Multiple-component retail product]

Konts un iestatījumi

Meklēšana

Meklēt datubāzē

Refine By

Tēmas Grāmatas angļu valodā

Izvēlieties iepirkumu grozu