Study

Only available on StudyMode
  • Download(s) : 25
  • Published : April 18, 2013
Open Document
Text Preview
Certiprep Excel 2007 Practice Test Score Report
CANDIDATE: EXAM: Alex Harris Certiprep Excel 2007 DATE: 12/30/2011

Your Score 0 500 1000

YOUR SCORE: 372
Section Analysis Creating and Manipulating Data Formatting Data and Content Creating and Modifying Formulas Presenting Data Visually Collaborating and Securing Data Percent Correct 33% 60% 18% 25% 50%

Certiprep Practice Test This report contains information designed to help you prepare for your Microsoft Office Specialist exams. Use the attached Study Guide as a reference to help you plan which exam objectives require further study. When you are ready to take your Certification Exam, please contact a Certiport Certified Testing Center.

Alex Harris 2200 N Central Ave Phoenix AZ 85002

ID: ttystudent4 aharris@trainingtoyou.com Exam reference #: 8750959

Courseware Series: Step by Step Courseware Series

Certiprep Excel 2007
General Resources
eLearning: Collection 5259 - Core training on Microsoft Office Excel 2007 https://www.microsoftelearning.com/catalog/homeAndOffice.aspx Book: Microsoft® Office Excel® 2007 Step by Step (ISBN: 9780735623040) http://www.microsoft.com/mspress/books/9612.aspx

Objectives marked with this icon indicate areas of proficency Objectives marked with this icon indicate areas requiring additional study

Creating and Manipulating Data
Objective Competency Learning Resources eLearning: Course 5425 - Getting Started with Microsoft Office Excel 2007 Book: Microsoft Office Excel 2007 Step by Step - Chapter 3: Working with Data and Data Tables

Insert data by using AutoFill

0%

Ensure data integrity Modify cell contents and formats Change Worksheet Views Manage worksheets

0%

eLearning: Course 5428 - Filtering and Summarizing Data in Microsoft Office Excel 2007 Book: Microsoft Office Excel 2007 Step by Step - Chapter 6: Focusing on Specific Data Using Filters

100%

eLearning: Course 5425 - Getting Started with Microsoft Office Excel 2007 Book: Microsoft Office Excel 2007 Step by Step - Chapter 3: Working with Data and Data Tables

100%

eLearning: Course 5425 - Getting Started with Microsoft Office Excel 2007 Book: Microsoft Office Excel 2007 Step by Step - Chapter 1: What is New in Excel 2007 Book: Microsoft Office Excel 2007 Step by Step - Chapter 2: Setting Up a Workbook

0%

eLearning: Course 5425 - Getting Started with Microsoft Office Excel 2007 Book: Microsoft Office Excel 2007 Step by Step - Chapter 2: Setting Up a Workbook

Formatting Data and Content
Objective Competency Learning Resources

Left click on the blue underlined links to view the related WEB page Copyright 2009 Certiport Inc. Alex Harris

Format worksheets Insert and modify rows and columns

50%

eLearning: Course 5427 - Formatting and Printing Worksheets in Microsoft Office Excel 2007 Book: Microsoft Office Excel 2007 Step by Step - Chapter 2: Setting Up a Workbook Book: Microsoft Office Excel 2007 Step by Step - Chapter 5: Changing Document Appearance

100%

eLearning: Course 5425 - Getting Started with Microsoft Office Excel 2007 Book: Microsoft Office Excel 2007 Step by Step - Chapter 2: Setting Up a Workbook

Format cells and cell content

50%

eLearning: Course 5427 - Formatting and Printing Worksheets in Microsoft Office Excel 2007 Book: Microsoft Office Excel 2007 Step by Step - Chapter 14: Working with Other Microsoft Office System Programs Book: Microsoft Office Excel 2007 Step by Step - Chapter 5: Changing Document Appearance

Format data as a table

50%

eLearning: Course 5427 - Formatting and Printing Worksheets in Microsoft Office Excel 2007 Book: Microsoft Office Excel 2007 Step by Step - Chapter 3: Working with Data and Data Tables Book: Microsoft Office Excel 2007 Step by Step - Chapter 5: Changing Document Appearance

Creating and Modifying Formulas
Objective Competency Learning Resources eLearning: Course 5426 - Performing Calculations on Data in Microsoft Office Excel 2007 Book:...
tracking img