Microsoft Excel Placement Self-Assessment

Determine your level of Excel knowledge by assessing the lists below.

Excel 1

Requires no prior knowledge of MS Excel.

EXCEL 2

Requires prior knowledge of:

  • How to open, save and print workbooks.
  • Formatting cell contents (i.e. font face, size, color)
  • Formatting cells (i.e. boarders, fill)
  • Formatting numbers (i.e. time, date, currency)
  • Enter basic calculations in Excel (i.e. addition, subtraction)
  • Enter basic functions in Excel (i.e. SUM)

Excel 3

Requires prior knowledge of:

  • How to open, save and print workbooks.
  • Formatting cell contents (i.e. font face, size, color)
  • Formatting cells (i.e. boarders, fill)
  • Formatting numbers (i.e. time, date, currency)
  • Absolute and relative cell references
  • Excel formula syntax and operators (i.e. multiplication, division, addition)
  • Enter a variety of functions in Excel with ease (i.e. statistical, logical)

Please note: Knowledge of tables is not required; however, this concept is covered in Excel 2.