Excel Study Guide - Computer Skills Assessment

Below is a list of objectives covered in the Excel Computer Skills Assessment. Each of the questions in the assessment requires the completion of multiple tasks and an example has been included.

  • Annotating, ranges (move, copy, name)
  • Portrait & landscape
  • Apply borders and shading
  • Print a Worksheet
  • Apply Number Formats
  • Print and Hide Formulas
  • Change column/row, Use AutoFit
  • Recording macros
  • Change the Tab Color of a Worksheet
  • Relative and Absolute references
  • Clear contents and format
  • Rename Worksheets
  • Compute Totals with AutoSum
  • Solver, goal seek & data analysis tools
  • Conditional Formatting
  • Start Excel and Name and Save a Workbook
  • Copy, Paste, and Move Cell Contents
  • Style, size, alignment, patterns & colors
  • Create and edit a Chart
  • Undo to correct Typing Errors
  • Data tables (one-way and two-way)
  • Use AutoComplete
  • Enter Text and Numbers
  • Use Format Painter
  • Fill a Series with Auto Fill
  • Use Merge and Center
  • Freeze columns and rows
  • Use Spelling Checker
  • Hiding and protecting worksheet areas
  • Use SUM MIN and MAX functions
  • Insert Custom Header and Footer
  • Use the IF Function
  • Insert/delete a Row/column
  • Wrap Text in a Cell
  • Navigate Among Worksheets

Example Question

In Cell A3 and lower shows a list of students and their grades:

  • Format the range of all the Grades with Conditional formatting, so it shows the cells that have a score Less Than 70 with a Highlight, Light Red Fill with Dark Red Text.
  • In cell B20 calculate the highest (maximum) score with the MAX-function.
  • In cell B21 calculate the lowest (minimum) score with the MIN-function.
  • In cell B22 calculate the average score with the AVERAGE-function.

Suggested Training material

Office.microsoft.com Support website provides training video and practice.
Start with Create your first Excel 2013 workbook or the Excel 2010 training Create your first spreadsheet
Training courses for Excel 2010 such as:

  • How to create a basic chart in Excel 2010
  • Use Excel tables to manage information
  • Understand data at a glance with conditional formatting
  • The IF function: what it is, and how to use it