SimNet TestPrep Course – Microsoft Office Excel 2007
Master the skills necessary to be proficient in Excel 2007 and pass Microsoft Certification Exam 77-602
to become a Microsoft Certified Application Specialist.
No previous experience required.
System requirements: High-speed Internet, Adobe Flash Player 9 or higher, either IE 6.0 or higher or Firefox 2.0 or higher.
Microsoft Office is not needed.
This lesson plan has been designed to thoroughly teach Microsoft Excel 2007 from top to bottom, for all skill levels.
The lesson plan should take approximately 13 hours, and can be taken at your own pace. LEAP in today.
| LESSON # |
LESSON TITLE |
# TASKS |
| 01 |
Introduction to Excel 2007 |
3 |
| 02 |
Working with Cells and Cell Data |
10 |
| 03 |
Formatting Worksheets |
11 |
| 04 |
Managing Workbooks |
8 |
| 05 |
Setting up Workbooks for Printing |
9 |
| 06 |
Working with Formulas and Functions |
13 |
| 07 |
Organizing Data |
14 |
| 08 |
Working with Charts and Graphs |
6 |
| 09 |
Working with Others |
5 |
The pre-tests directly correlate to the lesson plan and can be taken at anytime throughout your course.
The TestPrep pre-test covers a random subset of all skills taught in the entire lesson plan.
The TestPrep pre-test should be taken and passed multiple times before attempting the Microsoft Certification Exam.
LEAP in today.
| EXAM # |
EXAM TITLE |
# QUESTIONS |
| 01 |
Introduction to Excel 2007 |
3 |
| 02 |
Working with Cells and Cell Data |
11 |
| 03 |
Formatting Worksheets |
11 |
| 04 |
Managing Workbooks |
9 |
| 05 |
Setting up Workbooks for Printing |
9 |
| 06 |
Working with Formulas and Functions |
13 |
| 07 |
Organizing Data |
14 |
| 08 |
Working with Charts and Graphs |
6 |
| 09 |
Working with Others |
5 |
| testprep |
Excel 2007 TestPrep |
82 |
Listed below are the Microsoft Certification Exam objectives and where they can be found in the SimNet TestPrep lessons and exams.
LEAP in today.
| OBJECTIVE |
SKILL NAME |
LESSON |
PRE-TEST |
| 1 |
Creating and Manipulating Data |
| 1.1 |
Insert data using AutoFill |
02 |
02, TestPrep |
| 1.2 |
Ensure data integrity
|
07 |
07, TestPrep |
| 1.3 |
Modify cell contents and formats |
02 |
12, TestPrep |
| 1.4 |
Change Worksheet Views
|
03, 04, 05 |
03, 04, 05, TestPrep |
| 1.5 |
Manage worksheets |
04 |
04, TestPrep |
| 2 |
Formatting Data and Content |
| 2.1 |
Format worksheets
|
03, 04 |
03, 04, TestPrep |
| 2.2 |
Insert and modify rows and columns |
02, 03 |
02, 03, TestPrep |
| 2.3 |
Format cells and cell content
|
02, 03 |
02, 03, TestPrep |
| 2.4 |
Format data as a table |
07 |
07, TestPrep |
| 3 |
Creating and Modifying Formulas |
| 3.1 |
Reference data in formulas
|
06, 07 |
06, 07, TestPrep |
| 3.2 |
Summarize data using a formula |
06 |
06, TestPrep |
| 3.3 |
Summarize data using subtotals
|
n/a |
|
| 3.4 |
Conditionally summarize data using a formula |
n/a |
|
| 3.5 |
Look up data using a formula
|
06 |
06, TestPrep |
| 3.6 |
Use conditional logic in a formula |
06 |
06, TestPrep |
| 3.7 |
Format or modify text using formulas
|
06 |
06, TestPrep |
| 3.8 |
Display and print formulas |
n/a |
|
| 4 |
Presenting Data Visually |
| 4.1 |
Create and format charts
|
08 |
08, TestPrep |
4.2 |
Modify charts |
08 |
08, TestPrep |
| 4.3 |
Apply conditional formatting
|
07 |
07, TestPrep |
4.4 |
Insert and modify illustrations |
08 |
08, TestPrep |
| 4.5 |
Outline data
|
07 |
07, TestPrep |
| 4.6 |
Sort and filter data |
07 |
07, TestPrep |
| 5 |
Collaborating and Securing Data
|
| 5.1 |
Manage changes to workbooks |
09 |
09, TestPrep |
| 5.2 |
Protect and share workbooks
|
09 |
09, TestPrep |
| 5.3 |
Prepare workbooks for distribution |
09 |
09, TestPrep |
| 5.4 |
Save workbooks
|
n/a |
|
| 5.5 |
Set print options for printing data, worksheets and workbooks |
03, 05 |
03, 05, TestPrep |
Business Certification Courseware
SimNet TestPrep for Microsoft Office 2007 is an e-learning system (no download or installation required!) designed to prepare candidates for Microsoft Business Certification exams. TestPrep provides three years of access to comprehensive, self-paced courses in each of the Microsoft Office 2007 applications and Windows Vista. All TestPrep courses include multiple lessons, practice exams, and a TestPrep exam covering all topics.
|