Computer Literacy - Microsoft Excel Skills

Students should be familiar with the skills listed below for the Excel portion of the exam.

Working with Cells and Cell Data

  • Insert a cell
  • Delete selected cells
  • Merge cells
  • Split cells
  • Move cells
  • Insert columns and rows
  • Copy cells
  • Delete rows and columns
  • Center across selection
  • Edit text in cells
  • Edit numbers in cells
  • Apply number formats (currency and percent)
  • Apply number formats (dates and comma)
  • Clear cell content
  • Clear cell formats
  • Check spelling in a worksheet
  • Use find and replace to change cell contents
  • Go to a specific cell

Managing Workbooks

  • Locate and open existing workbooks
  • Use Save
  • Close a workbook and exit Excel
  • Create a workbook from a template
  • Use Save As to store workbooks to different locations/unique name/alternate file format

Formatting and Printing Workbooks

  • Change fonts
  • Apply bold, italics, underline
  • Change the font color
  • Add borders
  • Set cell color
  • Right align cells
  • Hide rows and columns
  • Unhide columns
  • Modify column widths
  • Modify worksheet orientation
  • Add headers to worksheets
  • Change margins in Page Setup
  • Add page numbering
  • Control page breaks
  • Print a worksheet
  • Print-preview a worksheet
  • Formatting cells before entering data

Modifying Worksheets

  • Insert worksheets into a workbook
  • Delete a worksheet from a workbook

Creating and Revising Formulas

  • Create formulas using the formula bar
  • Edit a formula
  • Use relative references
  • Create formulas using the SUM function
  • Create formulas using the MIN function
  • Create formulas using the MAX function
  • Create formulas using the AVERAGE function
  • Entering formulas using Point mode

Creating and Modifying Graphics

  • Create charts using the pie chart types
  • Create charts using column chart types
  • Edit a chart
  • Position a chart
  • Print a chart