Job Interview with Excel Test

Here are some things you should know how to on Excel for an interview.  Be sure to familiarize yourself with the interface of both Excel 2003 and Excel 2007 and up.

1.  Open, Save As, Rename, Protect Sheet
2.  Undo, Paste Special, Replace All, Sort, Filter
3.  Print Preview, Margins, Orientation, Freeze Panes

4.  Math functions: arithmetic, sum, sumproduct, mean, variance
5.  Formatting: Conditional formatting, decimals, currency, font, border
6.  Pivot tables, VLOOKUP, HLOOKUP, absolute cell reference

7.  Macros
8.  VBA Programming
9.  Data Analysis Tools, Solver

Leave A Reply

Your email address will not be published.