MOS - Using Microsoft Office Excel 2007

Code: 77-602

Exam 77-602 – MOS - Using Microsoft Office Excel 2007

Skills measured

This exam measures your ability to accomplish the technical tasks listed below.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Create and manipulate data

  • Insert data by using AutoFill, ensure data integrity, modify cell contents and formats, change worksheet views, manage worksheets

Format data and content

  • Format worksheets, insert and modify rows and columns, format cells and cell content, format data as a table

Create and modify formulas

  • Reference data in formulas, summarize data by using a formula, summarize data by using subtotals, conditionally summarize data by using a formula, look up data by using a formula, use conditional logic in a formula, format or modify text by using formulas, display and print formulas

Present data visually

  • Create and format charts, modify charts, apply conditional formatting, insert and modify illustrations, outline data, sort and filter data

Collaborate on and secure data

  • Manage changes to workbooks, protect and share workbooks, prepare workbooks for distribution, save workbooks, set print options for printing data, worksheets, and workbooks

Guaranteed to Run

2018-03-20 09:00 to 2018-03-23 17:00
Palm Beach County Florida (Instructor-Led)
2018-03-19 09:00 to 2018-03-23 17:00
Secaucus, New Jersey (Virtual Instructor-Led)
2018-03-01 09:00 to 2018-03-02 17:00
Palm Beach County Florida (Instructor-Led)

Course Reviews

No reviews found for this course.

Be the first to write a review