Home       Microsoft Office 2010      Microsoft Windows Server 2008        Web Page Design      Flash Animation       New 2008 Track      Register       About

Microsoft Excel 2010

Microsoft Exam 77-882

Course outline

 

About this Exam

This exam validates the skills needed to be proficient in Excel 2010.

Audience Profile

The Core-level Microsoft Office Excel 2010 User should be able to navigate Microsoft Office Excel 2010 software at the feature and functionality level. They should be familiar with and know how to use at least 80% of the features and capabilities of Microsoft Office Excel 2010. The core-level user should be able to use Microsoft Office Excel 2010 to create and edit professional-looking spreadsheets for a variety of purposes and situations. Users would include people from a wide variety of job roles from almost all areas of professional, student, and personal life. Some of the roles users might take on include, but are not limited to:

•       Accountants
•       Clerical, Office professionals
•       Consultants
•       Executives/Managers
•       Help desk personnel
•       Instructors/Trainers
•       Program/Project Managers
•       Sales
•       Students
•       Other members of the general population

Tasks that might be undertaken or work products created by members of the Microsoft Excel 2010 Core-level User Target Audience might include, but would not be limited to:

•       Charting
•       Create analytical, financial, etc. reports
•       Data entry
•       Family budget
•       Format numerical (financial, statistical, etc.) reports
•       Forms
•       Graphing
•       Process data
•       Reporting
•       Technical support
•       Trending

 

Credit Toward Certification

When you pass Exam 77-882: Excel 2010, you complete the requirements for the following certification(s):Microsoft Office Specialist: Microsoft Excel 2010

Skills Being Measured

This exam measures your ability to accomplish the technical tasks listed below.The percentages indicate the relative weight of each major topic area on the exam.

 

Managing the Worksheet Environment

  • Navigate through a worksheet.
    • This objective may include but is not limited to: Hot keys, name box
  • Print a worksheet or workbook.
    • This objective may include but is not limited to: printing only selected worksheets, printing an entire workbook, constructing headers and footers, and applying printing options (scale, print titles, page setup, print area, gridlines)
  • Personalize environment by using Backstage.
    • This objective may include but is not limited to: Manipulate the Quick Access Toolbar, manipulate the ribbon tabs and groups, manipulate Excel default settings, import data to Excel, import data from Excel, demonstrate how to manipulate workbook properties, manipulate workbook files and folders. apply different name and file formats for different uses by using save and save as features

Creating Cell Data

  • Construct cell data.
    • This objective may include but is not limited to: using paste special (formats, formulas, values, preview icons, transpose rows and columns, operations, comments, validation, paste as a link), and cutting, moving, and select cell data
  • Apply AutoFill.
    • This objective may include but is not limited to: Copy data using AutoFill, fill series using AutoFill, copy or preserve cell format with AutoFill, select from drop-down list
  • Apply and manipulate hyperlinks.
    • This objective may include but is not limited to: Create a hyperlink in a cell, modify hyperlinks, modify hyperlinked-cell attributes, remove a hyperlink

Formatting Cells and Worksheets

  • Apply and modify cell formats.
    • This objective may include but is not limited to: aligning cell content, applying a number format, wrapping text in a cell, and using Format Painter
  • Merge or split cells.
    • This objective may include but is not limited to: using Merge & Center, Merge Across, Merge cells, and Unmerge Cells
  • Create row and column titles.
    • This objective may include but is not limited to: Print row and column headings, print rows to repeat with titles, print columns to repeat with titles, configure titles to print only on odd or even pages, configure titles to skip the first worksheet page
  • Hide and unhide rows and columns.
    • This objective may include but is not limited to: Hide a column, unhide a column, hide a series of columns, hide a row, unhide a row, hide a series of rows
  • Manipulate Page Setup options for worksheets.
    • This objective may include but is not limited to: Configure page orientation, manage page scaling, configure page margins, change header and footer size
  • Create and apply cell styles.
    • This objective may include but is not limited to: Apply cell styles, construct new cell styles

