What Actually Shows Up on a Basic Computer Skills Assessment

You're looking at a test that checks whether someone can do the mundane parts of a job without needing someone to hover over their shoulder. File creation, folder organization, basic spreadsheets, typing speed, email navigation. That's it. But the execution varies wildly depending on who built the test and why. I've been administering these assessments for a while now, mostly in hiring contexts where the HR team gets desperate about remote workers who can't figure out shared drives. The tests themselves are usually web-based platforms like TestGorilla or HireVue, though some smaller companies still use emailed PDFs with screenshot-based questions, which is a mistake waiting to happen.

Basic Computer Skills Assessment Format and What to Expect

A typical assessment runs between 20 and 40 minutes. The sections usually break down into typing speed and accuracy, Microsoft Office or Google Workspace navigation, basic troubleshooting scenarios, and sometimes a short reading comprehension piece tied to a tech context. The typing portion alone accounts for most drop-off rates, which is worth noting if you're designing your own test. Here's something most people miss when preparing for one. The typing section isn't just about WPM. It's about consistent accuracy under time pressure, and the scoring penalizes corrections heavily. I had a candidate once who typed at 85 words per minute but scored in the bottom quartile because she backspaced through every error instead of retyping the line. The platform registered 142 correction events. She couldn't understand the result until we walked through the scoring breakdown together. The spreadsheet questions tend to be deceptively simple on the surface. You'll get a table and be asked to sort a column, apply a filter, or write a basic formula. Sum, average, vlookup, conditional formatting. If you haven't opened Excel in six months, you will freeze up at vlookup syntax. I recommend opening the actual application and doing it blind, not just reading about it.

How I Built a Practical Basic Computer Skills Assessment for My Team

When the third candidate failed the public version of the test despite claiming two years of daily spreadsheet work, I stopped using off-the-shelf assessments and built our own. The industry standard tests have a known flaw: they measure familiarity with a specific platform interface, not actual competence. Someone who spent two years in Google Sheets will struggle with an Excel-based assessment and score poorly, even though their skills transfer perfectly. I designed a 30-minute assessment with four sections. The first was a timed typing passage with intentional punctuation and numbers embedded, because most real-world typing tasks aren't pure letter strings. The second section used a spreadsheet with intentionally messy data and asked candidates to clean and summarize it. The third was a scenario-based troubleshooting block where you describe a problem and the test-taker picks from multiple response options. The final section was a file management exercise where you drag and drop documents into the correct folders within a simulated operating system interface. The scenario section took the most time to write. Each question needed a plausible wrong answer that looked reasonable to someone who only knows the surface-level fix. I spent about eight hours across two weeks drafting 24 questions. The payoff was that our new assessment predicted on-the-job performance significantly better than the commercial tools we'd been using, and the false rejection rate dropped from roughly 18 percent to under 7 percent.

Get the Full Details

Basic Computer Skills Assessment Indeed at William Rohde blog
Basic Computer Skills Assessment Indeed at William Rohde blog

Pitfalls to Watch For

Browser compatibility is the most overlooked issue. Some assessments only work reliably in Chrome. If you're building one, test it in Firefox and Safari before deploying. I lost a good candidate once because her company-issued machine defaulted to Edge, and the drag-and-drop component simply didn't respond to her inputs. She got a failing score on a section she could have aced. We caught it too late and had to redo the entire thing, which cost us three weeks of hiring delay. Another problem is time limits that don't account for accessibility needs. A 20-minute typing test is fine for most people. It becomes a legal and ethical problem if you don't build in standard accommodations or if your assessment platform doesn't support screen readers. I've seen assessments that are completely unusable with keyboard navigation, which automatically disqualifies anyone who relies on assistive technology. The scoring rubric matters more than the questions themselves. A platform that weights typing speed at 60 percent of the total score will produce skewed results for any role where typing accuracy matters more than speed. I recalibrated our assessment so that the spreadsheet and troubleshooting sections carried equal weight to typing, which shifted the average score distribution noticeably and filtered for a more relevant skill set.

What Works Best When You're Preparing for One

Don't study the assessment format. Study the underlying skills. Practicing with a specific test builder won't help if the actual assessment uses a different interface. Instead, open Excel or Google Sheets and do real tasks. Create a budget. Merge two lists. Build a pivot table. Close the application and do it again from memory. That's the difference between recognizing a button and knowing what the button actually does. For the typing section, practice with varied content. Not just lorem ipsum paragraphs. Include phone numbers, dates, email addresses, and technical terms. Most real typing tasks in a work environment mix formats, and the assessment should reflect that. If you're the one building the assessment rather than taking it, avoid the temptation to make it longer. A 45-minute Basic Computer Skills Assessment produces fatigue-based errors that look like skill gaps. Thirty minutes is the sweet spot. Beyond that, you're measuring endurance, not competence.

There's also no substitute for giving candidates a practice question before the real thing starts. Even one sample question reduces anxiety-driven mistakes by a meaningful amount, and it surfaces technical issues with the platform itself before you've committed to a score. The best assessments I've seen share one trait: they feel like work. Not like a puzzle. Not like a trivia quiz. Like a realistic slice of the actual job, compressed into a tight timeframe. Everything else is just a certification exercise that looks good on paper and tells you nothing about whether the person can open a folder, save a file, and fix a sorting error without panicking.

(DOC) Basic Computer Skills Self-Assessment
(DOC) Basic Computer Skills Self-Assessment