Home > Community Education > Skills Assessment > Microsoft Excel
Can you open, save and print a worksheet?
Yes
No
Can you edit cell entries and work with ranges?
Can you enter formulas?
Can you copy and move cell entries?
Can you copy cell entries by filling down or right?
Can you copy formulas with relative cell references?
Can you copy formulas with absolute cell references?
Can you name and move a worksheet?
Can you change fonts and font sizes?
Can you merge cells?
Can you adjust column widths?
Can you insert and delete rows and columns?
Can you apply colors, patterns and borders?
Can you use conditional formatting (e.g. if the value is greater than 2500 and change it to green)?
Can you check spelling?
Can you create a chart?
Can you move and resize a chart?
Can you format a chart?
Can you add text to x and y axes?
Can you annotate and draw on a chart?
Can you use financial functions (FV and PMT)?
Can you use logical functions (IF)?
Can you create and modify lines and objects?
Can you import data from other applications?
Can you use Lookup functions (HLOOKUP or VLOOKUP) ?
Can you link cells between different workbooks?
Can you use the goal seeker & solver?