Managing Worksheets and Workbooks

  • Create and format worksheets.
    • This objective may include but is not limited to: Insert worksheets, delete worksheets, copy, reposition, copy and move, rename, grouping, apply coloring to worksheet tabs, hiding worksheet tabs, unhiding worksheet tabs
  • Manipulate window views.
    • This objective may include but is not limited to: splitting window views, arranging window views, and opening a new window with contents from the current worksheet
  • Manipulate workbook views.
    • This objective may include but is not limited to: using Normal, Page Layout, and Page Break workbook views, and creating custom views

Applying Formulas and Functions

  • Create formulas.
    • This objective may include but is not limited to: Use basic operators, revise formulas
  • Enforce precedence.
    • This objective may include but is not limited to: Order of evaluation, precedence using parentheses, precedence of operators for percent vs. exponentiation
  • Apply cell references in formulas.
    • This objective may include but is not limited to: Relative, absolute
  • Apply conditional logic in a formula.
    • This objective may include but is not limited to: Create a formula with values that match your conditions, edit defined conditions in a formula, use a series of conditional logic values in a formula
  • Apply named ranges in formulas.
    • This objective may include but is not limited to: Define, edit and rename a named range
  • Apply cell ranges in formulas.
    • This objective may include but is not limited to: Enter a cell range definition in the formula bar, define a cell range using the mouse, define a cell range using a keyboard shortcut

Presenting Data Visually

  • Create charts based on worksheet data.
  • Apply and manipulate illustrations.
    • This objective may include but is not limited to: Clip Art, SmartArt, shapes, screenshots
  • Create and modify images by using the Image Editor.
    • This objective may include but is not limited to: making corrections to an image (sharpen or soften an image, changing brightness and contrast), using picture color tools, and changing artistic effects on an image
  • Apply Sparklines.
    • This objective may include but is not limited to: using Line, Column, and Win/Loss chart types, creating a Sparkline chart, customizing a Sparkline, formatting a Sparkline, and showing or hiding data markers

Sharing worksheet data with other users

  • Share spreadsheets by using Backstage.
    • This objective may include but is not limited to: sending a worksheet via E-mail or Skydrive, changing the file type to a different version of Excel, and saving as PDF or XPS
  • Manage comments.
    • This objective may include but is not limited to: inserting, viewing, editing, and deleting comments

Analyzing and Organizing Data

  • Filter data.
    • This objective may include but is not limited to: Define, apply, remove, search, filter lists using AutoFilter
  • Sort data.
    • This objective may include but is not limited to: using sort options (values, font color, cell color)
  • Apply conditional formatting.
    • This objective may include but is not limited to: Apply conditional formatting to cells, use the Rule Manager to Apply Conditional Formats, use the IF Function and Apply Conditional Formatting, icon sets, data bars, clear rules

 

 

 

Skills Being MeasuredThis exam measures your ability to accomplish the technical tasks listed below.The percentages indicate the relative weight of each major topic area on the exam.

 

Managing the Worksheet Environment

·         Navigate through a worksheet.

o    This objective may include but is not limited to: Hot keys, name box

·         Print a worksheet or workbook.

o    This objective may include but is not limited to: printing only selected worksheets, printing an entire workbook, constructing headers and footers, and applying printing options (scale, print titles, page setup, print area, gridlines)

·         Personalize environment by using Backstage.

o    This objective may include but is not limited to: Manipulate the Quick Access Toolbar, manipulate the ribbon tabs and groups, manipulate Excel default settings, import data to Excel, import data from Excel, demonstrate how to manipulate workbook properties, manipulate workbook files and folders. apply different name and file formats for different uses by using save and save as features

Creating Cell Data

·         Construct cell data.

o    This objective may include but is not limited to: using paste special (formats, formulas, values, preview icons, transpose rows and columns, operations, comments, validation, paste as a link), and cutting, moving, and select cell data

·         Apply AutoFill.

o    This objective may include but is not limited to: Copy data using AutoFill, fill series using AutoFill, copy or preserve cell format with AutoFill, select from drop-down list

