文档介绍：MOS Study
Guide
2010
John Pierce
For Microsoft®
Excel® Expert
ContentsSetting Options for Iterative Calculations . . . . . . . . . . . . . . . . . 39
Perform Data Summary Tasks . . . . . . . . . . . . . . . . . . . . . . 41
Taking a SummingMicrosoft Data Office with the SUMIF and SUMIFS Functions . . . . . . . . . . . 41
SpecialistUnderstanding Exam . . . . .and . . Defining. . . . . . .Array . . .Formulas . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . 43vii
Apply Functions Office Specialist in Formulas Certification . . . . .. . .. .. .. . .. .. .. . . . .. .. .. .. .. . .. . . . . .48vii
SelectingUsing Built-ina Certification Functions Path . . . . .. .. .. .. .. .. .. . .. .. .. . .. .. .. . . . .. .. . . . . . . . 48vii
Test-TakingCorrecting Tips Function . . . . .Errors . . . .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. .. . . . . . 50viii
ObjectiveCertification Review Benefits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52 ix
PresentingFor More Data Information Visually . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53 x
3 Using This Book to Study
Apply Advanced Chart Features . . . . . . . . . . . . . . . . . . . . . 53
for a Certification Exam . . . . . . . . . . . . . . . . . . . . . . . . . . . . . x
Adding Trendlines to Data . . . . . . . . . . . . . . . . . . . . . . . 54
Features and Conventions of This Book . . . . . . . . . . . . . . . . . . . . . xi
Using a Chart Template . . . . . . . . . . . . . . . . . . . . . . . . 58
Using the Book’panion Content . . . . . . . . . . . . . . . . . . . . . . xii
Visualizing the Data in a Cell by Using Sparklines . . . . . . . . . . . . . 59
Modifying the Display of the Ribbon . . . . . . . . . . . . . . . . . . . . . . xii MOS 2010 Study Guide
Creating Dual-Axes Charts . . . . . . . . . . . . . . . . . . . . . . . 64
How to Get Support and Provide Feedba