I am preparing to hire a person for a position that requires versatile, flexible and solid spreadsheet skills. We use LO exclusively. There are many pre-employment spreadsheet tests specific to MS Excel. But many of the questions in those tests deal with Excel-specific features (such as the ribbon) that are not relevant to LO. Also many of the tests focus on trivial things like changing the cell color.
What would be be the best approach to pre-employment testing for LO Calc? I am mainly interested in testing a person’s competency with functions / formulas. I want to test whether a person can create spreadsheets to solve a specific problem and is able to draw upon knowledge of a wide variety of functions to accomplish the task.
Of the free tests I have found online (with minimal searching) this is the one I like the best so far:
Free Excel Tests Of Your Knowledge
http: //www.accessanalytic.c0m.au/Free-Financial-Excel.html?testname=Advanced%20Excel#exceltest
Does anyone know of something similar but longer (more questions)?
I’m willing to pay for this testing.
[Edit: de-fanged possible spammy link (not essential to Q)]