·         Apply and manipulate hyperlinks.

o    This objective may include but is not limited to: Create a hyperlink in a cell, modify hyperlinks, modify hyperlinked-cell attributes, remove a hyperlink

Formatting Cells and Worksheets

·         Apply and modify cell formats.

o    This objective may include but is not limited to: aligning cell content, applying a number format, wrapping text in a cell, and using Format Painter

·         Merge or split cells.

o    This objective may include but is not limited to: using Merge & Center, Merge Across, Merge cells, and Unmerge Cells

·         Create row and column titles.

o    This objective may include but is not limited to: Print row and column headings, print rows to repeat with titles, print columns to repeat with titles, configure titles to print only on odd or even pages, configure titles to skip the first worksheet page

·         Hide and unhide rows and columns.

o    This objective may include but is not limited to: Hide a column, unhide a column, hide a series of columns, hide a row, unhide a row, hide a series of rows

·         Manipulate Page Setup options for worksheets.

o    This objective may include but is not limited to: Configure page orientation, manage page scaling, configure page margins, change header and footer size

·         Create and apply cell styles.

o    This objective may include but is not limited to: Apply cell styles, construct new cell styles

Managing Worksheets and Workbooks

·         Create and format worksheets.

o    This objective may include but is not limited to: Insert worksheets, delete worksheets, copy, reposition, copy and move, rename, grouping, apply coloring to worksheet tabs, hiding worksheet tabs, unhiding worksheet tabs

·         Manipulate window views.

o    This objective may include but is not limited to: splitting window views, arranging window views, and opening a new window with contents from the current worksheet

·         Manipulate workbook views.

o    This objective may include but is not limited to: using Normal, Page Layout, and Page Break workbook views, and creating custom views

Applying Formulas and Functions

·         Create formulas.

o    This objective may include but is not limited to: Use basic operators, revise formulas

·         Enforce precedence.

o    This objective may include but is not limited to: Order of evaluation, precedence using parentheses, precedence of operators for percent vs. exponentiation

·         Apply cell references in formulas.

o    This objective may include but is not limited to: Relative, absolute

·         Apply conditional logic in a formula.

o    This objective may include but is not limited to: Create a formula with values that match your conditions, edit defined conditions in a formula, use a series of conditional logic values in a formula

·         Apply named ranges in formulas.

o    This objective may include but is not limited to: Define, edit and rename a named range

·         Apply cell ranges in formulas.

o    This objective may include but is not limited to: Enter a cell range definition in the formula bar, define a cell range using the mouse, define a cell range using a keyboard shortcut

Presenting Data Visually

·         Create charts based on worksheet data.

·         Apply and manipulate illustrations.

o    This objective may include but is not limited to: Clip Art, SmartArt, shapes, screenshots

·         Create and modify images by using the Image Editor.

o    This objective may include but is not limited to: making corrections to an image (sharpen or soften an image, changing brightness and contrast), using picture color tools, and changing artistic effects on an image

·         Apply Sparklines.

o    This objective may include but is not limited to: using Line, Column, and Win/Loss chart types, creating a Sparkline chart, customizing a Sparkline, formatting a Sparkline, and showing or hiding data markers

Sharing worksheet data with other users

·         Share spreadsheets by using Backstage.

o    This objective may include but is not limited to: sending a worksheet via E-mail or Skydrive, changing the file type to a different version of Excel, and saving as PDF or XPS

·         Manage comments.

o    This objective may include but is not limited to: inserting, viewing, editing, and deleting comments

Analyzing and Organizing Data

·         Filter data.

o    This objective may include but is not limited to: Define, apply, remove, search, filter lists using AutoFilter

·         Sort data.

o    This objective may include but is not limited to: using sort options (values, font color, cell color)

·         Apply conditional formatting.

o    This objective may include but is not limited to: Apply conditional formatting to cells, use the Rule Manager to Apply Conditional Formats, use the IF Function and Apply Conditional Formatting, icon sets, data bars, clear rules