No. Those tests are private and we don't copy them. We cover the same skills, in the same formats, using public test guides and job descriptions. If you can do our exercises without hints, you can do theirs.

No. Everything runs in your browser. The grid here is simpler than Excel, which is on purpose: it tests whether you know the formula, not whether you can find a menu.

SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, IF, IFERROR, AND, OR, NOT, ROUND, ROUNDUP, ROUNDDOWN, ABS, LEN, UPPER, LOWER, PROPER, TRIM, LEFT, RIGHT, MID, CONCATENATE, the & join operator, VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, DATE, YEAR, MONTH, DAY, EOMONTH, DATEDIF and arithmetic.

Your formula runs on the live data and the result is compared to the correct result. So =SUM(B2:B7) and =B2+B3+B4+B5+B6+B7 both pass. When you're wrong, the site looks at your formula for common mistakes, like including the header row, and tells you what to fix.

You can try. Press New numbers on any exercise and the data reshuffles. The grader recomputes the correct answer each time, so only the right logic passes.

Not in the browser grid. For those, the full version would use short screen-recorded walkthroughs and a checklist, since those skills are about the Excel interface, not formulas.

Most people with some Excel experience are ready after about three hours spread over a week. Beginners should plan on two weeks of short daily sessions.